When trying to startup [nomount] an instance in 12.2.0.1.0 from sqlplus by using a pfile, (startup nomount pfile=’my_pfile’) the following messages are displayed: ORA-39510: CRS error performing start on instance ‘TESTDB’…
Read More12.2 ADOP Prepare Phase Fails with below error message, Error: Validating configuration on node: [apps]. Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps [UNEXPECTED]Error occurred running “perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps -promptmsg=hide” [UNEXPECTED]Error 1 occurred…
Read MoreMany of us would have come across the word “Multitenant Architecture” in Oracle world. By the time, we read this, some of us feel boring to go in detail and…
Read Moreset term on; set lines 130; column sid_ser format a12 heading 'session,|serial#'; column username format a12 heading 'os user/|db user'; column process format a9 heading 'os|process'; column spid format a7…
Read MorePlease use below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreCheck the OLAP option is enabled in database. select parameter, value from v$option where parameter = ‘OLAP’; PARAMETER VALUE OLAP FALSE select comp_id, comp_name, version, status, schema from dba_registry where…
Read MoreRMAN active duplicate fails with error: RMAN-03002: failure of Duplicate Db command at 09/25/2018 08:24:05 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19849:…
Read MoreSTOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs $GRID_HOME/bin/crsctl enable crs Find the cluster name…
Read MoreDeclaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed. Script:…
Read MoreThe steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…
Read More