?
Solved

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

Posted on 2013-06-19
5
Medium Priority
?
10,051 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
[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
  • 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

771 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