topic Re: connect to Rman via NET8 in Operating System - HP-UX

connect to Rman via NET8

Asif_8 — Sun, 22 Feb 2004 21:48:33 GMT

Hi!
I am try to connect to the target database using net8 from client worksation we get error
usernam/password not correct

oracle server not using passwordfile
remote _os_passwordfile=none
can i login in Rman without password file.
Can I login RMAN by OS user oracle group dba

Re: connect to Rman via NET8

Yogeeraj_1 — Sun, 22 Feb 2004 23:16:38 GMT

hi,

loging in as RMAN is similar to loging in using SQLPLUS.

can you check if you can successfully using sqlplus on the the client workstation?

regards
Yogeeraj

Re: connect to Rman via NET8

Brian Crabtree — Mon, 23 Feb 2004 16:49:49 GMT

Asif,

To use rman, you must be able to connect as sysdba:

sqlplus /nolog
connect user/pass as sysdba

You can use:

rman target / rcvcat user/pass@RCAT

However, Omniback does not have the option to connect as a local authenticated user. You must use a password file to integrate it with Omniback.

Thanks,

Brian

Re: connect to Rman via NET8

Asif_8 — Mon, 23 Feb 2004 17:23:44 GMT

Hi brain!

I got following error:

connection string:sys/sys@ov_net as sysdba
sql> Error
ORA-01017 : Invalid username/password logon denied:
my question are:
1.any other method to connect Rman instead of passwordfile
2. If create know password file what happed crruent user .
3. how to know oracle is using password file
thanks
asif

Re: connect to Rman via NET8

Brian Crabtree — Mon, 23 Feb 2004 19:59:40 GMT

1.any other method to connect Rman instead of passwordfile
- No.

2. If create know password file what happed crruent user .
- The "SYS" and "SYSTEM" user cannot be used in this way. Besides, you really don't want to use the sys and system accounts for this. Creating a new user and granting sysdba to it would be better.

3. how to know oracle is using password file
- The password file will be $OH/dbs/orapw${ORACLE_SID}. You need to set the "remote_login_passwordfile" parameter to "exclusive" and bounce the database. This should show up in the v$parameter view afterwards.

Thanks,

Brian

Re: connect to Rman via NET8

Asif_8 — Mon, 23 Feb 2004 20:24:10 GMT

Hi!

thanks brain again, In this directory there
orapw file but not orapwsid file this is passwdfile oracle use right now or not using any file
I checked init parameter file remote_os_passwdfile=non

asif

Re: connect to Rman via NET8

Brian Crabtree — Mon, 23 Feb 2004 21:02:01 GMT

It is not using any file. The file will be "orapw" if you set the parameter to shared. Normally, it is just as easy to use exclusive and a file for each database. Otherwise, if that file is lost, you will need to rebuild it for all of the databases.

Brian

Re: connect to Rman via NET8

Asif_8 — Wed, 25 Feb 2004 11:47:54 GMT

Brain !

thanks ..

If I am not using password then I create new
file what happen exiting users
Can I create again all user

asif

Re: connect to Rman via NET8

Brian Crabtree — Wed, 25 Feb 2004 15:40:39 GMT

This will not affect the users on the database, only the ability to access sysdba remotely. You would have to regrant this ability if you lose this file (I think).

Brian