CRS-0215 & PRKP-1001 when starting RAC database
CRS-0215 & PRKP-1001 when starting RAC database Setup is with oracle 11.2.0.3 , 2 node RAC database. I have created a a new spfle and deleted old one. old spfile…
Read MoreORA-29701: Unable to connect to Cluster Manager
ORA-29701: Unable to connect to Cluster Manager When trying to start the ASM instance in cluster, and getting the below error ORA-29701: Unable to connect to Cluster Manager. Solution :…
Read MoreError Oracle – 20001
Error Oracle – 20001 When trying to assign responsibility to a user, the following error occurs. ERROR Error Oracle – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE(USERNAME=AKUMAE) (ROLENAME=FND_RESP|INV|XXFM_ROUTIN_VIEW|STANDARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT…
Read MorePatch Wizard Configuration and Patch Analysis without accessing the Internet
Patch Wizard Configuration and Patch Analysis without accessing the Internet (Without Providing Metalink Credentials) in EBS R12 1. We can run patch wizard without accessing internet connection by downloading the…
Read MoreOUI-67215: OPatch found the word “warning” in the stderr of the make command.
Opatch Warning During Patch Apply : “ld: warning: option -YP or -Q appears more than once, first setting taken ERROR: ————- You may receive the following warning while applying the…
Read MoreShow_user_with_top_io
SELECT ses.sid, ses.serial#, ses.osuser, ses.process, sio.physical_reads FROM v$session ses, v$sess_io sio WHERE ses.sid = sio.sid AND nvl(ses.username,’SYS’) not in (‘SYS’, ‘SYSTEM’) AND sio.physical_reads =…
Read MoreShow_statistics_of_connected_users
col osuser format a10 trunc heading “OSUSER AS” col orauser format a10 trunc col machine format a10 trunc col sprogram format a15 trunc col process format a20 trunc col server…
Read MoreRac_balance_delta
col instance_name format a20 heading “Instance|name” col elapsed_seconds format 999,999 Heading “Elapsed|seconds” col cpu_ms_ps format 999,999.99 heading “CPU ms|p.s.” col db_ms_ps format 999,999.99 heading “DB time|ms p.s.” set pages 1000…
Read MoreLogged on Users
SET linesize 200 PAGESIZE 1000 FEED OFF; COLUMN “sid,serial#” FORMAT A12 COLUMN “pid” FORMAT 999 COLUMN “status” FORMAT A8 COLUMN “schema” FORMAT A10 COLUMN “osuser” FORMAT A10 COLUMN “box” FORMAT…
Read More