Solved

ORA-1031 connecting /@sid as sysdba in SQLPLUS and RMAN

Posted on 2013-06-19
5
9,165 Views
Last Modified: 2013-06-20
Environment:

OS: Oracle Linux 2.6.39-400.21.2.el6uek.x86_64
DB: Oracle 11.2.0.3 plus April 2013 CPU

I have a couple of databases on a relatively newly created server that I'm having issues with.

I can set ORACLE_HOME and ORACLE_SID e-vars and do either of the below just fine:

sqlplus / as sysdba
rman target /

However, for either if I attempt to add "@SID" after the connect string:

sqlplus /@test as sysdba
rman /@test

I am getting ORA-01031 insufficient privileges

I have been getting along just fine until I had to clone one database to another.  When I was trying to use RMAN to connect to both target and auxiliary at the same time I found the error above and thought I'd try it out in SQLPlus to see what I could see.

I have spent the last several hours searching google, EE, Oracle Support and haven't found much yet.

Things done so far:

* Verified permissions on oracle binary (set as 6751).
* Oracle OS user is a member of the dba group
* Checked the group setting in $ORACLE_HOME/rdbms/lib/config.c
* Reset the SYS password and recreated the password file to the same password
* Remote_Login_Passwordfile is set to EXCLUSIVE
* Tried adding SQLNET.AUTHENTICATION_SERVICES=(ALL) to sqlnet.ora on the server
* As a part of an earlier RMAN issue I created descriptors for the database instances in listener.ora

I'm wondering if I have something wrong with my listener configuration since the base connect (/ as sysdba) works just fine but it's not until I add @sid that starts giving me grief.

Any insights would be greatly appreciated.
0
Comment
Question by:Steve Wales
  • 3
5 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 39262344
Hi,
Does it work when providing the user/password such as:
sqlplus sys/syspassword@test as sysdba
?
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 39262411
sqlplus /@test as sysdba
rman /@test

Open in new window

The above do not work, you need to supply userid+password.
:p
0
 
LVL 22

Author Comment

by:Steve Wales
ID: 39262510
@franckpachot:

Yes that works.

@MikeOM_DBA:

My main concern with this question was operation for RMAN duplicate.  I have no real reason to connect to sqlplus that way.

I've been working in Windows world for the last couple of years and we've just started back in Linux.  In Windows, when cloning a database this works fine:

set ORACLE_SID=test
rman target /@prod auxiliary /

Then I do the duplicate target test and it works just fine.

I have been doing some extra testing and managed (finally) to get around it like this:

[oracle@orav11 test]$ set ORACLE_SID=test
[oracle@orav11 test]$ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jun 20 07:40:47 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target 'sys@prod'

target database Password: 
connected to target database: PROD (DBID=xxxxxxxxxx)

RMAN> connect auxiliary /

connected to auxiliary database: TEST (not mounted)

RMAN> 

Open in new window


Once I managed to get both databases connected to RMAN I could perform the duplicate.  Still not sure why I can manually connect from the RMAN prompt while it doesn't work from the command line, but it's working now and that's all I really care about.
0
 
LVL 22

Author Comment

by:Steve Wales
ID: 39262534
I've requested that this question be closed as follows:

Accepted answer: 0 points for sjwales's comment #a39262510

for the following reason:

Expert comments were (a) asking more questions and then (b) stating that what I was trying to do didn't work.

I did some further testing on my own and managed to come up with my own solution.

Thanks for the responses though.
0
 
LVL 22

Author Closing Comment

by:Steve Wales
ID: 39262535
Actually, I will accept this as the answer since this is what led me to my solution.

Thanks :)
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sum of columns in a row in oracle 3 44
Loading flat file data in tables 2 63
Updating a temp table inside a PL/SQL block 3 51
plsql job on oracle 18 78
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

733 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