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

[Kev_8]

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

[Patrick Wallek]

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]

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!