topic Problems with username and password when using SQL*PLUS?? in Operating System - HP-UX

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

Kev_8 — Wed, 22 Oct 2003 17:28:28 GMT

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

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

Patrick Wallek — Wed, 22 Oct 2003 17:30:51 GMT

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.

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

prasad_15 — Wed, 22 Oct 2003 17:55:30 GMT

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!