OEM 13c and Oracle Database Patch Errors

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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…).

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

Read More

Oracle Enterprise Manager, ASM Tips and Tricks

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

EM Cloud control help

EM cloud control process order

In our environment

How to deploy a plugin Example of F5 plugin

[…]

Read More

How to recover from an Oracle DB archivelog full error

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

Get size used for if needed

Remove Archive logs with rm in ASMCMD

Open the DB for usage

Change […]

Read More

ASM migrate from one lun to anther lun

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

To add new disk array / lun

To verify

To Check where the rebalnce is up to

To remove the old one

Read More

Creating, Adding Additional SCAN Addresses in Oracle Database 11g

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Adding a second scan address

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

Read More

Oracle SQL Database Commend Line Capturing Continues Select

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Example 1

Example 2

Example 3

Read More

To change the Oracle SQL listner to SDP

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

Change DB options to

To change listner to SDP

Note: The below setting made issues in our environment

Read More

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

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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

For ASM On one node

On all nodes as root

Back as root

If you need to […]

Read More