# SQL*plus ( to Oracle)

### How to use from delta.cs.uwindsor.ca

[![MicrosoftTeams-image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2024-01/scaled-1680-/microsoftteams-image.png)](https://itfaq.cs.uwindsor.ca/uploads/images/gallery/2024-01/microsoftteams-image.png)

### Troubleshooting

#### Login problems

## <span class="mw-headline" id="bkmrk--2"></span>

Oracle database user accounts and passwords are created, synchronized, or unlocked from the [CS Password Utility](https://auth.cs.uwindsor.ca).

Make sure you are using your UWinID as your &lt;user-name&gt;, all lowercase without @uwindsor.ca appended.

<table class="plainlinks metadata ambox ambox-content" id="bkmrk-if-your-password-doe" role="presentation"><tbody><tr><td class="mbox-image"><div class="mbox-image-div">![Ambox_important.svg.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2024-11/ambox-important-svg.png)</div></td><td class="mbox-text"><div class="mbox-text-span">If your password does not meet the following restrictions, you MUST enclose your password in double quotation marks when prompted.</div></td></tr></tbody></table>

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](https://cs.uwindsor.ca/password).

```
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 ](https://itfaq.cs.uwindsor.ca/books/cs-help/page/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)
    )
  )
```