Our Environment:
1) Our oracle software is installed with the unix userid "oracle", we DO NOT use oinstall.
2) Our instances run under the unix userid "oracle".
3) We can NOT enable remote logins for the unix userid "oracle", it's against our security policy.
Question:
Can I create a unix userid, "dbvisit", and install the software under it and enable ssh and rsync and have "dbvisit standby" software function correctly.
Answer:
Yes, the unix userid "dbvisit" can be created to install the software and run it and enable ssh, scp and rsync. There are 2 options to setup the "dbvisit" userid:
- Have the dbvisit user be part of the Oracle "dba" Unix group. This way the Dbvisit software will be able to login to the database without a username password, OR
- If your security policy does not allow the userid "dbvisit" to be part of the dba group, then edit the Dbvisit Database Configuration (DDC) file and set the SYS username and password under section: [25 Sys Logon Settings]. The DDC file is like the init.ora file but is used for Dbvisit configuration settings. The file looks like dbv_database_name.env.