Hacking Password

SQL> connect dbauser/dbapassword@mydatabase


Connected.

SQL> select username,password from dba_users where username = 'TESTUSER';


USERNAME PASSWORD
---------- ------------------

TESTUSER AEB6397C8E7598A7


SQL> alter user TESTUSER identified by temppwd1;
User altered.
SQL> connect testuser/temppwd1@mydatabase
Connected.
SQL> --do some work as testuser
SQL> connect dbauser/dbapassword@mydatabase
Connected.

SQL> alter user TESTUSER identified by values 'AEB6397C8E7598A7';

GENERAR DDL TABLE & INDICES X SQL

Listing A:
set heading off;
 set echo off;
 Set pages 999;
 set long 90000;
 
spool ddl_list.sql
 select dbms_metadata.get_ddl('TABLE','EMPLOYEES','HR') from dual; 
 select dbms_metadata.get_ddl('INDEX','EMP_MANAGER_IX','HR') from dual;

 select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual; 
 spool off;
The output is shown below.

Listing C:
set pagesize 0

 set long 90000

 set feedback off

 set echo off
 spool scott_schema.sql
 connect scott/tiger;
 SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM USER_TABLES u;
 SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
     FROM USER_INDEXES u;
 spool off;


SQL> set long 1000000
SQL> select dbms_metadata.get_ddl('INDEX','ADDR_FK1') from dual;


Here is the output:
DBMS_METADATA.GET_DDL('INDEX','ADDR_FK1')
--------------------------------------------------------------------------------

CREATE INDEX "MV_MAINT"."ADDR_FK1" ON

"MV_MAINT"."ADDRESS" ("CUST_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255

COMPUTE STATISTICS STORAGE(INITIAL 1048576

NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0

RDA ORACLE

Oracle Remote Diagnostic Agent (RDA)

Version 10.2

Download From Metalink Description Metalink Doc ID Contents RDA 4.x FAQ and Index 314422.1 RDA Frequently Asked Questions RDA for RAC Clusters 359395.1 Instructions and download for RAC   Step 1: Unzip Files Unix Windows tar -xvf rda.tar or tar -cxvf rda.gz use any Windows utility Step 2: Read Instructions Unix Windows README_Unix.txt README_Windows.txt Step 3: Verify Installation Unix Windows rda.sh -cv rda.cmd -cv   Step 4: Run Setup Unix Windows rda.sh -S or rda.pl -S rda -S The script continues on for many more pages of questions as part of the configuration Step 5: Run RDA Unix Windows rda.sh -v or rda.pl -v rda -v   To view RDA Open RDA_INDEX.htm from the RDA output directory

VERSION DE JAVA

lrwxrwxrwx   1 root     root          15 Jan 22  2015 /usr/java -> jdk/jdk1.7.0_60
oracle@USBLDDB1010:~$ java -version
java version "1.7.0_60"
Java(TM) SE Runtime Environment (build 1.7.0_60-b19)
Java HotSpot(TM) Server VM (build 24.60-b09, mixed mode)
oracle@USBLDDB1010:~$

VER TRACE ENABLE

SQL_TRACE in v$session will tell you for active 10053 or 10045 trace are enabled or not :

SQL_TRACE     VARCHAR2(8)     Indicates whether SQL tracing is enabled (ENABLED) or disabled (DISABLED)