SQL*plus

Troubleshooting

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

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

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)
    )
  )

SQL*plus

Troubleshooting

Login problems

Running sqlplus