You would be getting the TNS protocol adapter error if the instance hasn't been
started -- it is configured to start as a service.
Hemant
At 08:45 AM 19-12-02 -0800, you wrote:
Humm obivioiously Im missing a few brain cells here....
Yes, I should know there isnt an exe called connect that would be native
to the envioriment outside of oracle.
Yes, there was a connect.bat in the path
Duh...
Ok, so lets see how many more vacant brain cells I have....
now if I log on to sql+ with a dba account (has all privilidges)
#######################################
LOCDB SQL> connect / as sysdba
Or
LOCDB SQL> connect / internal
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
LOCDB SQL> select * from global_name;
Not connected
#######################################
Why does this happen?
The bottom line is Im trying to connect as internal w/o the password
#######################################
C:\>set oracle_sid=LOCDB
C:\>svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal
Password:
I can however connect internal/password
Thanks for being paitent
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
