Mithilesh Jambhulkar ORACLE dba

OVERVIEW :                You can use Exadata to consolidate your storage environment Using Exadata multiple  databases can use storage from a single pool. Exadata uses Oracle Automatic Storage Management (ASM) to evenly distribute the storage load for every database across every available disk in the storage pool. Every database can use all the available disks to maximize performance. Exadata requires the use of Oracle Database 11g Release 2. Exadata works equally well with single-instance or Oracle Real Application Clusters (RAC) databases. Users and database administrators use the same tools and knowledge they are already familiar with. Being based on industry-standard components and technologies, Exadata is inexpensive to deploy. In addition, tight integration with the full suite of Oracle Database high-availability features, ensures that the reliability and integrity needs of mission-critical environ...

                                 Upgrading from Oracle 9i to  Oracle Database 11g

ERROR --1  SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled SOLUTIUON:: alter system set "_no_recovery_through_resetlogs"=TRUE scope=both; System altered. SQL>  shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size                  2232640 bytes Variable Size            1140854464 bytes Database Buffers         2046820352 bytes Redo Buffers               16928768 bytes Database mounted. SQL> alter database open resetlogs; Database altered. ERROR  IN CASE OF FULL DB RESTORATION ON  STANDBY WE ARE GETTING  RMAN RESTORE end...

ORACLE_GRID_INSTALLATION FOR STANDALONE SERVER server ip = 10.65.127.37 LINUX Step 1: Download Oracle Software for grid 12c Download and unzip the software Step 2: check Memory, Swap & kernel [root@localhost ~]# grep MemTotal /proc/meminfo MemTotal: 2075468 kB Memory Min : 1.5 GB need. [root@localhost ~]# grep SwapTotal /proc/meminfo SwapTotal: 4128760 kB [root@localhost ~]# df -h /tmp Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 21G 4.4G 15G 23% / [root@localhost ~]# gedit /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.rmem_max=4194304 net.core.wmem_default=1048576 net.core.wmem_max=1048576 [root@localhost ~]#/sbin/sysctl -p [root@localhost ~]...

Difference between Syntax and Runtime errors in PL/SQL?? Explain what is COMMIT, ROLLBACK and SAVEPOINT?? How many types of Triggers are there in PL/SQL and what are they? How to generate Debugging Information in PL/SQL? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented? Name any 5 PL/SQL exception types What are the two different types of Exceptions in PL/SQL? What is IN parameter and OUT parameter in PLSQL? What is Public and Private Procedures in PL/SQL? What is Referential Integrity? What is SQLCODE and SQLERRM in PL/SQL? What is the difference between CASE and DECODE? What is the difference between VARCHAR and VARCHAR2 in PL/SQL? What is %TYPE and %ROWTYPE in PL/SQL?? What is the disadvantage of using %ROWTYPE in PL/SQL? What are the advantages of using %TYPE and $ROWTYPE in PL/SQL? List all different types of Data Types in PL/SQL? What is the difference between Views and Materialized Views in Oracle? What is difference bet...

run  { crosscheck archivelog all; delete noprompt expireD archivelog all; }         col current_scn form 999999999999999999 col TIMESTAMP_TO_SCN form 9999999999999999 col NOW10G form 99999999999999999999 col NOW9I form 99999999999999999999 col SCN form 99999999999999999999 col TIMESTAMP form 99999999999999999999                           **************FOR  SQL PLAN *************** select * from table(dbms_xplan.display_awr('&sql_id')); col begin_interval_time for a30 break on plan_hash_value on startup_time skip 1 select ss.snap_id, ss.instance_number node, begin_interval_time, s.sql_id, s.plan_hash_value, nvl(executions_delta,0) execs, (elapsed_time_delta/decode(nvl(executions_delta,0),0,1,executions_delta))/1000000 avg_etime, (buffer_gets_delta/decode(nvl(buffer_gets_delta,0),0,1,executions_delta)) avg_lio, (rows_processed_delta/decode(nvl...