Home » RDBMS Server » Networking and Gateways » ORA-01031 connecting through LISTENER
ORA-01031 connecting through LISTENER [message #253396] Mon, 23 July 2007 14:51 Go to next message
Sudden Martes
Messages: 10
Registered: December 2002
Junior Member
I am getting ORA-01031 insufficient privileges error only when I try to connect through the listener
sqlplus sys/pass@sdby as sysdba

sqlplus / as sysdba works fine

The following are set:
password file = '/u01/app/oracle/product/10.2.0/db_1/dbs/orapwSDBY.ora'
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
db_name = PRMRY
db_unique_name=SDBY
ORACLE_SID=SDBY

Any ideas?

Re: ORA-01031 connecting through LISTENER [message #253405 is a reply to message #253396] Mon, 23 July 2007 15:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
post the output

conn sys/abc@db as sysdba
Re: ORA-01031 connecting through LISTENER [message #253551 is a reply to message #253396] Tue, 24 July 2007 04:17 Go to previous messageGo to next message
Sudden Martes
Messages: 10
Registered: December 2002
Junior Member
The output is:
ERROR:
ORA-01031: insufficient privileges
Re: ORA-01031 connecting through LISTENER [message #253806 is a reply to message #253551] Tue, 24 July 2007 21:14 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.orafaq.com/forum/?t=rview&goto=221085#msg_221085

[Updated on: Tue, 24 July 2007 21:14]

Report message to a moderator

Previous Topic: Not able to locate listner.ora, tnsnames.ora files
Next Topic: Connect to Oracle 8.0.5 DB with a 10g client
Goto Forum:
  


Current Time: Mon Dec 05 05:05:18 CST 2016

Total time taken to generate the page: 0.10656 seconds