iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

November 18, 2017, 12:24:56 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: Upgrading Oracle Database standalone checklist.  (Read 38476 times)
AllanDBA
AllanDBA
Newbie
Newbie
*
Posts: 0


« on: May 12, 2015, 08:19:33 AM »

Upgrading Oracle Database standalone checklist.
=======================================================================
You can run the command below from anyone of the emcapp machines to modify the ORALE_HOME path after upgrade. I?m finding this to be faster than doing it from emgcapp console. 
# emcli modify_target -name="$var_1" -type="oracle_database" -porperties="Oracle_Home:$var_2" -on_agent

If you want to get a little more advanced you can run a command like this to cover a whole server
# for i in `ssh oracle@p-eds-oracle1t.iselfschooling . /export/edsora/scripts/test/patches/test.sh`; do var_1=`echo $i | awk -F: '{print $1}'`; export var_1; var_2=`echo $i | awk -F: '{print $2}'`; export var_2; echo $var_1;  emcli modify_target -name="$var_1" -type="oracle_database" -porperties="Oracle_Home:$var_2" -on_agent; done

NOTE:
The listener is version 12c.
The tnsnames.ora file was moved the ORACLE12c/network/admin. Check the sqlnet.ora file, too.
flashback database to restore point ?.; -- dbua does it.
alter database drop standby logfile group 4;
alter database backup controlfile to trace as '/recovery_area/PERFSTAT_iselfschooling/onlinelog/trace.txt';
exec dbms_stats.purge_stats(sysdate-2);
@?/rdbms/admin/utlu121s.sql
@?/rdbms/admin/utlrp.sql
You can track it via /app/oracle/cfgtoollogs/dbua/<sid>
================================================Primary and Standby
1.   Check /var/opt/oracle/oratab
2.   Check undo and temp size?
3.   Check registry - column comp_name format a40; select comp_name, version, status from dba_registry;
4.   Check the target memory. Set it to 6G and recovery area to 300G ? show parameter memory
5.   Check the recovery area usage ? show parameter recovery ? select * from v$recovery_area_usage;
6.   Check the flashback on. Should be ?Yes? ? select flashback_on from v$database;
================================================Primary
7.   shutdown the standby database ? important ?
8.   backup the database ?
9.   Change the listener pointing to 12c ? reload the listener
10.   Change to the Oracle12c (12.1.0.2) home and run dbua
11.   Select Recompilation Parallelism to 7
12.   Unselect the OEM configuration  Database Express on the upgrade screen and use all default
13.   Select Oracle12c listener and Unselect not to register the database (Select ?No, don?t register the database?)
14.   Use Flashback and Guaranteed restore point
15.   Look for the errors and make an action if there is any invalid packages
16.   Check registry - column comp_name format a40; select comp_name, version, status from dba_registry;
17.   Check the process: # /app/oracle/cfgtoollogs/dbua/assett_iselfschooling/upgrade2/catupgrad0.log and trace.log on post steps
================================================Primary?
18.   On HOME/network/admin new release
19.   Create pfile from spfile; -- on primary
20.   Change the dbs/init* file - remove dg_broker_config_file1,2 and local_listerner
21.   create spfile from pfile; and restart the database
22.   check the tnsnames ? assett_iselfschooling and assett_iselfschooling_2 using service_name=asset_iselfschooling_dgmgrl
23.   Copy the dr* to $ORACLE 12c HOME/dbs
================================================Standby?
24.   . Create pfile from spfile;  -- at old Oracle home
25.   Change the listener and reload it
26.   Copy the standby init*, orapw, dr* files to the Oracle12c (new) home/dbs directory
27.   vi init* - remove db_broker_config_file and increase mem and change compatible parameter ? if any
28.   Go to new home 12c
29.   Create spfile from pfile.
30.   Start on mount the standby database with release 12c.
31.   Check the Dataguard manager dgmgrl ? dgmgrl sys/?.
32.   If you get the following error: ORA-16532: Data Guard broker configuration does not exist
33.   restart the primary database.
34.   disable configuration;
35.   DGMGRL> edit database your-standby set property 'LogXptMode'='SYNC';  -- if needed ?
36.   Change the dba.menu /export/?
37.   ================================================ If there is an error ?
38.   startup mount; -- on Oracle12c
39.   FLASHBACK DATABASE TO RESTORE POINT back2test;
40.   alter database open resetlogs;
41.   Drop the restore point ?. ? on Oracle11g if we have problem?
42.   OEM update ?
43.   on the standby we need to flashback it too?
44.   SQL> flashback database to timestamp to_date('04/11/2015 11:47:33', 'mm/dd/yyyy hh24:mi:ss');
=========================================
CREATE OR REPLACE TRIGGER MANAGE_assetp
                  AFTER STARTUP ON DATABASE
           DECLARE
                 ROLE VARCHAR (30);
           BEGIN
                 SELECT DATABASE_ROLE INTO ROLE FROM V$DATABASE;
                 IF ROLE = 'PRIMARY' THEN
                        DBMS_SERVICE.START_SERVICE ('assetp.iselfschooling');
                END IF;
          END;
/
exec dbms_service.create_service ( -
     service_name => 'assetp.iselfschooling', -
     network_name => 'assetp.iselfschooling', -
     failover_method => 'BASIC', -
     failover_type => 'SELECT', -
     failover_retries => 180, -
     failover_delay => 1);

# cd $ORACLE_HOME/bin
# chmod 4550 oradism
# chmod g+s oradism
# chown root:dba oradism

Its the oradism binary.  We have discussed this before.  The binary needs to be set to 4550.  The document is on the wiki and the share.  The link is below.
http://p-eds-status-report.iselfschooling:8080/display/PM/Clone+Newly+Patched+ORACLE_HOME

CREATE CONFIGURATION dg_hcmqat AS PRIMARY DATABASE is hcmqat_iselfschooling CONNECT IDENTIFIER is hcmqat_iselfschooling;
ADD DATABASE hcmqat_iselfschooling_2 AS CONNECT IDENTIFIER is hcmqat_iselfschooling_2 MAINTAINED AS PHYSICAL;

-- Change the protection mode to MaxAvailability:
DGMGRL> show database verbose your-standby LogXptMode;
DGMGRL> edit database your-standby set property 'LogXptMode'='SYNC';
DGMGRL> edit configuration set protection mode as maxavailability;
DGMGRL> show configuration;
Backup with tar ?
# cd /recovery_area
# mkdir backup
# cd backup
# tar ?cvfE epmqat.tar /oradata/epmqat

select * from
(
  select
     opname,
     start_time,
     target,
     sofar,
     totalwork,
     units,
     elapsed_seconds,
     message
   from
        v$session_longops
  order by start_time desc
)
where rownum <=1;
Logged
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!