Solved

ORA-01031

Posted on 2011-03-19
5
1,152 Views
Last Modified: 2012-05-11
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
Comment
Question by:mystudent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35172933
Is your remote user in the dba group on the database server?
0
 

Author Comment

by:mystudent
ID: 35172950
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
 

Author Comment

by:mystudent
ID: 35172954
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
 

Accepted Solution

by:
mystudent earned 0 total points
ID: 35176730
The case of the pwfile seems to be the cause. Once I change it to all lower case, it works now. Thanks.
0
 

Author Closing Comment

by:mystudent
ID: 35213316
Case
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question