SQL*plus ( to Oracle)

How to use from delta.cs.uwindsor.ca

Troubleshooting

Login problems

Oracle database user accounts and passwords are created, synchronized, or unlocked from the CS Password Utility.

Make sure you are using your UWinID as your <user-name>, all lowercase without @uwindsor.ca appended.

If your password does not meet the following restrictions, you MUST enclose your password in double quotation marks when prompted.

The password restrictions for Oracle account passwords are as follows:

• Passwords cannot contain quotation marks.
• Passwords are case sensitive.
• A password must begin with an alphabetic character.
• Passwords can contain only alphanumeric characters and the underscore (_), dollar sign ($), and pound sign (#).
• Password may NOT contain the @ character.
• Oracle strongly discourages you from using $ and #.

Common Errors

ERROR:
ORA-01017: invalid username/password; logon denied

Your password meets the character requirements, but you typed in the wrong password.

Synchronize your password again using the CS Password Utiliity.

ERROR:
ORA-12532: TNS:invalid argument

Your password contains characters, probably @, that require you to enclose it within double quotation marks.

Running sqlplus from your machine at home

Install Oracle client. Use Global Protect VPN and sign in to campus.

Just type sqlplus at a terminal window prompt.

It uses the following tnsnames.ora to establish the connection with the CS01 instance on oracle.cs.uwindsor.ca:

CS01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.cs.uwindsor.ca)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = cs01)
    )
  )