About Us

Welcome to my notes DBA,

This page shares the knowledge of Oracle and PostgreSQL DBA related stuff for beginners easy to learn concepts.

Popular posts from this blog

ORA-39000, ORA-39143 ORA- 31619 invalid dump file in datapump

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...
Read more

Error in starting the service (OracleMTSRecovery)

Image
 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...
Read more

How to check tablespace creation time in oracle 11g

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...
Read more