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@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu