OracleDB Archives | Eli's Blog

OEM 13c and Oracle Database Patch Errors

October 7, 2016March 3, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

One of the requirements for upgrading to Enterprise Manager Cloud Control 13c Release 2, is to apply. Database patch set update 160419 While trying to apply the patch to Oracle GI + DB, it will error out with non existing files (more below…).

opatchauto apply 22899531

System initialization log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2016-10-06_02-29-43PM.log.

Session log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchauto/opatchauto2016-10-06_02-29-47PM.log
The id for this session is 136I
[init:init] Executing OPatchAutoBinaryAction action on home /u01/db/12.1.0.1/db_1

Executing OPatch prereq operations to verify patch applicability on SIDB Home........

[..] snip

Patch: 22899531/23006522
Log: /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-10-06_14-41-43PM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: 
Prerequisite check "CheckApplicable" failed. 

After fixing the cause of failure Run opatchauto resume with session id "136I"

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

opatchauto apply 22899531

System initialization log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2016-10-06_02-29-43PM.log.

Session log file is /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchauto/opatchauto2016-10-06_02-29-47PM.log

The id for this session is 136I

[init:init] Executing OPatchAutoBinaryAction action on home /u01/db/12.1.0.1/db_1

Executing OPatch prereq operations to verify patch applicability on SIDB Home........

[..] snip

Patch: 22899531/23006522

Log: /u01/app/grid/12.1.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-10-06_14-41-43PM_1.log

Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException:

Prerequisite check "CheckApplicable" failed.

After fixing the cause of failure Run opatchauto resume with session id "136I"

]

OPATCHAUTO-68061: The orchestration engine failed.

OPATCHAUTO-68061: The orchestration engine failed with return code 1

OPATCHAUTO-68061: Check the log for more details.

OPatchAuto failed.

Note: ocm response file is not needed in latter versions. A […]

Oracle Enterprise Manager, ASM Tips and Tricks

February 16, 2016March 23, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

Contents 1 To set system password 2 EM Cloud control help 3 EM cloud control process order 4 How to deploy a plugin 5 References To set system password

ALTER USER system IDENTIFIED BY password;

1	ALTER USER system IDENTIFIED BY password;

EM Cloud control help

#To stop Oracle Management Service GUI only
emctl stop oms
 
# To stop all services
emctl stop oms -all
 
# To stop the Database Control
emctl stop dbconsole

#To stop Oracle Management Service GUI only

emctl stop oms

# To stop all services

emctl stop oms -all

# To stop the Database Control

emctl stop dbconsole

EM cloud control process order

Step 1:
 cd /u01/app/oracle/middleware/gc_inst/WebTierIH1/bin
./opmnctl status
 
(check the status if it is alive then stop it)
 
./opmnctl stopall
 
Step:2
 
go this directory /u01/app/oracle/middleware/gc_inst/WebTierIH1/config/OPMN/opmn/states
 
create a backup folder move the file (starts with p...) move that file to backup folder
 
now issue the command ./opmnctl startall
 
Step:3
check for any emctl.log files and delete them (find / -name emctl.log -type f)
 
Step:4
then stop OMS and agent
 
/u01/app/oracle/Middleware/oms/bin/emctl stop oms -all
/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl stop agent
then start OMS and agent
 
/u01/app/oracle/Middleware/oms/bin/emctl start oms -all
/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl start agent
Best regards,
Karthik Reddivari

Step 1:

cd /u01/app/oracle/middleware/gc_inst/WebTierIH1/bin

./opmnctl status

(check the status if it is alive then stop it)

./opmnctl stopall

Step:2

go this directory /u01/app/oracle/middleware/gc_inst/WebTierIH1/config/OPMN/opmn/states

create a backup folder move the file (starts with p...) move that file to backup folder

now issue the command ./opmnctl startall

Step:3

check for any emctl.log files and delete them (find / -name emctl.log -type f)

Step:4

then stop OMS and agent

/u01/app/oracle/Middleware/oms/bin/emctl stop oms -all

