RCU – Technology Geek

When Creating Domain for Oracle SOA it’s Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.

But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it’s strange case and not acceptable.

after investigation Table Called “REFERENCE_INSTANCE” include information about Running Composite in SOA ans instances. the size for this table 18GB.

Select * from Reference_instance;

Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.

Thank you
Osama Mustafa

Today while i was working on Database trying to Drop user called PRD_MDS the normal error appearing to me :

SQL> drop user PRD_MDS cascade ;
drop user PRD_MDS cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Which is very normal error and the first thing you are trying to check is v$session

SQL> select sid,serial# ,username from v$session where username like ‘%PRD%’;
SID SERIAL# USERNAME
———- ———- ——————————
745 821 PRD_MDS

SQL> alter system kill session ‘745,821’ immediate ;
System altered.

After this i should be able to drop this user without any problem BUT !!!!

SQL> drop user PRD_MDS ;
drop user PRD_MDS
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

I tried to figure out what is going on , Even i tried alter system kill session 10 times the above error will appear BUT there’s always solutions :

SQL> startup force restrict;
ORACLE instance started.
Total System Global Area 7686086656 bytes
Fixed Size 2228032 bytes
Variable Size 1811939520 bytes
Database Buffers 5729419264 bytes
Redo Buffers 142499840 bytes
Database mounted.
Database opened.

SQL> drop user PRD_MDS cascade ;
User dropped.

Tag: RCU

Oracle SOA Tablespace Is full

User Not Able To Drop Even When I killed the session.