[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ORA-01031

Posted on 2011-03-19
5
Medium Priority
?
1,159 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

656 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