Dear all,

I have a problem when restoring the Oracle Database on AIX & Linux
clients.
The problem is related to privilege issue.

I used NetBackup client (Backup, Archive, and Restore), by running this
command on AIX (using Xmanager) & Linux: 
/usr/openv/netbackup/jbpSA &

I used the 'Oracle' restore type and the database to be restored has
been shown at the 'Directory Structure' of jbpSA, but I was unable to
drill-down/expand the database's tree.
When it asked for username (SYSDBA privilege), password & Net service
name (TNS Alias), I've tried to use the correct 'sys' userID & password
and TNS alias (I've double checked those entries with my system
administrator), but it's failed with this error message:
Oracle Connection:
ERR - Unable to connect to elodev. Error code = 12560

I've tried to run the jbpSA using root & oracle users, both resulted the
same error.
Since I got those error when I expanded the database tree, I can't run
the restore as well.

I've tried to test the 'sys' user within sqlplus command (logged on as a
root user), and it's failed with this error message:
ERROR:
ORA-01031: insufficient privileges

But, when I tried to logon using the oracle user, it was successful but
it's still failed when I run the restore using jbpSA.

Could you please help me solve this problem?
Since I'm a novice in Oracle DB, is there any guidance which I can refer
to?
If possible, please give me the step by step information about restoring
an Oracle Database to AIX & Linux platform.

FYI, both the NetBackup master & client (agent) use the same NetBackup
version, which is 6.5.4.

Thank you in advance.


--
Best Regards, 
  Adrian Soetanto
  PT. Bentoel Prima - Infrastructure Staff 
  Jl. Raya Karanglo - Singosari, Malang 
  Tel. (+62-341) 298 774 

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu