Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1161
  • Last Modified:

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/dbhome_1/network/admin/sqlnet.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/dbhome_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)
    )
  )
--------------









0
mystudent
Asked:
mystudent
  • 4
1 Solution
 
slightwv (䄆 Netminder) Commented:
Is your remote user in the dba group on the database server?
0
 
mystudentAuthor Commented:
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),54322(dba)
[oracle@dg1 admin]$

0
 
mystudentAuthor Commented:
Init.ora used to startup nomount.

db_name='orcl'
#memory_target=2G
processes = 150
audit_file_dest='/u01/app/oracle/product/11.2.0/dbhome_1/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
#global_dbname='orcl.world'
db_domain='world'
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle/diag'
# 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'
0
 
mystudentAuthor Commented:
The case of the pwfile seems to be the cause. Once I change it to all lower case, it works now. Thanks.
0
 
mystudentAuthor Commented:
Case
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now