Home » RDBMS Server » Server Administration » Unable to access DB (Solaris)
Unable to access DB [message #284645] Fri, 30 November 2007 06:56 Go to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Hi,
Can someone help on this. I have successfully installed the oracle 10G, but not able to access via sqlplus. Below is the error message:

sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 30 06:42:36 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges


What should i do now?

Thanking in advance.

Regards
Selva.
Re: Unable to access DB [message #284652 is a reply to message #284645] Fri, 30 November 2007 07:19 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

SET ORACLE_SID=SIDNAME

SQLPLUS /NOLOG

CONNECT SYS@DBNAME AS SYSDBA


Try and let me know.

Babu

Re: Unable to access DB [message #284689 is a reply to message #284652] Fri, 30 November 2007 10:07 Go to previous messageGo to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Hi Babu,
I'm getting same error. Actually i am install oracle 10G as manual installation. After successfully installation. i'm getting this error.

Thank you.

Regards
Selva
Re: Unable to access DB [message #284690 is a reply to message #284645] Fri, 30 November 2007 10:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What is Operating System (OS) name & version?
What is OS username?
Re: Unable to access DB [message #284736 is a reply to message #284645] Fri, 30 November 2007 14:13 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
lselva21 wrote on Fri, 30 November 2007 07:56


sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 30 06:42:36 2007

ERROR:
ORA-01031: insufficient privileges




Only a member of the DBA group can do this.
Re: Unable to access DB [message #284766 is a reply to message #284689] Fri, 30 November 2007 22:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you try without tnsentry name?
Did you recreate password file ?
Re: Unable to access DB [message #284857 is a reply to message #284645] Sat, 01 December 2007 22:07 Go to previous messageGo to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Hi,

Thank you very much. i have reinstalled the oracle 10G due to the error in the response file.

Thank you very much.

Regards
Selva
Re: Unable to access DB [message #284929 is a reply to message #284645] Sun, 02 December 2007 22:55 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

i have reinstalled the oracle 10G due to the error in the response file.


Shocked Shocked
Previous Topic: Sys, Sysdba, user roles and passwords
Next Topic: Confusing result of a query.
Goto Forum:
  


Current Time: Sat Nov 09 19:30:31 CST 2024