/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl stop agent

then start OMS and agent

/u01/app/oracle/Middleware/oms/bin/emctl start oms -all

/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl start agent

Best regards,

Karthik Reddivari

In our environment

# Stop the agent
/u01/app/oracle/middleware/oms/bin/emctl stop oms -all
# Stop the agent
/u01/app/oracle/agent12c/agent_inst/bin/emctl stop agent
 
# Start OMS first
/u01/app/oracle/middleware/oms/bin/emctl start oms
# Start the agent
/u01/app/oracle/agent12c/agent_inst/bin/emctl start agent

# Stop the agent

/u01/app/oracle/middleware/oms/bin/emctl stop oms -all

# Stop the agent

/u01/app/oracle/agent12c/agent_inst/bin/emctl stop agent

# Start OMS first

/u01/app/oracle/middleware/oms/bin/emctl start oms

# Start the agent

/u01/app/oracle/agent12c/agent_inst/bin/emctl start agent

How to deploy a plugin Example of F5 plugin

# First login with emcli
/u01/app/oracle/middleware/oms/bin/emcli login -username=usera
 
# unzip plugin, then point to *.opar file
/u01/app/oracle/middleware/oms/bin/emcli import_update -file="/tmp/f5/12.1.0.1.1_F5.BIGIP.LTM_2000_0.opar" -omslocal

# First login with emcli

/u01/app/oracle/middleware/oms/bin/emcli login -username=usera

# unzip plugin, then point to *.opar file

/u01/app/oracle/middleware/oms/bin/emcli import_update -file="/tmp/f5/12.1.0.1.1_F5.BIGIP.LTM_2000_0.opar" -omslocal

[…]

How to recover from an Oracle DB archivelog full error

December 31, 2015March 27, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

How to recover from an Oracle DB if the disk/file system for archive logs gets full Note: if DB is hung at shutdown i.e. shu immediate, then force a shutdown, like below

SQL> shutdown abort;
SQL> startup nomount;
SQL> alter database mount
SQL> exit

SQL> shutdown abort;

SQL> startup nomount;

SQL> alter database mount

SQL> exit

Get size used for if needed

SQL> col name format A50
SQL> col space_limit format A10
SQL> col space_used format A10
select  name,  (space_limit/1024/1024) ||'MB' as Space_Limit,
(space_used/1024/1024)||'MB' as Space_Used from  v$recovery_file_dest;

SQL> col name format A50

SQL> col space_limit format A10

SQL> col space_used format A10

select name, (space_limit/1024/1024) ||'MB' as Space_Limit,

(space_used/1024/1024)||'MB' as Space_Used from v$recovery_file_dest;

Remove Archive logs with rm in ASMCMD

asmcmd -p>
cd DATA/OEM13/ARCHIVELOG/2015_12_31
ASMCMD [+DATA/OEM13/ARCHIVELOG/2015_12_31] > rm thread_1*
ASMCMD [+DATA/OEM13/ARCHIVELOG/2015_12_31] > exit

# Update rman with log info
rman target /
crosscheck archivelog all
delete expired archivelog all

asmcmd -p>

cd DATA/OEM13/ARCHIVELOG/2015_12_31

ASMCMD [+DATA/OEM13/ARCHIVELOG/2015_12_31] > rm thread_1*

ASMCMD [+DATA/OEM13/ARCHIVELOG/2015_12_31] > exit

# Update rman with log info

rman target /

crosscheck archivelog all

delete expired archivelog all

Open the DB for usage

SQL> alter database open

1	SQL> alter database open

Change […]

ASM migrate from one lun to anther lun

December 30, 2015March 3, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

To add new disk array / lun

sqlplus / as sysasm
ALTER DISKGROUP DATA ADD DISK '/dev/rdsk/c1d1s0' REBALANCE POWER 5;

# Fastest 
ALTER DISKGROUP DATA ADD DISK '/dev/rdsk/c1d1s0' REBALANCE POWER 11;

sqlplus / as sysasm

