Solved

ORA-01031

Posted on 2011-03-19
5
1,148 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
  • 4
5 Comments
 
LVL 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Converting a row into a column 2 53
Oracle SQL 6 59
SQL Query 34 99
Not able to drop or recreate an Oracle stored procedure 1 31
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

803 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