Solved

ORA-01031

Posted on 2011-03-19
5
1,144 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.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle 12c 10 100
performance tunning sql insert - challenging one 2 32
Oracle Syntax 8 42
PAYER_ID has both atributes 4 19
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now