Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: sql plus login problem with password prompt
Don't know the answer though I've had it happen on rare occasions. But thank you for doing what so few do ... including copies of the relevant files so someone that does know can help you.
The last time this happened I found an entry in the Windows registry pointing to the wrong Oracle Home.
Daniel A. Morgan
NOTHXmacthecardinal_at_yahoo.com wrote:
> I can login to my Oracle servers just fine if I supply my name/password and
> service name. But if I want SQLPlus to prompt for my password, the login
> fails. Will some helpful, knowledgeable person please clue me in on why this
> happens?
>
> Thank you!
> Mac
> (private email ok, remove the NOTHX)
>
> == Supporting documentation ==
>
> SQLPLUS session:
>
> SQL> conn joee/joee_at_bdev
> Connected.
> SQL> disc
> Disconnected from Oracle8 Release 8.0.4.0.0 - Production
> PL/SQL Release 8.0.4.0.0 - Production
> SQL> conn joee_at_bdev
> Enter password: ****
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
> C:\ORANT\NET80\ADMIN\SQLNET.ORA: (The only file of this name on my PC)
>
> AUTOMATIC_IPC = OFF
> TRACE_LEVEL_CLIENT = OFF
> names.directory_path = (TNSNAMES, HOSTNAME)
> names.default_domain = world
> name.default_zone = world
> sqlnet.authentication_services = (NTS)
>
> C:\ORANT\NET80\ADMIN\TNSNAMES.ORA: (The only file of this name on my PC)
>
> <snip>
> BDEV.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bhost_db)(PORT = 1521))
> (CONNECT_DATA = (SID = orcl))
> )
> <snip>
> ==
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Wed Apr 04 2001 - 00:57:59 CDT