07-12-2010 03:32 AM
07-12-2010 03:52 AM
The following should be in place before you install the Remote Agent:
Root privileges are required on Linux and UNIX hosts in order to install the Remote Agent for Linux or UNIX Servers.
Access to a mounted CD-ROM drive.
TCP/IP, which is used for communication with the UNIX host computers, is required on the media server.
07-12-2010 04:00 AM
07-12-2010 04:08 AM
and Replace the dbname entries in /etc/VRTSralus/beoratab with the name of the instance of the RAC database on that machine
Add O/S user that has DBA privileges (the owner of oracle binaries) to the beoper group
07-12-2010 04:59 AM
Hi! If I do Agent configuration of database credentials as root I obtain following traces (my /etc/VRTSralus/ralus.cfg has trace enabled with: Software\Symantec\Backup Exec For Windows\Backup Exec\Debug\AgentConfig=1) in /var/VRTSralus: 782135a0 Mon Jul 12 13:28:42 2010 : ORACLEConfiguration::GetCredentials : Created new instance of OCIINTERCONNECT 782135a0 Mon Jul 12 13:28:42 2010 : ORACLEConfiguration::GetCredentials : Trying to login to Oracle 782135a0 Mon Jul 12 13:28:42 2010 : OCIINTERCONNECT::LogonOracle: db = (o), home_dir = (/), user =(S), passwd= (****) 782135a0 Mon Jul 12 13:28:42 2010 : Current Oracle user name (SYSOPER) 782135a0 Mon Jul 12 13:28:42 2010 : putenv(ORACLE_SID=oper1) 782135a0 Mon Jul 12 13:28:42 2010 : putenv(ORACLE_HOME=/u01/app/11/oracle) 782135a0 Mon Jul 12 13:28:42 2010 : Using the OCI library - /u01/app/11/oracle/lib/libclntsh.so 782135a0 Mon Jul 12 13:28:42 2010 : OCIServerAttach() Linux 1 782135a0 Mon Jul 12 13:28:42 2010 : OCIServerAttach() Linux 2 782135a0 Mon Jul 12 13:28:42 2010 : OCIServerAttach() failed 782135a0 Mon Jul 12 13:28:42 2010 : OCISessionBegin() failed with database credentials. 782135a0 Mon Jul 12 13:28:42 2010 : OCI_ERROR: ORA-12546: TNS:permission denied 782135a0 Mon Jul 12 13:28:42 2010 : Failed to logon to database, other error: Error code (0x3102) 782135a0 Mon Jul 12 13:28:42 2010 : Returning E_RMAN_LOGON_OTHER error (0xe000100f) 782135a0 Mon Jul 12 13:28:42 2010 : OCIINTERCONNECT::LogonOracle: Logon is Unsuccessful 782135a0 Mon Jul 12 13:28:42 2010 : ORACLEConfiguration::GetCredentials : Deleting instance of OCIINTERCONNECT But if I repeat same step as owner of database I obtain following result in trace: 652fd5a0 Mon Jul 12 13:55:44 2010 : Entered function : ORACLEConfiguration::GetCredentials 652fd5a0 Mon Jul 12 13:55:48 2010 : ORACLEConfiguration::GetCredentials : Created new instance of OCIINTERCONNECT 652fd5a0 Mon Jul 12 13:55:48 2010 : ORACLEConfiguration::GetCredentials : Trying to login to Oracle 652fd5a0 Mon Jul 12 13:55:48 2010 : OCIINTERCONNECT::LogonOracle: db = (o), home_dir = (/), user =(s), passwd= (****) 652fd5a0 Mon Jul 12 13:55:48 2010 : Current Oracle user name (sysoper) 652fd5a0 Mon Jul 12 13:55:48 2010 : putenv(ORACLE_SID=oper1) 652fd5a0 Mon Jul 12 13:55:48 2010 : putenv(ORACLE_HOME=/u01/app/11/oracle) 652fd5a0 Mon Jul 12 13:55:48 2010 : Using the OCI library - /u01/app/11/oracle/lib/libclntsh.so 652fd5a0 Mon Jul 12 13:55:48 2010 : OCIServerAttach() Linux 1 652fd5a0 Mon Jul 12 13:55:48 2010 : OCIServerAttach() Linux 2 652fd5a0 Mon Jul 12 13:55:48 2010 : OCIINTERCONNECT::LogonOracle: Logon is successful 652fd5a0 Mon Jul 12 13:55:48 2010 : ORACLEConfiguration::GetCredentials : Deleting instance of OCIINTERCONNECT 652fd5a0 Mon Jul 12 13:55:48 2010 : OCIInterconnect: logoff successful
07-12-2010 05:13 AM
07-12-2010 05:19 AM
Oops! your indication is clean: seems to like RALUS. Now my trace shows this: 1c655a0 Mon Jul 12 14:15:35 2010 : ORACLEConfiguration::InitValues : Called function AgentConfiguration::LoadOracleSID 1c655a0 Mon Jul 12 14:15:35 2010 : Exiting from function : ORACLEConfiguration::InitValues 1c655a0 Mon Jul 12 14:15:36 2010 : Entered function : ORACLEConfiguration::GetCredentials 1c655a0 Mon Jul 12 14:15:40 2010 : ORACLEConfiguration::GetCredentials : Created new instance of OCIINTERCONNECT 1c655a0 Mon Jul 12 14:15:40 2010 : ORACLEConfiguration::GetCredentials : Trying to login to Oracle 1c655a0 Mon Jul 12 14:15:40 2010 : OCIINTERCONNECT::LogonOracle: db = (o), home_dir = (/), user =(s), passwd= (****) 1c655a0 Mon Jul 12 14:15:40 2010 : Current Oracle user name (SYSOPER) 1c655a0 Mon Jul 12 14:15:40 2010 : putenv(ORACLE_SID=oper1) 1c655a0 Mon Jul 12 14:15:40 2010 : putenv(ORACLE_HOME=/u01/app/11/oracle) 1c655a0 Mon Jul 12 14:15:40 2010 : Using the OCI library - /u01/app/11/oracle/lib/libclntsh.so 1c655a0 Mon Jul 12 14:15:40 2010 : OCIServerAttach() Linux 1 1c655a0 Mon Jul 12 14:15:40 2010 : OCIServerAttach() Linux 2 1c655a0 Mon Jul 12 14:15:41 2010 : OCIINTERCONNECT::LogonOracle: Logon is successfulI'll check Symantec Backup Exec results in a moment.
07-12-2010 05:26 AM
07-12-2010 05:31 AM
07-13-2010 12:32 AM
07-13-2010 01:56 AM
07-13-2010 03:01 AM
07-13-2010 03:23 AM
07-13-2010 04:20 AM
07-13-2010 04:43 AM
07-13-2010 04:48 AM
07-14-2010 04:06 AM
Changing to use oracle user to do backups and restores works well with S.O. files but fails accesing to database from Symantec Backup Exec.
Doing configuration of "2. Oracle Credentials" section fails with this trace:
4323f940 Tue Jul 13 14:03:00 2010 : OCIServerAttach() Linux 1 4323f940 Tue Jul 13 14:03:00 2010 : OCIServerAttach() Linux 2 4323f940 Tue Jul 13 14:03:00 2010 : OCIServerAttach() failed 4323f940 Tue Jul 13 14:03:00 2010 : OCISessionBegin() failed with database credentials. 4323f940 Tue Jul 13 14:03:00 2010 : OCI_ERROR: ORA-12546: TNS:permission denied 4323f940 Tue Jul 13 14:03:00 2010 : Failed to logon to database, other error: Error code (0x3102) 4323f940 Tue Jul 13 14:03:00 2010 : Returning E_RMAN_LOGON_OTHER error (0xe000100f)
07-14-2010 04:07 AM
Thanks RahulG!
Your last document indicates a list of actions to check Oracle RMAN health and my nodes are healthy.
I can do backups in many ways without errors: all seems OK. This document also shows to checking a simple
Oracle backup. If I make a backup to tape I can't because user initiated RMAN was "oracle" and Symantec Backup
Exec doesn't have valid credentials for it, as you indicated has credentials for root user (and for oracle user
called "sys"):
Error Message: BEError(0xe0001018) La autenticación ha fallado. Verifique que Backup Exec Remote Agent se ejecute en esta computadora remota. Verifique que las credenciales de autenticación que se especifican en el servidor de soportes para esta computadora remota sean válidas.
In one word: I only have good results while I configure RALUS to use a user with Oracle privileges to execute
their commands (sqlplus, rman and so on). My Agent is configured to use root user and this can't execute
rman. If I try it I obtain this error:
ERROR: ORA-01031: privilegios insuficientes
07-14-2010 04:10 AM
It was looking good but a simple backup tablespace doesn't run and is hanging (like this trace):
85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::setUpLogFile() : Opening debug log /var/VRTSralus/svde8002.myserver.es-ralus-2010071215001483.log 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::setUpLogFile() : Current process ID = 14446 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "NBBSA_LOG_DIRECTORY", Env Val = "/var/VRTSralus" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::bsaValidateEnv() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::bsaValidateEnv() : Validating NBBSA_LOG_DIRECTORY in scope 1 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::bsaSetEnv() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::bsaUpdateEnv() : Function called with scope = 1 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::setUpStateTable() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning BSA_API_VERSION=1.1.0 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::vxbsaInit : Timeout value for persistent channel (in milli secs): (600000) 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::vxbsaInit : Using config file /etc/VRTSralus/ralus.cfg 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::setFsInfo() : Called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_DATA_ID=64 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_BEDS_ID=64 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_BEDS_VER=0 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "NBBSA_DB_NAME", Env Val = "oper" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::vxbsaSetEnvFromConfig() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Environment variable NBBSA_NO_RBI_SET does not exist 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::vxbsaGetEnv(CHAR) : Error getting environment NBBSA_NO_RBI_SET 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandlerBE::setOracleEnv() : Function called 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_DB_NAME=oper 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "BSA_SERVICE_HOST", Env Val = "srbm0051.myserver.es" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "NBBSA_RAN_AGENTCONFIG", Env Val = "1" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "NBBSA_JOB_TEMPLATE", Env Val = "Default" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaSetEnv() : Env Var = "NBBSA_DB_ID", Env Val = "683877636" 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_VERBOSE_LEVEL=5 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_RAN_AGENTCONFIG=1 85d6ee80 Mon Jul 12 15:00:14 2010 CBsaHandler::vxbsaGetEnv() : Returning NBBSA_DB_NAME=oper 85d6ee80 Mon Jul 12 15:00:14 2010 sbtinit2 : Found FQDN configured 85d6ee80 Mon Jul 12 15:00:14 2010 sbtinit2 : Found RAC 85d6ee80 Mon Jul 12 15:00:14 2010 sbtinit2 : leaving 85d6ee80 Mon Jul 12 15:00:49 2010 sbtend : entering 85d6ee80 Mon Jul 12 15:00:49 2010 sbtend : --- END of SESSION --- 85d6ee80 Mon Jul 12 15:00:49 2010 sbtend : leaving 85d6ee80 Mon Jul 12 15:00:49 2010 CBsaHandlerBE::vxbsaTerminate() : Called 85d6ee80 Mon Jul 12 15:00:49 2010 CBsaHandlerBE::stopPollerThread() : Called 85d6ee80 Mon Jul 12 15:00:49 2010 CBsaHandlerBE::stopPollerThread() : Releasing poller thread handle 85d6ee80 Mon Jul 12 15:00:49 2010 CBsaHandlerBE::vxbsaTerminate() : Session count = 0 85d6ee80 Mon Jul 12 15:00:49 2010 CBsaHandlerBE::vxbsaTerminate() : Releasing poller thread handle
What can I check?
07-14-2010 04:18 AM
Last attempt was unsuccesfull by unknow reasons (I suppose must be due Symantec Backup Exec sends old root credentials under some cirsunstances, but this is difficult to see with RALUS 64bits due aborts when RALUS runs in debug mode).
In next try Symantec was able to see and backup Oracle RAC database but process is hanging and doesn't ends (but from RMAN as oracle owner I can see new backup made OK to tape!).
Now I'm trying to do a "inverse backup": from a RMAN session as oracle user from one node I want to do a simple backup to tape (this worked on a single version of Oracle in Linux 32 bits). But this process fails with:
BEError(0xe0001018) Authentication failed.
But without a clean reason I can (as oracle owner of Oracle software) execute RMAN, access to tapes and delete last semi-succesfull backup made by Symantec Backup Exec (this that was hanging).