Home » RDBMS Server » Server Administration » Problems logging in as SYSDBA
Problems logging in as SYSDBA [message #603147] Wed, 11 December 2013 14:43 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25795
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!
Re: Problems logging in as SYSDBA [message #603151 is a reply to message #603149] Wed, 11 December 2013 14:56 Go to previous messageGo to next message
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.
Re: Problems logging in as SYSDBA [message #603153 is a reply to message #603151] Wed, 11 December 2013 14:59 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
UNIX: Checklist for Resolving Connect AS SYSDBA Issues NOTE: 69642.1.
Re: Problems logging in as SYSDBA [message #603176 is a reply to message #603147] Thu, 12 December 2013 01:16 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at password file and "remote_login_passwordfile" parameter. in Database Administrator's Guide and Database Reference.

Regards
Michel
Previous Topic: Creating new tablespaces in 10gR2
Next Topic: upgrade database
Goto Forum:
  


Current Time: Thu Jan 18 17:05:17 CST 2018

Total time taken to generate the page: 0.01618 seconds