Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Upgradation & Patching


oracle@venu1> cat /etc/oratab
oracle@venu1> export ORACLE_SID=sales
oracle@venu1> sqlplus / as sysdba
SQL> startup
SQL> select version from v$instance;
SQL> select * from v$version;
SQL> select platform_name,platform_id from v$database;
oracle@venu1 bin> file oracle

Take the backup of ORACLE HOME

oracle@venu1> cd /u01/app/oracle/product/11.2.0.1
oracle@venu1 11.2.0.1> ls
oracle@venu1 11.2.0.1> tar -cvf /opt/bkp.tar db_home/
-local inventory
-global inventory
root@venu1> mkdir -p /u03/app/oracle/product/11.2.0.3/db_home
root@venu1> chown -R oracle:oinstall /u03/app/oracle/product/11.2.0.3/db_home
root@venu1> chmod -R 775 /u03/app/oracle/product/11.2.0.3.db_home
root@venu1> cd /opt
root@venu1 opt> unzip 1of7.zip and 2of7.zip from oracle software.
root@venu1 opt> du -sh database --> to check the directory size.
root@venu1> xhost +
root@venu1> su - oracle
oracle@venu1> vncpasswd
oracle@venu1> vncserver
oracle@venu1> vncviewer
oracle@venu1> /opt/database/runInstaller

Just change the "Software Location" in the oracle software installation process.
Remove "oper" from the drop list.
Ignore all.

oracle@venu1> cp .bash_profile .11203_profile
oracle@venu1> vi .11203_profile
Change the paths as needed.
:wq!
oracle@venu1> . .11203_profile
oracle@venu1> sqlplus -v
oracle@venu1> . .bash_profile
oracle@venu1> sqlplus -v
oracle@venu1> export ORACLE_SID=sales
oracle@venu1> sqlplus / as sysdba
SQL> startup
SQL> show parameter spfile;
SQL> exit;
oracle@venu1> cd $ORACLE_HOME/dbs
oracle@venu1 dbs> ls
oracle@venu1 dbs> cp spfilesales.ora /u03/app/oracle/product/11.2.0.3/db_home/dbs
oracle@venu1> . .11203_profile
oracle@venu1> sqlplus -v
oracle@venu1> export ORACLE_SID=sales
oracle@venu1> sqlplus / as sysdba
SQL> startup upgrade
SQL> @$ORACLE_HOME/rdbms/admin/catupgrade.sql
SQL> select object_name,status from dba_objects where status='INVALID';
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> select comp_name,status,version from dba_registry;
SQL> shut immediate

Related Posts Plugin for WordPress, Blogger...

Flag Counter