ALTER DISKGROUP DATA ADD DISK '/dev/rdsk/c1d1s0' REBALANCE POWER 5;

# Fastest

ALTER DISKGROUP DATA ADD DISK '/dev/rdsk/c1d1s0' REBALANCE POWER 11;

To verify

SQL> select path,name,header_status from v$asm_disk;

1	SQL> select path,name,header_status from v$asm_disk;

To Check where the rebalnce is up to

select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=1;

1	select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=1;

To remove the old one

# Use the name showing in select disk name
alter diskgroup data drop disk DATA_0000 rebalance power 5;

1 2	# Use the name showing in select disk name alter diskgroup data drop disk DATA_0000 rebalance power 5;

Creating, Adding Additional SCAN Addresses in Oracle Database 11g

December 30, 2014March 27, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static
srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2
srvctl start scan -netnum 2

srvctl status scan -netnum 2
srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2
srvctl start scan_listener -netnum 2

srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2 
srvctl add vip -node 12cdb2 -address 10.10.10.112/255.255.255.0 -netnum 2
srvctl start vip -vip 10.10.10.111
srvctl start vip -vip 10.10.10.112

srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static

srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2

srvctl start scan -netnum 2

srvctl status scan -netnum 2

srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2

srvctl start scan_listener -netnum 2

srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2

srvctl add vip -node 12cdb2 -address 10.10.10.112/255.255.255.0 -netnum 2

srvctl start vip -vip 10.10.10.111

srvctl start vip -vip 10.10.10.112

Adding a second scan address

srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static
srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2
srvctl start scan -netnum 2

srvctl status scan -netnum 2
srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2
srvctl start scan_listener -netnum 2

srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2
srvctl add vip -node 12cdb2 -address 10.10.10.112/255.255.255.0 -netnum 2
srvctl start vip -vip 10.10.10.111
srvctl start vip -vip 10.10.10.112

srvctl add listener -listener LISTENER2 -netnum 2 -endpoints TCP:1521
srvctl start listener -listener LISTENER2

lsnrctl status listener_n2

srvctl add network -netnum 2 -subnet 10.10.10.0/255.255.255.0/aggrpub1 -nettype static

srvctl add scan -scanname 12cdb1-pub-scan.domain.com -netnum 2

srvctl start scan -netnum 2

srvctl status scan -netnum 2

srvctl add scan_listener -netnum 2 -endpoints TCP:1521 -listener listener2

srvctl start scan_listener -netnum 2

srvctl add vip -node 12cdb1 -address 10.10.10.111/255.255.255.0 -netnum 2

srvctl add vip -node 12cdb2 -address 10.10.10.112/255.255.255.0 -netnum 2

srvctl start vip -vip 10.10.10.111

srvctl start vip -vip 10.10.10.112

srvctl add listener -listener LISTENER2 -netnum 2 -endpoints TCP:1521

srvctl start listener -listener LISTENER2

lsnrctl status listener_n2

Refrence http://oracledb101.wordpress.com/2013/10/15/12c-creating-addtional-scan-addresses/

Oracle SQL Database Commend Line Capturing Continues Select

July 14, 2014July 21, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

Example 1

echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep "COUNT|3|Elapsed:" >>/var/tmp/db_timing.out

1	echo exit \| sqlplus / as sysdba @/var/tmp/usera/foo.sh \|egrep "COUNT\|3\|Elapsed:" >>/var/tmp/db_timing.out

Example 2

while :; do echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep "COUNT|3|Elapsed:" >>/var/tmp/db_timing.out; sleep 2; done

1	while :; do echo exit \| sqlplus / as sysdba @/var/tmp/usera/foo.sh \|egrep "COUNT\|3\|Elapsed:" >>/var/tmp/db_timing.out; sleep 2; done

Example 3

while :; do sqlplus eli/eli @/var/tmp/usera/foo.sh >>/var/tmp/db_timing.out ; sleep 2; done

1	while :; do sqlplus eli/eli @/var/tmp/usera/foo.sh >>/var/tmp/db_timing.out ; sleep 2; done

