Posts

Adding Mount Point Details in Database for report

-
1) Create a Directory in database mkdir directory 2) Give permission to Directory chmod 775 directory/ Sqlplus / as sysdba create or replace directory exec_dir as '/home/oracle/checks/directory'; Create a Table in Database: CREATE TABLE df  ( "FILESYSTEM" VARCHAR2(100),    "BLOCKS" NUMBER, "USED" NUMBER,  "AVAILABLE" NUMBER, "CAPACITY" VARCHAR2(10),    "MOUNT" VARCHAR2(100) ) ORGANIZATION external (   TYPE oracle_loader DEFAULT DIRECTORY exec_dir ACCESS PARAMETERS    ( RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII preprocessor  exec_dir:'run_df.sh' READSIZE 1048576 SKIP 1 FIELDS TERMINATED BY WHITESPACE LDRTRIM      REJECT ROWS WITH ALL NULL FIELDS ( "FILESYSTEM" CHAR(255) TERMINATED BY WHITESPACE,       "BLOCKS" CHAR(255) TERMINATED BY WHITESPACE, "USED" CHAR(255)
Post a Comment
Read more

Simple Steps to Enable Extended Auditing in Oracle

-
Image
Enabling auditing in db sqlplus / as sysdba ALTER SYSTEM SET audit_trail=db,extended SCOPE=SPFILE; shutdown immediate startup table for audit trails DBA_AUDIT_TRAIL view the size of audit select round(bytes/1024/1024/1024) from dba_segments where segment_name ='AUD$'; see the current tablespace of audit table select tablespace_name from dba_tables where table_name='AUD$'; Audit notes Master Note For Oracle Database Auditing (Doc ID 1299033.1) To audit a specific schema AUDIT ALL STATEMENTS BY <username> ; Moving $AUD table from SYSTEM TS to a dedicated Table Space If your AUD$ table is in SYSTEM and SYSTEM tablespace, Then it is advised to move the AUD$to a dedicated tablespace. Use steps to move AUD$. select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 from dba_segments where segment_name='AUD$'; OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/1024/1024 ------- ------------- ------------ --------
1 comment
Read more

RMAN backup Status (Remaining Time and Percentage)

-
On Running a huge database backup we often need to know the status of backup. 1) How much backup is taken. 2) How much is remain. 3) Estimate time to complete the backup. After lot of search i find out this amazing query below. col dbsize_mbytes for 99,999,990.00 justify right head "DBSIZE_MB" col input_mbytes for 99,999,990.00 justify right head "READ_MB" col output_mbytes for 99,999,990.00 justify right head "WRITTEN_MB" col output_device_type for a10 justify left head "DEVICE" col complete for 990.00 justify right head "COMPLETE %" col compression for 990.00 justify right head "COMPRESS|% ORIG" col est_complete for a20 head "ESTIMATED COMPLETION" col recid for 9999999 head "ID" select recid , output_device_type , dbsize_mbytes , input_bytes/1024/1024 input_mbytes , output_bytes/1024/1
1 comment
Read more

Finding Package running behind a concurrent request

-
Image
Finding Package running behind a concurrent request SystemAdministrator>concurrent>Program>define>Search Search for the concurrent request Ok Copy Executable name Systemadministrator>concurrnet>Program>Executable Enter <F11> Paste in executable field Enter <Ctrl+F11> Executable File Name is the name of Package Regards Soban Ali
1 comment
Read more

RMAN-03002: failure of recover command at 07/18/2011 18:12:11 RMAN-06094: datafile 1 must be restored

-
RMAN> report schema; RMAN> catalog start with 'target datafiles path'; RMAN> list copy of database; RMAN> switch database to copy; RMAN> report schema; reference: RMAN-06094 or RMAN-06571 During Recovery or Switch to Copy at Standby Site (Doc ID 1339439.1)                            
Post a Comment
Read more

Checking Database connection from a weblogic server using DBPING utility.

-
DBPING UTIITY IN WEBLOGIC THE DBPING COMMAND-LINE UTILITY TESTS THE CONNECTION BETWEEN A DBMS AND YOUR CLIENT MACHINE VIA A JDBC DRIVER. Ensure you have set weblogic.jar in the classpath and have JAVA_HOME set properly before executing the dbping command. 1)export PATH=/jdk150_11/bin:$PATH 2)export CLASSPATH=$CLASSPATH: /Weblogic/utils/bea101/wlserver_10.0/server/lib/weblogic.jar Follow the synatax available on utils.dbping $ java utils.dbping DBMS [-d dynamicSections ] user password DB $ java utils.dbping ORACLE_THIN USERNAME PASSWORD IP:PORT/SID Ex: java -cp /WebLogic/utils/bea815/weblogic81/server/lib/weblogic.jar utils.dbping ORACLE_THIN KrishnaDB KrishnaPWD KrishnaDBServer:1536/KrishnaDB Note: The telnet command and the ping might give as success but that is *NOT* the correct way to check the connectivity to database from WebLogic servers. Examples The following is an example using the Oracle Thin Driver. C:\>java utils.dbping ORACLE_THIN scott
Post a Comment
Read more

Oracle WebLogic Server (WLS) 12cR2 (12.2.1.3.0) Installation on Oracle Linux 5 and 6

-
Image
Oracle WebLogic Server (WLS) 12cR2 (12.2.1.3.0) Installation on Oracle Linux 5 and 6 This article presents a brief overview of installing Oracle WebLogic Server (WLS) 12cR1 (12.2.1.3.0) on Oracle Linux 5 and 6. Assumptions Download Software Setup Installation Create Domain Post-Installation Assumptions This article assumes you have an existing server (real or virtual) with either Oracle Linux 5.x or 6.x installed on it. For instruction on how to do this check out the following articles. Oracle Linux 5 (OL5) Installation : I did the basic installation with no extra package groups for this installation. Oracle Linux 6 (OL6) Installation : I picked the "Desktop" option for this installation, so I would have a graphical interface without having to select separate package groups. Everything in the installation will be 64-bit. Software Download the Weblogic Server 12c software from Oracle Technology Network . Java Development Kit (I us
Post a Comment
Read more