Solaris is one of the flavor of UNIX and is currently controlled by Oracle corporation.
Below are some of the useful Soalris command from DBA perspectives.
Leave a CommentI’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Solaris is one of the flavor of UNIX and is currently controlled by Oracle corporation.
Below are some of the useful Soalris command from DBA perspectives.
Leave a CommentR12: Login was Failing Intermittently With Error “oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION”
Or getting below error when trying to access EB R12 login page.
If webadi look and feel seems distorted in 11i/R12 then you can check below profile option
Sometimes it is required to flush the BAD SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID
1) FIND ADDRESS AND HASH_VALUE OF SQL_ID
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '7yc%'; ADDRESS HASH_VALUE ---------------- ---------- 000000085FD77CF0 808321886
5 Comments
Finding the SQL_ID for a SQL Statement is straight forward task. You can use query like below to find the SQL_ID
SQL> SELECT sql_id, hash_value, SUBSTR(sql_text,1,40) Text FROM v$sql WHERE sql_text LIKE '%&An_Identifiable_String%';
To Determine the SQL_ID of a SQL Statement in a PL/SQL Block below steps can be followed:
2 CommentsCouple of ASM disk headers were accidentally removed by UNIX sysadmin team.
After disk headers got removed, the database kept running for some time as the data inside disk was intact. When scheduled RMAN backup kicked off the database came down.
1 CommentA normal SQL statement go through below phase before producing results.
1) PARSE PHASE
In our EBS R12 instance we have seen forms process consuming high CPU resources causing other applications processes to run slow. Our EBS R12 application…
1 CommentIn one of our EBS database we faced issue when connecting to SQLPLUS
Error message which was coming up was as below:
[oracle@dbserver bin]$ sqlplus apps/apps
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 11 (asmadmin), current egid =
17 (oinstall)
We have seen this error couple of times in the Concurrent manager Administer screen in our 11i/R12 EBS instances.
Below steps have proven helpful in sorting out this issue:
2 Comments