Re: listner problem

From: Pradeep <agarwalp_at_eeism.com>
Date: 12 Jan 2006 01:06:08 -0800
Message-ID: <1137056768.846603.254830@o13g2000cwo.googlegroups.com>

Thanks Maxim
> 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)

but the below should work ?? why is it giving me an error.

SQL> connect sys/change_on_install_at_orcl as sysdba ERROR:
ORA-01031: insufficient privileges

Thanks

Pradeep
Maxim Demenko wrote:
> 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 - 03:06:08 CST