Oracle Grid installation: fails with “Oracle Restart stack is not act fails during execution for an Oracle Grid Infrastructure 11.2 installation with following messages . “Oracle Grid installation: 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/’. [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/ $ORACLE_HOME/rdbms/lib/ […]

dbms_lock.sleep must be declared error ( Packages Invalid ) solution

Hello, n the Oracle PL/SQL, I want to test the sleep function. I am using PHM_DEV schema. but it gives me error : dbms_lock.sleep must be declared error Schema name : PHM_DEV Cause :The Oracle schema  does not have access to the DBMS_LOCK package. solutions : connect to database ass sysdba grant execute on SYS.DBMS_LOCK to schema_name; […]

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( at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( at at at com.evermind.util.ReleasableResourcePooledExecutor$ 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 – 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 – 64bit Production With the Partitioning, […]

ORA-01555 Error

Hello, how much is the tablepace size ? Connect to sqlplus from your terminal than run this sql commands. SELECT d.undo_size/(1024*1024) as UNDO_SIZE, SUBSTR(e.value,1,25) as UNDO_RETENTION, ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) as OPTIMUM_UNDO_RETENTION FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = ‘UNDO’ AND c.status = ‘ONLINE’ AND […]

ORA-39142: incompatible version number in dmp file

I am getting th ORA-39142 error while using an export (expdp) from import into an database:   Why does the import (impdp) give me this ORA-39142 error and how to I overcome the ORA-39142 error? Export Scripts : expdp \”/ as sysdba\” DIRECTORY= DATA_PUMP_DIR DUMPFILE=expdp_full_%u.dmp LOGFILE=expdp_full.log FULL=Y  parallel=8 Error Messages : ORA-39001: invalid […]

ORA-01940: cannot drop a user that is currently connected

Recently when i was trying to drop one of the schema then the drop command was failing with below error: SQL> drop user expDbfm cascade; drop user expDbfm cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected The Error message itself is very clear the the user is connected […]