Re: listner problem

Pradeep schrieb:
> below is my listener.ora, tnsnames.ora and sqlnet.ora. I think there is
> no problem with these files, but i am still not able to connect to the
> database. I have oracle8.0 on Win2K
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL= TCP)
> (Host= oracle)
> (Port= 1521)
> )
> (ADDRESS=
> (PROTOCOL= TCP)
> (Host= oracle)
> (Port= 1526)
> )
>
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = 0
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (PROGRAM=extproc)
> )
> )
> PASSWORDS_LISTENER = (oracle)
>
> tnsnames.ora
>
> extproc_connection_data.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = IPC)
> (KEY = EXTPROC0)
> )
> (CONNECT_DATA = (SID = extproc)
> )
> )
>
> orcl =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SID = orcl)
> )
> )
>
>
> sqlnet.ora
>
> TRACE_LEVEL_CLIENT = OFF
> #sqlnet.authentication_services = (NONE)
> names.directory_path = (TNSNAMES, HOSTNAME)
> #names.default_domain = world (it is commented)
> #name.default_zone = world (it is commented)
> automatic_ipc = off
>
> I tried.
>
> SQL> connect sys/change_on_install_at_orcl as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> SQL> connect / as sysdba
> ERROR:
> ORA-12203: TNS:unable to connect to destination
>
> SQL> connect /@orcl as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> SQL> connect sys/change_on_install_at_orcl
> ERROR:
> ORA-01034: ORACLE not available
>
> Kindly suggest where am i doing wrong.
>

To use os authentification on windows,
1) your os user has to be member of privileged group ( "ORA_DBA") 2) your sqlnet.ora should contain
sqlnet.authentication_services = (NTS)

Best regards

Maxim Received on Thu Jan 12 2006 - 02:51:46 CST