OraFAQ Forum: Enterprise Manager » log in to my DB as SYSDBA

Home » RDBMS Server » Enterprise Manager » log in to my DB as SYSDBA

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

Thu, 27 June 2002 00:35

Mat
Messages: 22
Registered: November 2001

Junior Member

Hi there,

I can't log in as sysdba using console with a
repository : once the console is launched, I can
connect system as normal to my databases, but when I
try to connect as sysoper or sysdba, I get the
following msg : insufficent privileges (!).

Anyone has an idea ?

Report message to a moderator

Re: log in to my DB as SYSDBA [message #67891 is a reply to message #67890]

Thu, 27 June 2002 02:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you grant the sysdba priv to SYSTEM. it is not given by default.

SQL> SELECT  * FROM  V_$PWFILE_USERS;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE
MAG                            TRUE  FALSE
SQL> CONNECT SYS/SYS@JUPITER AS SYSDBA;
Connected.
SQL> GRANT SYSDBA TO SYSTEM;

Grant succeeded.

SQL>  SELECT  * FROM  V_$PWFILE_USERS;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE
MAG                            TRUE  FALSE
SYSTEM                         TRUE  FALSE

Report message to a moderator

Re: log in to my DB as SYSDBA [message #67893 is a reply to message #67890]

Fri, 28 June 2002 03:21

Mat
Messages: 22
Registered: November 2001

Junior Member

Thanx Mahesh,

Now I can connect system/manager as sysdba
with sqlplus, the problem is : I can't
connect anymore to my databases with console,
even as normal : I get the following error
message :

::: org.omg.CORBA.UNKNOWN
org.omg.CORBA.UNKNOWN[[completed=MAYBE]]
at
com.visigenic.vbroker.orb.SE.read(SE.java:29)
at
com.visigenic.vbroker.orb.GiopStubDelegate.invoke(GiopStubDelegate.java:577)
at
com.visigenic.vbroker.orb.GiopStubDelegate.invoke(GiopStubDelegate.java:477)
at
com.inprise.vbroker.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:60)
at
oracle.sysman.vdb._st_VdbIDLSessionFactory.getManagedSession(_st_VdbIDLSessionFactory.java:215)
at
oracle.sysman.vbo._st_VboDBServer.getManagedSession(_st_VboDBServer.java:1170)
at
oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialog.getConnection(VtaDbConnectDialog.java:982)
at
oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialog.okButton_Clicked(VtaDbConnectDialog.java:785)
at
oracle.sysman.vtaGallery.dbConnect.DefaultCallback.onConnectDialogOk(VtaDbConnectDialog.java:1328)
at
oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialog._actionPerformed(VtaDbConnectDialog.java:1174)
at
oracle.sysman.vtaGallery.dbConnect.VtaDbConnectDialogExecutor.run(VtaDbConnectDialog.java:1350)
at
oracle.sysman.vtaGallery.threadPoolManager.WorkerThread.run(Worker.java:271)

Any idea ?

Report message to a moderator

Previous Topic:	Oracle 8i installation problems.
Next Topic:	Oracle SQL statement 00900 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:51:16 CST 2024