It is possible to shutdown and startup the database
The main problem is the fact that you can't even connect to test as SCOTT/TIGER remotely. Can you connect as scott/tiger@test on the test node itself?
yes ., after restarting the database it grants permission to rman
but if i connect to test like
rman target sys@test
same error presists
ebrian i can't connect even in that same system as scott/tiger@test
when you are trying to connect to the same system by scott/tiger@test, what err it is throwing ?
did you check the listner status, the configuration of both tnsnames and listner
when you are trying to connect to the remote system check the OS Authentication
when i try to connect in same machine it shows as
SQL> connect scott/tiger@test
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Warning: You are no longer connected to ORACLE.
SQL> connect scott/tiger
if i try from remote machine the same error it throws
now rman trarget database connects (due to privilege)
since the connection itself struck work i can't go further
ls -l $ORACLE_HOME/bin/oracle
From the remote machine the RMAN is connecting to the target database ?
$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 51502644 Feb 15 18:02 /opt/ora9/product/9.2/bin/oracle
Gopu.., i can connect to target DB.(but to register i have catalog on test)
Click Here to Expand Forum to Full Width