AWR Report on the Oracle Database

Hello, to get awr report : connect to oracle db as sysdba percula40: / home / oracle # sqlplus / as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Tue Mar 27 13:44:46 2018 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With […]

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

Add UNDO tablespace autoextend tips

Hello,   I need to alter by UNDO tablespace tpo make it autoextend on.  How do I change my UNDO tablespace to allow for autoextend? Show Undo Tablespace in Oracle Database scripts ; CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ […]

DBMS_SESSION.CLOSE_DATABASE_LINK

Hello, The CLOSE_DATABASE_LINK procedure is used to close an open but inactive database link in the session. Determining Which Links Are in the Database The following views show the database links that have been defined at the local database and stored in the data dictionary: DBA_DB_LINKS Lists all database links in the database. ALL_DB_LINKS Lists […]

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