mystudent
asked on
ORA-01031
Tried to connect to a instance with nomount status using sys user with tns sid and got ORA-01031.
[oracle@dg1 admin]$ sqlplus sys@dg1 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 16 06:34:24 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
1. connecting locally using sqlplus sys as sysdba works just fine
2. remote_login_passwordfile= exclusive and $ORACLE_HOME\dbs\orapwORCL was created.
Listener is up and service is online. TNSPING works on the tnsname sid_name.
[oracle@dg1 admin]$ tnsping dg1
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2011 06:35:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11 .2.0/dbhom e_1/networ k/admin/sq lnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.world)))
OK (0 msec)
---------
[oracle@dg1 admin]$ less listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.world)
(ORACLE_HOME = /u01/app/oracle/product/11 .2.0/dbhom e_1)
(SID_NAME = orcl)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
-----------
[oracle@dg1 admin]$ less tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.110)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.domain)
)
)
dg1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
--------------
[oracle@dg1 admin]$ sqlplus sys@dg1 as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 16 06:34:24 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
1. connecting locally using sqlplus sys as sysdba works just fine
2. remote_login_passwordfile=
Listener is up and service is online. TNSPING works on the tnsname sid_name.
[oracle@dg1 admin]$ tnsping dg1
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2011 06:35:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.world)))
OK (0 msec)
---------
[oracle@dg1 admin]$ less listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.world)
(ORACLE_HOME = /u01/app/oracle/product/11
(SID_NAME = orcl)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
-----------
[oracle@dg1 admin]$ less tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.110)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.domain)
)
)
dg1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
--------------
Is your remote user in the dba group on the database server?
ASKER
Yes, I login as oracle user. The server and the client are the same serve, in this case.
[oracle@dg1 admin]$ id
uid=500(oracle) gid=54321(oinstall) groups=54321(oinstall),543 22(dba)
[oracle@dg1 admin]$
[oracle@dg1 admin]$ id
uid=500(oracle) gid=54321(oinstall) groups=54321(oinstall),543
[oracle@dg1 admin]$
ASKER
Init.ora used to startup nomount.
db_name='orcl'
#memory_target=2G
processes = 150
audit_file_dest='/u01/app/ oracle/pro duct/11.2. 0/dbhome_1 /admin/orc l/adump'
audit_trail ='db'
db_block_size=8192
#global_dbname='orcl.world '
db_domain='world'
db_recovery_file_dest='/u0 1/app/orac le/flash_r ecovery_ar ea'
db_recovery_file_dest_size =2G
diagnostic_dest='/u01/app/ oracle/dia g'
# dispatchers='(PROTOCOL=TCP ) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile= 'EXCLUSIVE '
remote_os_authent=true
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
db_name='orcl'
#memory_target=2G
processes = 150
audit_file_dest='/u01/app/
audit_trail ='db'
db_block_size=8192
#global_dbname='orcl.world
db_domain='world'
db_recovery_file_dest='/u0
db_recovery_file_dest_size
diagnostic_dest='/u01/app/
# dispatchers='(PROTOCOL=TCP
open_cursors=300
remote_login_passwordfile=
remote_os_authent=true
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Case