Re: Problem with the remote connection to Oracle database

Użytkownik "Gerry Sinkiewicz" <sinkiege_at_snet.net> napisał w wiadomości news:UQWfd.14379$Rf1.2431_at_newssvr19.news.prodigy.com... <cut>
> You do not need a remote connection to restore a database via RMAN.
> In fact if you needed to be remote, it would mean there was something
wrong
> with the server, heh?
> Have you created the password file and put the proper user IDs into it and
> set the init.ora
> parameter applicable to exclusive?
> In fact to restore a database you do not use sqlplus, you use rman.

In my installation RMAN is integrated with Data Protector and I guess I need the remote connection to connect to the target database. I use the following connection string:

rman catalog=rman/rman_xx_at_rman target=sys/passwd_at_SERVICE

I have got the same error ORA-01017 from RMAN so I thought the problem is somehow connected with the database connection problem. I created the password file several times, v$pwfile_users returns the info on sys account, and of course remote_login_passwordfile is set to exclusive. As I wrote in the previos post, every second attempt is successful, so it must be somehow OK. (only instance is running then - database is nomount state)
But when I open the database and then connect remotely, everything seems to be fine, so I guess there is some problem with the password file, but I can't figure out what is wrong.

EP Received on Thu Oct 28 2004 - 03:55:15 CDT