Re: listner problem

From: Pradeep <agarwalp_at_eeism.com>
Date: 12 Jan 2006 02:41:32 -0800
Message-ID: <1137062492.940713.222420@g44g2000cwa.googlegroups.com>

>>The same error means ORA-01031 ? -> Yes
>>Then, did you restarted instance after you changed init.ora ? -> How do I restart? I just tried to connect.
>>Does the password file exists for this instance ? -> yes, and the passwd is connect_on_install
>>Are you local on the database server or accessing it remote? -> local database server
>>Can you connect as non sysdba user (scott/tiger, system/manager etc.) ? -> i tried the following
SQL> connect scott/tiger
ERROR:
ORA-12203: TNS:unable to connect to destination

SQL> connect scott/tiger_at_orcl
ERROR:
ORA-01034: ORACLE not available

>>Can you connect without password "/ as sysdba" if you set
sqlnet.authentication_services = (NTS) ? -> i get the below error SQL> connect / as sysdba
ERROR:
ORA-12203: TNS:unable to connect to destination SQL> connect /@orcl as sysdba
ERROR:
ORA-01031: insufficient privileges

I was reading http://home.clara.net/dwotton/dba/ora1031.htm which states that you need to be part of ORA_DBA group for OS authentication, i don't have this group in my Win 2K

Thanks Received on Thu Jan 12 2006 - 04:41:32 CST