Anuj Singh Oracle DBA
Monday, 16 August 2010
Oracle The OPatch Utility to check oracle patch information
›
cd $ORACLE_HOME oracle@solomon:/opt/oracle/product/10.2/OPatch> cd OPatch oracle@solomon:/opt/oracle/product/10.2/OPatch> ./opat...
12 comments:
sqlplus / as sysdba hanged ...
›
if sqlplus / as sysdba hanged .... ( and database down ) .. then try this oracle@solomon:~> rman Recovery Manager: Release 10.2.0.4.0 -...
Friday, 13 August 2010
Oracle data pump export through cron
›
# !/bin/bash TODAY=`date` ORACLE_SID=cccdb ; export ORACLE_SID ORACLE_BASE=/opt/oracle ; export ORACLE_BASE ORACLE_HOME=/opt/oracle/product/...
Wednesday, 11 August 2010
List all srvctl commands
›
List all srvctl commands srvctl –h Shutdown service srvctl stop service –d database_name Shutdown the database on all nodes srvctl stop data...
Monday, 9 August 2010
Oracle invalid objects
›
Oracle Invalid objects .... object info define OBJECT_NAME='xxxxxxx' set linesize 300 col OWNER for a15 col OBJECT_NAME fo...
14 comments:
‹
›
Home
View web version