cannot login to database /as sysdba
676394Jun 26 2009 — edited Jun 30 2009I have installed to two different databases on the same server but I am using different homes even though they are they same version because one is development and the other is production.
Initially, I wanted to run the listeners seperately in their own homes as well but that proved to be exhausting and ultimately pointless so I resigned to using on $TNS_ADMIN home but it did not fix the problem.
The problem is that when I try to login using /as sysdba I get this error:
Enter user-name: /as sysdba
ERROR:
ORA-01031: insufficient privileges
I can however login to the other database with /as sysdba with no problems and I can login with sys/password as sysdba with no problems.
Listener.ora:
SID_LIST_LISTENER_DOEM =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = doem.HORIZON)
(ORACLE_HOME = /opt/oracle/product/db10g)
(SID_NAME = doem)
)
)
ADMIN_RESTRICTIONS_LISTENER_DOEM = ON
LISTENER_DOEM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sherman)(PORT = 1521))
)