General
cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with username and password when using SQL*PLUS??

Kev_8
Occasional Contributor

Problems with username and password when using SQL*PLUS??

Could someone please tell me where do i obtain or setup a username and password when i run SQL*PLUS via Oracle Client; as i cant seem to run SQL*PLUS without a username or password??
2 REPLIES
Patrick Wallek
Honored Contributor

Re: Problems with username and password when using SQL*PLUS??

This is setup in whatever database you are connecting to. Before you start SQLPLUS you have to set an environment variable with the name of the DB you want to connect to. The user name and password will be set up in the database.

You can *not* effectively use SQLPLUS without connecting to a database.
prasad_15
Advisor

Re: Problems with username and password when using SQL*PLUS??


1-The DBA will be able to tell you which instance and what username/password to use .
2-test if the client is configured to connect to the instance by using tnsping utility.
3-invoke sqlplus with the username/password and the connect string.

Cheers!