Oracle Database Import

Using power of Oracle Data Pump If you haven’t used oracle Data Pump and still using old IMP / EXP, it’s time for change. It’s very simple to use and at least 10 times faster (my experience) than IMP/EXP. Simple steps to configure 1. CREATE OR REPLACE DIRECTORY EXPIMP AS ‘{path}’; 2. GRANT READ, WRITE […]

Show Oracle DB Name and SID name

Hello To find the current DB_NAME and ORACLE_SID: Query the views v$database and v$thread. V$DATABASE gives DB_NAME V$THREAD gives ORACLE_SID If ORACLE_SID = DB_SID and db_name = DBNAME: To find the current value of ORACLE_SID: SVRMGR> select instance from v$thread; INSTANCE —————- DB_SID To find the current value of DB_NAME: SVRMGR> select name from v$database; […]

change Oracle user account status from EXPIRE to OPEN

Hello, Any way to change the Oracle user account status from expire  to open without resetting the password? Solutions: select spare4 from sys.user$ where name='[user name]’; select password from dba_users where username = ‘[user name]’; then : Then use this to reset it: alter user [user name] identified by values ‘[result from above query] Example: […]

ORA-14400: inserted partition key does not map to any partition

Hello in this chapter we are soluting a partition error. Problem descriptions : com.evermind.server.rmi.OrionRemoteException: java.lang.RuntimeException: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition ORA-06512: at “TMS.PCK_SLA”, line 1766 ORA-06512: at line 1 at com.evermind.server.ejb.EJBUtils.getUserException(EJBUtils.java:296) at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla(DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.java:1717) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:124) at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at […]

Oracle database Import ORA-39001: invalid argument value ORA-39000: bad dump file specification

hello, I was trying to import dump file to my test oracle database using the following import line: Import: Release 11.2.0.4.0 – Production on Wed jan 10 10:52:34 2018 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, […]

Oracle Database Listener.log Analize

Hello, We are creating a new listener log file from listener.log file. ErmanTESTDB:/oracle/grid/diag/tnslsnr/ErmanTESTDB/listener/trace#cp listener.log a_listener.log   1. create a new directory for listener.log file. create directory erman_log_dir as ‘/oracle/grid/diag/tnslsnr/alioth/listener/trace’; 2. create a new table for listener.log file create table erman_log ( log_date date, connect_string varchar2(300), protocol_info varchar2(300), action varchar2(15), service_name varchar2(15), return_code number(10) ) organization […]

Oracle Database Listener.log File Location

Hello, I am just getting my feet wet with 11gR1. When I executed lsnrctl status, I get the following: Connect to terminal with Oracle user than run this command: {ermanTestDB:oracle}/home/oracle/>lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 08-JAN-2018 10:59:28 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of […]

Oracle Database Export

Hello,Step by step Oracle database export Schema, Tables, Procedure, Full Database etc. For the examples to work we must first unlock the SYS account and create a directory object it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file […]