CREATE OR REPLACE TRIGGER block_tools_from_prod AFTER LOGON ON DATABASE DECLARE v_prog sys.v_$session.program%TYPE; BEGIN SELECT program INTO v_prog FROM sys.v_$session WHERE audsid = USERENV('SESSIONID') AND audsid != 0 -- Don't Check…
Read MoreORA-01940: cannot drop a user that is currently connected Solution: sql> drop user oracle;drop user oracle*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected sql> select sid, serial# from v$session where username = ‘oracle‘;SID SERIAL#—– ——–17 37 sql> alter system kill session ‘17,37;System altered. sql> drop user oracle;User dropped.
Read MoreORA-609 : opiodr aborting process unknown ospid Solution: Increase the values for INBOUND_CONNECT_TIMEOUT at both listener and server side sqlnet.ora file as a preventive measure. If the problem is due to connection timeouts,an increase in the following parameters should eliminate or reduce the occurrence of the ORA-609s. Sqlnet.ora: SQLNET.INBOUND_CONNECT_TIMEOUT=180 Listener.ora: INBOUND_CONNECT_TIMEOUT_listener_name=120
Read MoreORA-25153 temporary tablespace is empty Solution: Use one of the below to fix the issue. 1. Create new datafile for defaul TEMP tablespace or solution 2 SQL> alter tablespace temp add tempfile ‘xxx/temp.dbf’ size 500M; Tablespace altered. 2.Make existing TEMP1 tablesapcle to defaul temporary tablespace SQL> alter database default temporary tablespace temp1; Database altered. 3. SQL> drop tablespace temp including contents and datafiles; SQL> create temporary tablespace temp tempfile ‘xxx/temp01.dbf’ size 100m autoextend off extent management local uniform size 1m; SQL> alter database default temporary tablespace temp; 4. Issue exists only for particular use then SQL> alter user sys temporary tablespace temp1;
Read MorePlease follow the below steps. 1.On the OMS host, from the OMS home, log in to the EMCLI client. EMCLI Client is available by default with every OMS installation, so…
Read MorePlease use the below dynamic query and get the script to compile your invalids instead of compiling 1 by 1. select ‘alter FUNCTION “‘||owner||'”.’||object_name||’ compile;’ from dba_objects where status=’INVALID’ and…
Read MorePlease follow the below step to update the timezone in a database whenever you upgrade the database if your timezone version is less than 14. SQL> select * from v$timezone_file;…
Read MoreOATM Migration Not Completed 100% Errors With: Io exception: invalid arguments in call The issue can be reproduced at will with the following steps: 1. Run the OATM migration.…
Read MoreImages and Charts Oracle BI Publisher supports several methods of including images or charts in an Oracle BI Publisher report. • Direct insertion • URL reference • OA_MEDIA directory reference…
Read MoreRunning OATM Migration Utility Fails With “sh: syntax error at line 1: `(‘ unexpected “ SYMPTOMS When attempting to run OATM migration utility to Generate Migration Commands options, by…
Read More