Learn Database Concepts

Recently I have installed a client on a local machine and I was trying to connect the database. I know I have everything right but still I was getting this error. C:\Users\localhost>tnsping orcl TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 19-NOV-2 014 15:22:45 Copyright (c) 1997, 2010, Oracle.  All rights reserved. Used parameter files: C:\app\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora TNS-03505: Failed to resolve name C:\Users\localhost>   I went back to check the Tnsnames.ora file to see if there is anything wrong in it. But no luck I couldn't find anything.     Sample Tnsnames.ora on my machine.     orcl =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )     (CONNECT_DATA =       (SID = orcl)     )   )     Wondered what c...

Oracle AUDIT Explained Enabling Auditing in Database #1 You can specify DB,EXTENDED in either of the following ways: ALTER SYSTEM SET AUDIT_TRAIL=DB, EXTENDED SCOPE=SPFILE; ALTER SYSTEM SET AUDIT_TRAIL='DB','EXTENDED' SCOPE=SPFILE; However, do not enclose DB, EXTENDED in quotes, for example: ALTER SYSTEM SET AUDIT_TRAIL='DB, EXTENDED' SCOPE=SPFILE; OS Directs all audit records to an operating system file. #2 Directs audit records to the database audit trail (the SYS.AUD$ table), except for mandatory  and SYS audit records, which are always written to the operating system audit trail #3 The operating system and database audit trails both capture many of the same types of actions. Operating System Audit Record Equivalent DBA_AUDIT_TRAIL View Column SESSIONID                                  ...

Today I encountered a problem while importing a scehma into my local database. I have exported a schema from ORCL (lets say) using expdp command. I tried to import it to another database and I was getting this error.   ORA-31633: unable to create master table [oracle@orcl dpump]$ impdp sam/oracle directory=DPUMP dumpfile=abc_2014_11_14.dmp logfile=abc_imp.log schemas=sam1,sam2 Import: Release 11.2.0.4.0 - Production on Fri Nov 14 13:59:56 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-31626: job does not exist ORA-31633: unable to create master table "SAM.SYS_IMPORT_FULL_05" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1038 ORA-01031: insufficient privileges I tried again and again same error. The...