adgendbc.sh INSTE8_SETUP 1

Autoconfig Fails with error adgendbc.sh INSTE8_SETUP 1
login to database and check

show parameter jit, set it to false from true

alter system set JAVA_JIT_ENABLED= FALSE scope = both;

Bounce both DB and Application Tier and then re-run the autoconfig. The autoconfig will complete successfully

ref:Adgendbc Fails With Database Connection Failure (Doc ID 1302708.1)

ORA-17629: Cannot connect to the remote database server

The situation was I had to clone another ebs from artemis:hrcp to Athena:hrcd..  This two servers were created hap hazardly before. My plan was to restore o cone the Athena with artemis using rman duplicate. normally I would use a dr to do this. but unfortunately artemis does not have a dr site. Instead we will be duplication g from al ive database.

The hallenges I had was with connection.s.

I keep getting n n error that I connect to the remote server.

Artemis cannot ping hrcp and hrcd this is further complicated that it was looking for iflies. so I had to ocpy the old files. example
hrp_

ORACLE EBS compile workflow

WFLOAD apps/r132td1fndxx 0 Y UPLOAD EC_SCRAP.wft​

ERROR at line 1: ORA-01940: cannot drop a user that is currently connected

SQL>  select s.sid, s.serial#, s.status, p.spid
from v$session s, v$process p
where s.username = 'CHRS'
and p.addr (+) = s.paddr;  2    3    4

       SID    SERIAL# STATUS   SPID
---------- ---------- -------- ------------------------
       139      17563 INACTIVE 21630
       142      56779 ACTIVE   10920
       148      20995 INACTIVE 27150

SQL> alter system kill session '142,56779';

System altered.

Moving UNDO datafiles Oracle

SELECT a.name,b.status , d.username , d.sid , d.serial#
FROM   v$rollname a,v$rollstat b, v$transaction c , v$session d
WHERE  a.usn = b.usn
AND    a.usn = c.xidusn
AND    c.ses_addr = d.saddr
AND    a.name IN (
  SELECT segment_name
  FROM dba_segments
 WHERE tablespace_name = 'RBS'
);

create undo tablespace UNDOTBS2 datafile '/dba0B/oradata/ORAP/UNDOTBS01.DBF' size 5000M;

select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status;

ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2 SCOPE=BOTH;

select * from dba_rollback_segs group by tablespace_name, status;


select count(segment_name),sum(bytes/1024/1024),status from dba_undo_extents group by status;


To do
1. after rbs is offline drop it
2. create new undo tablespace /dba0a
3. switch to undotbs
4. drop unotbs2

Oracle moving datafiles

https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files

use rman


/dba0A/oradata/ORAP/APPS_TS_SUMMARY37.dbf  36

copy datafile 36 TO '/dba0B/oradata/ORAP/APPS_TS_SUMMARY37.dbf'

SQL 'ALTER TABLESPACE APPS_TS_SUMMARY OFFLINE';

SWITCH DATAFILE 36 TO COPY;
RECOVER TABLESPACE APPS_TS_SUMMARY;

SQL 'ALTER TABLESPACE APPS_TS_SUMMARY ONLINE';

HOST 'rm /dba0A/oradata/ORAP/APPS_TS_SUMMARY37.dbf';

Setting FAST RECOVERY AREA for Oracle

Today I have a new database that was just cloned from a VM. I wanted to make improvements on it by putting a backup on both disk and tape.

The first command I use was to show the existing parameters on the database.

show parameter recovery

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
recovery_parallelism                 integer     0

SQL>

We see that there is nothing set. The first thing we want to do is to set a recovery size and after that the destination.

SQL> alter system set db_recovery_file_dest_size=150G;

System altered.

SQL> alter system set db_recovery_file_dest ='/backup/fast_recovery_area';

System altered.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter db_reco

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /backup/fast_recovery_area
db_recovery_file_dest_size           big integer 150G
SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST';

System altered.