Home » RDBMS Server » Enterprise Manager » log in to my DB as SYSDBA
log in to my DB as SYSDBA [message #67890] Thu, 27 June 2002 00:35 Go to next message
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 ?
Re: log in to my DB as SYSDBA [message #67891 is a reply to message #67890] Thu, 27 June 2002 02:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
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
Re: log in to my DB as SYSDBA [message #67893 is a reply to message #67890] Fri, 28 June 2002 03:21 Go to previous message
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 ?
Previous Topic: Oracle 8i installation problems.
Next Topic: Oracle SQL statement 00900 error
Goto Forum:
  


Current Time: Mon May 16 17:44:57 CDT 2022