About OTNYathra

OTNYathra is one day event which is organized by AIOUG / Oracle Community ACE / ACE Directors / OUG Evangelists on every year.

This is series of six conferences across six major cities (Chennai,Bangalore,Hyderabad,Pune,Mumbai,Gurgaon)

Mostly there are three parallel classroom sessions are going on so you can decide and seat in your interested session.

This is not a commercial event, They are collecting Rs. 500 as registration fee to cover the Lunch/Tee/Coffee/Snacks and other logistics to host the event.

I’m regularly attend this event since 2014.

As per my opinion this is the best technical one day event that i recommended to attend to all the DBA and Developers.

AIOUG also started local chapter in all above region.

I hope that AIOUG Gujarat Chapter will start officially very soon.

You can check latest information on my OTN Blog
https://community.oracle.com/blogs/hiteshgondalia/2017/05/16/aioug-gujarat-chapter

Website: http://otnyathra.in

You can check session information using this link(http://otnyathra.in/{name of city}/)
http://otnyathra.in/mumbai

Link to register in event
http://otnyathra.in/register

Advertisements

Oracle12c DB Service failover Behavior change

-bash-4.1$ srvctl stop instance -h

Stops the database instance.

Usage: srvctl stop instance -db {-node | -instance } [-stopoption ] [-force] [-failover]
-db Unique name for the database
-node Node name
-instance “” Comma separated instance names
-stopoption Options to instance shutdown command (e.g. NORMAL, “TRANSACTIONAL LOCAL”, IMMEDIATE, or ABORT)
-force Forcibly stop the instance and any running services.
-failover Allow the running services to fail over to another instance
-help Print usage
-bash-4.1$
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -s ndb1 -f
PRKO-2002 : Invalid command line option: -s
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i ndb1 -f
Invalid instance name(s): ndb1
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i blrdb1 -f
-bash-4.1$ srvctl start instance -d blrdb -i blrdb1
-bash-4.1$
-bash-4.1$
-bash-4.1$ srvctl stop instance -d blrdb -i blrdb1 -failover
-bash-4.1$
-bash-4.1$ srvctl start instance -d blrdb -i blrdb1

tfactl – Diagnostic data Collection for troubleshooting the issue of GI, ASM, and RAC

Diagnostic data is needed for troubleshooting the issue.

Execute the action plan described in [ DOC ID 2041228.1 ] “SRDC – Data Collection for Grid Infrastructure, Storage Management, and RAC” and upload the information collected to ensure rapid resolution.

Use the following command to run TFA:
$GI_HOME/tfa/bin/tfactl diagcollect -from “MMM/dd/yyyy hh:mm:ss” -to “MMM/dd/yyyy hh:mm:ss”

Date and time format example: “Jul/1/2014 21:00:00”
Specify the “from time” to be 4 hours before and the “to time” to be 4 hours after the time of error.

/u01/app/12.1.0.2/grid/tfa/bin/tfactl diagcollect -from “Sep/3/2016 12:00:00” -to “Sep/4/2016 08:00:00”

/u01/app/12.1.0.2/grid/tfa/bin/tfactl diagcollect -from “Sep/4/2016 01:00:00” -to “Sep/4/2016 02:28:00”