Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.



My Cloud Certifications:

Certified Kubernetes Administrator (CKA)

Cloud Certified Security Professional (ISC2)

CyberSecurity Certified Professional (ISC2)

AWS Certified Solutions Architect Associate

Azure Certified Architect Expert

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Wednesday, January 8, 2014

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options ORA-27054 ORA-01580



RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/08/2014 18:02:28
ORA-01580: error creating control backup file /export/u0/DBS/dbs/snapcf_DBSP1.f
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 1


The workaround recommended is to use the Event 10298.
sql> alter system set events '10298 trace name context forever, level 32';

 

 

Friday, December 27, 2013

11i/R12 query FND_NODES

    set lines 200
    col host_name for a11
    col node_name for a11
    col database for a10
    col concmgr for a9
    col forms for a7
    col webserver for a11
    col admin for a7
    select
    NODE_NAME,
    decode(STATUS,'Y','ACTIVE','INACTIVE') Status,
    decode(SUPPORT_CP,'Y', 'YES','NO') ConcMgr,
    decode(SUPPORT_FORMS,'Y','YES', 'NO') Forms,
    decode(SUPPORT_WEB,'Y','YES', 'NO') WebServer,
    decode(SUPPORT_ADMIN, 'Y','YES', 'NO') Admin,
    decode(SUPPORT_DB, 'Y','YES', 'NO') Database
    from fnd_nodes
    where node_name != 'AUTHENTICATION' order by NODE_NAME;

Saturday, April 27, 2013

Kill all the O.S process of a particular user | kill -9

Want to kill all the O.S process that are running under particular user.

UNIX$ ps -aef  | grep -i shaik | awk '{print $2}' | sed 's/^/kill -9 /' > 1.txt
UNIX$./1.txt


Saturday, February 9, 2013

Passed Exadata 1Z0-536

Got the result today and passed the 1Z0-536 Exadata implementation specialist certification.

Those who are planning to take the test.

Read the student guide-1 atleast 4-5 times and practice IORM as many times as possible. Most of the questions are scenario based and difficulty level was easy to moderate .

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&p_org_id=1001&lang=US&get_params=dc:D73668GC10,p_preview:N

From student guide-2 read the best practices and migrations, there was only one to two questions on monitoring so I wouldn't spend much time on guide-2 on the monitoring side.

Anyway it was easy and finally passed the test with 88% and now I am Oracle certified specialist..

Good luck everyone.


Thursday, January 31, 2013

EXADATA Inifiniband ILOM

If you cannot access the webpage then make sure https access is not turned off via cli after logging into IB switch.
Note-:
If You disable both HTTP and HTTPS access to the switch by doing so in the Web Server Settings section in ILOM, or in paths /SP/services/http and /SP/services/https in the CLI.
It can be re-enabled in the CLI. This will not impact the EM IB switch plug-in, which relies on SNMP.


ssh into the IP switch and change the configuration as needed.


To get the IB switch details:

 cd    /opt/oracle.SupportTools/onecommand
>cat dbm.dat | grep ib
SWITCH "Switch" pda1sw-ib1 1.1.71.85
SWITCH "Switch" pda1sw-ib2 1.1.71.86
SWITCH "Switch" pda1sw-ib3 1.1.71.87


now pull the ILOM page  https://pda1sw-ib1















go to switch monitoring tab:





This will pull the switch info: