OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Unable to access DB (Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to access DB [message #284645]

Fri, 30 November 2007 06:56

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.

Report message to a moderator

Re: Unable to access DB [message #284652 is a reply to message #284645]

Fri, 30 November 2007 07:19

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

Report message to a moderator

Re: Unable to access DB [message #284689 is a reply to message #284652]

Fri, 30 November 2007 10:07

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

Report message to a moderator

Re: Unable to access DB [message #284690 is a reply to message #284645]

Fri, 30 November 2007 10:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is Operating System (OS) name & version?
What is OS username?

Report message to a moderator

Re: Unable to access DB [message #284736 is a reply to message #284645]

Fri, 30 November 2007 14:13

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.

Report message to a moderator

Re: Unable to access DB [message #284766 is a reply to message #284689]

Fri, 30 November 2007 22:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you try without tnsentry name?
Did you recreate password file ?

Report message to a moderator

Re: Unable to access DB [message #284857 is a reply to message #284645]

Sat, 01 December 2007 22:07

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

Report message to a moderator

Re: Unable to access DB [message #284929 is a reply to message #284645]

Sun, 02 December 2007 22:55

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:17:31 CST 2024