Data Backup and Recovery

SnapCreator error after connecting to Oracle DB?

jntballard
3,042 Views

After reviewing the logs I noticed the following error in the section connecting to the DB:

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE    11.2.0.2.0      Production

TNS for Solaris: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options]

stderr: [ORACLE_HOME=/oracle/SBW/: Command not found

export: Command not found

ORACLE_SID=SBW: Command not found

export: Command not found]

[Fri Jun  3 11:45:16 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/QDGwEXTyn4.sc] for database SBW finished successfully

[Fri Jun  3 11:45:16 2011] [leopard:9090(3.3.0.1)] DEBUG: Verifying correct of database SBW finished successfully

[Fri Jun  3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Database SBW is running Oracle 11

[Fri Jun  3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Verifying RAC status for database SBW

[Fri Jun  3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:

connect / as sysdba;

show parameter CLUSTER_DATABASE;

exit;

[Fri Jun  3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/Ik7BkO_7jm.sc] for database SBW

[Fri Jun  3 11:45:17 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/Ik7BkO_7jm.sc"] finished with

exit code: [0]

stdout: [Oracle Corporation     SunOS 5.10      Generic Patch   January 2005

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:17 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected.

--------------------------------------------------------------------------------

Is this an issue?  It appears to connect to the DB correctly...

########## Application unquiesce ##########

[Fri Jun  3 11:45:19 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing databases

[Fri Jun  3 11:45:19 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing database SBW

[Fri Jun  3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Ending hot backup mode for database SBW

[Fri Jun  3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:

connect / as sysdba;

alter database end backup;

alter system archive log current;

exit;

[Fri Jun  3 11:45:19 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/V5oCPvyXPz.sc] for database SBW

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/V5oCPvyXPz.sc"] finished with

exit code: [0]

stdout: [Oracle Corporation     SunOS 5.10      Generic Patch   January 2005

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:20 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected.

Database altered.

System altered.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options]

stderr: [ORACLE_HOME=/oracle/SBW/: Command not found

export: Command not found

ORACLE_SID=SBW: Command not found

export: Command not found]

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/V5oCPvyXPz.sc] for database SBW finished successfully

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Ending hot backup mode for database SBW finished successfully

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Creating a backup controlfile for SBW to /oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing SQL sequence:

connect / as sysdba;

alter database backup controlfile to trace as '/oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace' reuse;

exit;

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/yyr7jr9Odz.sc] for database SBW

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Command [/bin/su - orasbw -c "ORACLE_HOME=/oracle/SBW/;export ORACLE_HOME;ORACLE_SID=SBW;export ORACLE_SID;/oracle/SBW/112_64/bin/sqlplus /nolog @/tmp/yyr7jr9Odz.sc"] finished with

exit code: [0]

stdout: [Oracle Corporation     SunOS 5.10      Generic Patch   January 2005

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 3 11:45:20 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected.

Database altered.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options]

stderr: [ORACLE_HOME=/oracle/SBW/: Command not found

export: Command not found

ORACLE_SID=SBW: Command not found

export: Command not found]

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Executing external sql script [/tmp/yyr7jr9Odz.sc] for database SBW finished successfully

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] DEBUG: Creating a backup controlfile for SBW to /oracle/SBW/origlogA/cntrl/netapp/SBW_postBackup_trace finished successfully

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing database SBW finished successfully

[Fri Jun  3 11:45:20 2011] [leopard:9090(3.3.0.1)] INFO: Unquiescing databases finished successfully

########## POST APPLICATION UNQUIESCE COMMANDS ##########

3 REPLIES 3

ktenzer
3,042 Views

The SC oracle plugin does export of ORACLE_HOME and ORACLE_SID and the export command does not appear to be in the path, never seen that before but add export command to path so when you do "export ORACLE_HOME=/oracle/SBW" it works.

Regards,

Keith

jntballard
3,042 Views

They are using CSH. vs KSH/SH/BASH.   That explains why 'export' does not work.   Not sure why they are using CSH, they currently source all of their environment variables for Oracle via the .cshrc, etc... Have not seen this for about 15 years.   I have a feeling since the entire environment is set up this way for Oracle they are going to be reluctant to change. 

Everything appears to have ran from what I can see in the logs.   How important is it that these vars are exported?  Since the DB operations are successful....

Thanks,

Jerry

ktenzer
3,042 Views

As long as everything else is working and we can connect / perform sqlplus operations they can be safely ignored, it isnt hurting anything if ORACLE_SID and ORACLE_HOME are set.

Keith

Public