Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act

root.sh fails during execution for an Oracle Grid Infrastructure 11.2 installation with following messages . “Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act” Step 1: Clead up the ASM Disks Once you attempt an installation, your ASM disks are marked as being used, so they can no longer be used as […]

Oracle 12C Error in invoking target links makefile Eror Message on linux 7.x

Hi Everyone. If you are installing DB version 12.1.0.* there are some problems. Oracle 12c (12.1.0.*) installs cleanly. Database version : 12.1.0.* Operating Systems Version : Oracle Linux 7.x You will see the following error. <pre> [oracle@erman02]’/u01/app/oracle/product/12.1.0.2/db_1/precomp/lib/ins_precomp.mk’. [oracle@erman02]’/u01/app/oraInventory/logs/installActions2017-06-05_06-07-04PM.log’ </pre> for details. To fix it, do the following: <pre> [oracle@erman02] rm -rf $ORACLE_HOME/lib/stubs/* [oracle@erman02]cp $ORACLE_HOME/rdbms/lib/env_rdbms.mk $ORACLE_HOME/rdbms/lib/env_rdbms.mk.orig […]

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; […]

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 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 […]

Oracle Trace file (.trc) or Trace map (.trm) cleanup

To clean up old Oracle trace file (.trc) and trace map (.trm) files, use this command on UNIX based system: Connect sqlplus :   And, find /u01/app/oracle/diag/rdbms/sbuat01/SBUAT01/trace/*.trc -mtime +14 -exec rm {} \; find /oracle/diag/rdbms/ssekdb/ssekdb/trace/*.trm -mtime +14 -exec rm {} \; The above command will delete trace files and trace map files which is older […]

Oracle 12C Error in invoking target links makefile Eror Message on linux 7.x

Hi Everyone. If you are installing DB version 12.1.0.* there are some problems. Oracle 12c (12.1.0.*) installs cleanly. Database version : 12.1.0.* Operating Systems Version : Oracle Linux 7.x You will see the following error. [code language=”css”] [oracle@erman02]’/u01/app/oracle/product/12.1.0.2/db_1/precomp/lib/ins_precomp.mk’. See [oracle@erman02]’/u01/app/oraInventory/logs/installActions2017-06-05_06-07-04PM.log’ for details. [/code] To fix it, do the following: [code language=”css”] [oracle@erman02] rm -rf $ORACLE_HOME/lib/stubs/* […]