OraFAQ Forum: Server Administration » Problems logging in as SYSDBA

Home » RDBMS Server » Server Administration » Problems logging in as SYSDBA

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

Problems logging in as SYSDBA [message #603147]

Wed, 11 December 2013 14:43

joebegenwald@gmail.com
Messages: 7
Registered: October 2013

Junior Member

Any ideas why this would be a problem? It seems I cannot log in as SYSDBA over TNS:

> ORACLE_SID=mynewdb
> export ORACLE_SID
> sqlplus sys/sysora as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 11 15:31:20 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select dbid, name from v$database;

DBID NAME
---------- ---------
839107013 MYNEWDB

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

> sqlplus sys/sysora@mynewdb.mydomain.com as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 11 15:31:49 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

^C

> sqlplus rman/sysora

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 11 15:32:09 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select dbid, name from v$database;

DBID NAME
---------- ---------
839107013 MYNEWDB

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

> sqlplus rman/sysora@mynewdb.mydomain.com

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 11 15:32:20 2013

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select dbid, name from v$database;

DBID NAME
---------- ---------
839107013 MYNEWDB

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
>

[Updated on: Wed, 11 December 2013 14:47]

Report message to a moderator

Re: Problems logging in as SYSDBA [message #603149 is a reply to message #603147]

Wed, 11 December 2013 14:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It seems I cannot log in as SYSDBA over TNS:
above is BIG security hole!
If you can login AS SYSDBa over the network, then I can do the same to YOUR DB!

I suggest that you ensure that nobody can ever login AS SYSDBA over the network!

Report message to a moderator

Re: Problems logging in as SYSDBA [message #603151 is a reply to message #603149]

Wed, 11 December 2013 14:56

joebegenwald@gmail.com
Messages: 7
Registered: October 2013

Junior Member

I understand that this may be a security issue. But if this is supposed to be being prevented by Oracle, then my new client has about 30 or so databases that are messed up. I am using TNS to log in as SYSDBA via SQL Developer all over the clients system, and this new one that I just created is the only one giving me this behavior. So, what is the magic privilege or parameter setting that controls this?

But thanks, you've given me something to look for, at least.

Report message to a moderator