Disable and Enable trace event on a particular Database - Oralce

Disable trace event on dbname database.

SQL> select * from v$instance;

SQL> show parameter event

NAME                                 TYPE

------------------------------------ --------------------------------

VALUE

------------------------------

event                                string

xml_db_events                        string

enable

SQL> set serveroutput on

DECLARE

lev BINARY_INTEGER;

BEGIN

dbms_system.read_ev(10795, lev);

dbms_output.put_line(lev);

END;

/

SQL>   2    3    4    5    6    7  0

PL/SQL procedure successfully completed.

SQL>

Enable Trace Event:

SQL> select * from v$instance;

SQL> alter system set event="10795 trace name context forever, level 2" scope=spfile;

System altered.

SQL> shut immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1.3366E+11 bytes
Fixed Size 2198192 bytes
Variable Size 1.9327E+10 bytes
Database Buffers 1.1382E+11 bytes
Redo Buffers 512286720 bytes
Database mounted.
Database opened.

show parameter event

SQL> SQL>

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
event string
10795 trace name context forev
er, level 2
xml_db_events string
enable

How to check the Database and Listener is Running in Oracle

Checking of the started the database and listener.

PROD:e2dsavctigdev01:/u01/app/oracle> ps -ef|grep pmon

  oracle 1462     1   0 03:15:03 ?           0:00 ora_pmon_instancename

  oracle 1499 14219   0 03:16:40 pts/1       0:00 grep pmon

PROD:e2dsavctigdev01:/u01/app/oracle> ps -ef|grep tns

  oracle 1500 1421   0 02:16:43 pts/1       0:00 grep tns

  oracle 1486     1  0 02:15:48 ?           0:00 /u01/app/oracle/product/11.2.0.4/db_1/bin/tnslsnr LISTENER -inherit

Find Invalid Objects in Oralce

SQL> select count(*) from dba_objects where status='INVALID';


select owner, object_name, object_type from dba_objects where status = 'INVALID' order by 1,2,3;

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------ -------------------
FLEETAUTN            AD_BATCH_PKG                   PACKAGE BODY
SYSMAN               UPDATE_SOURCE                  TRIGGER
SYSMAN               WEBAPP_UPGRADE                 PACKAGE
SYSMAN               WEBAPP_UPGRADE_JOB             PACKAGE


======