Posts

Showing posts from November, 2022

What to do when SYSAUX Tablespace Grows Rapidly

 There is no single source for higher than expected growth in the SYSAUX tablespace:  There are however a few common sources that can be investigated and confirmed quickly using a few views and scripts One important view is V$SYSAUX_OCCUPANTS Another very useful and provided script is the AWRINFO.SQL script found in the Oracle_home/rdbms/admin directory Let's start by taking a closer look at V$SYSAUX_OCCUPANTS*    select OCCUPANT_NAME,OCCUPANT_DESC       from V$SYSAUX_OCCUPANTS       order by SPACE_USAGE_KBYTES desc    select SPACE_USAGE_KBYTES, OCCUPANT_NAME       from V$SYSAUX_OCCUPANTS       order by  1 desc SPACE_USAGE_KBYTES OCCUPANT_NAME ------------------ -------------------------------- (1)            118144 SM/AWR (2)             23360 SM/OPTSTAT                 13696 LOGMNR (3)             10368 SM/ADVISOR ***                  6720 SM/OTHER                  3584 WM                  3264 SMON_SCN_TIME        1. Check how many partitions do exist for the offen

what is the difference truncate or delete - All Records

very basic question:  to delete data for more than 100 tables and wanted to retain the table structure and index. Which one is the best option to remove all data from table TRUNCATE or DELETE? truncate is DDL. which means - implicit commit before the statement - implicit commit after the statement - the high water mark of the table will be reset It will use no redo and can not be rolled back. delete is dml it means if no commit after the statement The HWM will not be reset. commit/rolled back is possible DROP :   It is a DDL. It is used to drop the whole table. With the help of the “DROP” command we can drop the whole structure in one go it removes the object from the schema.  DROP table table-name purge; c an’t restore the table by using the “ROLLBACK” command because it auto commits. DELETE :   it is dml  It is used to delete one or more tuples of a table. With the help of the “DELETE” command, we can either delete all the rows in one go or can delete rows one by one. i.e., we can us

How to increase TABLESPACE size in ASM

 Re-sizing data files in ASM is very straightforward. +ASM oraprod@appsolworld:/home/oracle>sqlplus / as sysdba SSQL*Plus: Release 19.0.0.0.0 - Production on Sun Nov 27 19:53:53 2022 Version 19.14.0.0.0 Copyright (c) 1982, 2021, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.0.0.0 SQL> select name from v$datafile; NAME ——————————————————————————– +DBA/appsolworld/datafile/system.260.932399649 +DBA/appsolworld/datafile/sysaux.261.932399653 +DBA/appsolworld/datafile/undotbs1.262.932399655 +DBA/appsolworld/datafile/users.264.932399665 +DBA/appsolworld/datafile/cw_data.266.933506593 +DBA/appsolworld/datafile/cw_index.267.933506607 +DBA/appsolworld/datafile/tools.268.933506617 +DBA/appsolworld/datafile/xcom_data.269.933506639 +DBA/appsolworld/datafile/xcom_indx.270.933506647 +DBA/appsolworld/datafile/xcom_lobs.271.933506659 +DBA/appsolworld/datafile/cw_data.272.933506675 NAME ——————————————————————————–

What is the /etc/resolv.conf file

cluvfy fails with PRVG-13602 : NTP daemon is not synchronized with any external time source on node "node1" Following is an example,where the ntp.conf is configured with Time Source Servers - $ cat /etc/ntp.conf driftfile /var/lib/ntp/drift restrict default kod nomodify notrap nopeer noquery restrict -6 default kod nomodify notrap nopeer noquery restrict 127.0.0.1 restrict -6 ::1 restrict 10.206.2.0 mask 255.255.255.0 nomodify notrap server ntp-server1 iburst dynamic server ntp-server2 iburst dynamic tos maxdist 30 includefile /etc/ntp/crypto/pw keys /etc/ntp/keys However,when the Time Source is checked using the below command - $ /usr/sbin/ntpq -p remote refid st t when poll reach delay offset jitter ============================================================================== +10.206.2.102 10.206.2.101 2 u 586 1024 377 1.898 -6.212 52.072 *10.206.2.101 .LOCL. 1 u 1044 1024 377 0.985 -2.890 63.651  Here,* denotes the current External Time Source.In this case,the Synchroniza

JSP Compilation in EBS R12.2

  JSP Compilation steps Step 1: Shutdown the application services Step 2: Take backup for the _Page(class file) folders $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> a $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> $ mkdir _pages $ ls -lrt To Implement the solution ===================== 1)Compile the JSP's. In Unix server: # perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 10 -log /tmp/ojspc_error.log 2) Cabo Images and style sheets can be corrupted or out of sync in the cabo caches, you may need to clear the files under cache directories after backup: $OA_HTML/cabo/images/cache $OA_HTML/cabo/styles/cache 3) Web Browser for Internet Explorer: - go to menu Tools => Internet Options, - select 'General' tab, - click on button 'Delete Files' in 'Temporary Internet files' area or - click on button 'Delete...' then in 'Delete Browsing History' pop-up window click on 'D

Usage of R12.2 EBS Application Services

  Group Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS AdminServer controls access to pages within WLS for system wide configuration Web Entry Point Services Oracle HTTP Server, Oracle Process Manager adapcctl.sh adopmnctl.sh FMW OHS (Apache) Service FMW Oracle Process Manager Notification Server (Controls Apache processes) Web Application Services oacore oafm forms forms-c4ws admanagedsrvctl.sh WLS Oracle E-Business Suite 12.2 Application Server for Self Service web based products transactions, Secure Enterprise Search (SES) and Web Service WLS Oracle E-Business Suite 12.2 Application Forms Server WLS Oracle E-Business Suite 12.2 Application Server utilized by WebService products using java API for Forms Batch Processing Services Concurrent Services adcmctl.sh Concurrent Managers Other Service

How to enable systemctl start oracleasm.service

Stop “oracleasm.service’, and re-enable it.   [root@shsdbdr01 by-path]# systemctl status oracleasm.service ● oracleasm.service - Load oracleasm Modules    Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)    Active: inactive (dead) [root@shsdbdr01 by-path]# systemctl stop oracleasm.service [root@shsdbdr01 by-path]# systemctl enable oracleasm.service [root@shsdbdr01 by-path]# systemctl start oracleasm.service [root@shsdbdr01 by-path]# systemctl status oracleasm.service ● oracleasm.service - Load oracleasm Modules    Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)    Active: active (exited) since Tue 2022-11-01 20:55:23 IST; 8s ago   Process: 28264 ExecStart=/usr/sbin/oracleasm.init start_sysctl (code=exited, status=0/SUCCESS)  Main PID: 28264 (code=exited, status=0/SUCCESS) Nov 01 20:55:21 shsdbdr01.appsol.com systemd[1]: Starting Load oracleasm Modules... Nov 01 20:55:22 shsdbdr01.appsol.com oraclea