MyNotes

Let we discuss how to check the tablespace creation time in Oracle 11g? *By using this query we will get the tablespace name, status and creation time   SQL> col FILE_NAME for a45 SQL> col tablespace_name for a10 SQL> col status for a15 SQL> col creation_time for a15 SQL> set lines 999 pages 100 SQL> select a.File_name,a.Tablespace_name,a.status,b.creation_time from dba_data_files a inner join V$datafile b on a.file_name=b.Name group by a.File_name, a.Tablespace_name,a.status,b.creation_time ; FILE_NAME TABLESPACE STATUS CREATION_TIME --------------------------------------------- ---------- --------------- --------------- C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF SYSTEM AVAILABLE 27-AUG-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF USERS AVAILABLE 27-AUG-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF UNDOTBS1 AVAILABLE 27-AUG-17 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SAM01.DBF...

let we discuss how to find Log switches in Database with Details of oracle11g Note: V$LOG_HISTORY displays log history information from the control file. Method-1: I am going to take log switches count till before the month end (i.e current date is '27-Sep-17' using last_day function  it consider the date is '30-Sep-2017') SQL> col c1 for a10 heading "Month" SQL> col c2 for a25 heading "ArchiveDate" SQL> col c3 for 999 heading "Switches" SQL> SQL> col c1 for a10 heading "Month" SQL> col c2 for a25 heading "ArchiveDate" SQL> col c3 for 999 heading "Switches" SQL> select to_char(trunc(first_time),'Month') c1, to_char(trunc(first_time),'DAY:DD-MM-YY') c2, count(*) c3 from V$log_history where first_time > last_day(trunc (sysdate) - 30)+1 group by trunc(first_time) order by trunc(first_time); Month ArchiveDate Switches ---------- ---------------...

Let us we discuss How to monitor our data pump jobs in oracle11g? *Datapump jobs are monitor into few views maintained within the Oracle instance(Datapump is running) *These views are DBA_DATAPUMP_JOBS, DBA_DATAPUMP_SESSIONS, and V$SESSION_LOGOPS. https://ampersandacademy.com/tutorials/oracle-admin-2/how-to-monitor-data-pump-jobs

1.Let us we discuss what is purpose we have to learn Oracle RAC11g? *Before we are discussing what is OracleRAC and what are the benefits of RAC we will the life cycle of " OracleDba " has shown in the pic below *The most people are reading this blog the who is already oracle dba or they are trying to become an oracle dbathe person who is started his career at Linux administrator or he had a good knowledge of Linux than he stepped into oracle dba (most of them knows what is oracle dba and what they are doing we are not discussing about entire thing but we will focus outline ) *It classified into two types 1)physical dba 2)Logical dba for more details https://ampersandacademy.com/tutorials/oracle-rac-11g/why-we-need-to-learn-oracle-rac11g

How to Create additional database in Oracle Express edition or How to create manual database in windows   *In my windows i have installed oracle11g express edition i want to create new database for my testing purpose but the express edition doesnot support DBCA utiltiy let us we can discuss How to Create additional database in Oracle Express edition or How to create manual database in oracle11g windows enivornment. https://ampersandacademy.com/tutorials/oracle-admin-2/create-additional-database-oracle-express-edition--create-manual-database

Today i am tired to export  one schema (hr) from the one database  into another database  ( import schema ) so i created one directory which is called "ram" grant read and write access to  the system user ,then i started export the schema (hr) from production  while i did the export of hr schema the job was successful after that i did import schema like below expdp : C:\>expdp system/oracle directory=ram schemas=hr dumpfile=hr.dmp logfile=hr.log ...... ...... Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:   C:\datapump\HR.DMP Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 13:23:40 impdp: C:\>impdp system/oracle directory=ram remap_schema=hr:scott dumpfile=HR.DMP logfile=hr.log it through an error like below . ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31619: invalid dump file "C:\datapump\hr.dmp" ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failu...

 While i am installing the oracle 11g database i got the popup message " Error in starting the service.The service OracleMTSRecoveryService was not found " i just ignored the message and continue my installing but the installation was successful with errors, so once again i started the installation this time also i got the same error pop up and  searched on google to resolve this issue by using below steps S-1: S-2: press " Ctrl + r " then type " regedit " you 'll got this screen and  then choose " HKEY_LOCAL_MACHINE "   S-3:  Then choose " SYSTEM "  => " ControlSet001 " => " Services " => " OracleMTSRecoveryService "       S-4:                 After   choosing the " OracleMTSRecovery " we can see the " imagepath " which was mentioned below Double click the image and change the path where we are going to install the software(like be...

*Let us we discuss oracle 12c architecture and explanation before you must have the knowledge on Oracle 11g architecture if you have good knowledge on the oracle 11g architecture it's easy to understand 12c *Before that 12c Multiple databases reside on single server and single database contains multiple schemas apart from RAC each Oracle database had single instance, but in 12c it supports Many databases to one instance   What is multitenant Architecture? *The Multiple tenants share the same source of a mutual benefit for different purposes at a very broad level like the same applies to Oracle database which means multiple databases can share a single database instance resources for different purposes on the same server. *The Oracle 12c which is built on mulitenant foundation is called container database (CDB) and each container (CDB) resides inside is called pluggable database https://ampersandacademy.com/tutorials/oracle-12c