| Clone Oracle Codetree [message #179527] |
Tue, 27 June 2006 18:07  |
snarisetty
Messages: 2
Registered: June 2006
|
Junior Member |
|
|
Hello,
We were trying to clone oracle Codetree from one linux server to another linux server, from a user A to user B. Both have same versions on linux and oracle.
After copying over and relinking the codetree when I try to login as sys, I am getting insufficient privileges.
B> sqlplus "/ as sysdba"
ERROR:
ORA-01031: insufficient privileges
But when I enter like this and specify the password, I have no issues.
B> sqlplus sys as sysdba
SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jun 27 16:03:24 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
What am I missing here? Is there somewhere we need to change the codetree owner before relinking the codetree.
Thanks
|
|
|
|
|
|
| Re: Clone Oracle Codetree [message #179540 is a reply to message #179527] |
Tue, 27 June 2006 20:49  |
snarisetty
Messages: 2
Registered: June 2006
|
Junior Member |
|
|
Thanks for your reply.
Actually
1) I created the password file.
2) It should not be using the password file because I am logging in as the new owner of the codetree locally. So oracle should authenticate me without the password.
Sorry if I am mistaken in my analysis.
[Updated on: Tue, 27 June 2006 20:49] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