To change the Oracle SQL listner to SDP

July 11, 2014March 27, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

Change pga size, set the pga to at least 32gb >Set to the number of cores

show parameter gcs_server - 16;

1	show parameter gcs_server - 16;

Change DB options to

filesystemio_options     setall

1	filesystemio_options setall

To change listner to SDP

crsctl modify resource ora.LISTENER.lsnr -attr "ENDPOINTS=SDP:1521"

crsctl modify resource ora.LISTENER_SCAN1.lsnr -attr "ENDPOINTS=SDP:1521"
crsctl modify resource ora.LISTENER_SCAN2.lsnr -attr "ENDPOINTS=SDP:1521"
crsctl modify resource ora.LISTENER_SCAN3.lsnr -attr "ENDPOINTS=SDP:1521"

crsctl modify resource ora.LISTENER.lsnr -attr "ENDPOINTS=SDP:1521"

crsctl modify resource ora.LISTENER_SCAN1.lsnr -attr "ENDPOINTS=SDP:1521"

crsctl modify resource ora.LISTENER_SCAN2.lsnr -attr "ENDPOINTS=SDP:1521"

crsctl modify resource ora.LISTENER_SCAN3.lsnr -attr "ENDPOINTS=SDP:1521"

Note: The below setting made issues in our environment

ndd -set /dev/udp udp_do_checksum 0

1	ndd -set /dev/udp udp_do_checksum 0

How to change an Oracle Database from TCP to RDS on Infiniband

July 1, 2014March 27, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

Changing an Oracle Database from TCP to RDS If your Oracle Database runs on an Infiniband network, you can greatly benefit by switching from TCP to RDS for DB cluster communications First enable RDS

svcadm enable svc:/system/rds:default

svcs svc:/system/rds:default
STATE          STIME    FMRI
online          4:40:52 svc:/system/rds:default

svcadm enable svc:/system/rds:default

svcs svc:/system/rds:default

STATE STIME FMRI

online 4:40:52 svc:/system/rds:default

For ASM On one node

crsctl stop cluster -all

1	crsctl stop cluster -all

On all nodes as root

perl rootcrs.pl -unlock -crshome /u01/app/11.2.0.3/grid

su - grid
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ipc_rds ioracle

perl rootcrs.pl -unlock -crshome /u01/app/11.2.0.3/grid

su - grid

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ipc_rds ioracle

Back as root

perl rootcrs.pl -patch

1	perl rootcrs.pl -patch

If you need to […]

Patching An Oracle RAC 11g/12c Grid(GI) / Database

June 12, 2014August 7, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

Process to patch an Oracle 11G/12C RAC Grid infrastructure and or database Note1: Starting with OPatch version 11.2.0.3.14 , 12.1.0.2.12 and higher OCM Is Not bundled with OPatch .OPatch utility may be not look for ocm response file while patching in silent mode . Note2: In older versions the emocmrsp might be located under OPatch […]

Moving Oracle database SPfile from 4k to 512b

June 11, 2014March 27, 2017 Eli Kleinman Leave a comment

(No Ratings Yet)

SSD Arrays and using 4k blocks Some SSD arrays will perform badly or not work at all when used for Database files. The example below was used with a Violin Memory Array, but the same is can be any of the new SSD vendors. Note: The solution below will only work on Linux with asmlib […]

Tag: OracleDB

OEM 13c and Oracle Database Patch Errors

Oracle Enterprise Manager, ASM Tips and Tricks

How to recover from an Oracle DB archivelog full error

ASM migrate from one lun to anther lun

Creating, Adding Additional SCAN Addresses in Oracle Database 11g

Oracle SQL Database Commend Line Capturing Continues Select

To change the Oracle SQL listner to SDP

How to change an Oracle Database from TCP to RDS on Infiniband

Patching An Oracle RAC 11g/12c Grid(GI) / Database

Moving Oracle database SPfile from 4k to 512b

About This Blog

Contact Us

Meta