Managing an oracle instance

Let check these link for Managing an oracle Instances 
http://ampersandacademy.com/tutorials/managing-oracle-instance-oracle11g/

           

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

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

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