1748263 Members
3692 Online
108760 Solutions
New Discussion юеВ

connect to Rman via NET8

 
SOLVED
Go to solution
Asif_8
Regular Advisor

connect to Rman via NET8

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


8 REPLIES 8
Yogeeraj_1
Honored Contributor

Re: connect to Rman via NET8

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Brian Crabtree
Honored Contributor

Re: connect to Rman via NET8

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
Asif_8
Regular Advisor

Re: connect to Rman via NET8

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
Brian Crabtree
Honored Contributor

Re: connect to Rman via NET8

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
Asif_8
Regular Advisor

Re: connect to Rman via NET8

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
Brian Crabtree
Honored Contributor
Solution

Re: connect to Rman via NET8

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
Asif_8
Regular Advisor

Re: connect to Rman via NET8

Brain !

thanks ..

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

asif
Brian Crabtree
Honored Contributor

Re: connect to Rman via NET8

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