Today we are going to have look at the database security’s phase. In this phase, we are going to have look at Purging AUDIT TRAIL RECORDS The parameterAUDIT_TRAIL_TYPE is specified using one of three constants. DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD: Standard audit trail (AUD$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD: Fine-grained audit trail (FGA_LOG$). DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD: Both standard and fine-grained audit trails. If you want […]
Today we are going to have look at some more interesting facts about “Oracle Technology”. This post about is the “ASM Instance and Database Instance”. Being an Oracle DBA our Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]
Issue Using opatch auto to apply patch 18706472, it failed with error code 135: opatchauto2017-09-23_04-21-57.log shows:
2017-09-23 04:24:41: s_run_as_user2: Running /bin/su oracle -c ' /oracle/product/11.2.0/db/OPatch/opatch napply /software_dump/latestpatch/18706472/18522509 -local -silent -ocmrf /home/grid/responsefile/file.rsp -oh /oracle/product/11.2.0/db -invPtrLoc /oracle/product/11.2.0/db/oraInst.loc '
2017-09-23 04:24:42: Removing file /tmp/filexagz0g
2017-09-23 04:24:42: Successfully removed file: /tmp/filexagz0g
2014-09-23 04:24:42: /bin/su exited with rc=135
2017-09-23 04:24:42: status of apply patch is 34560
2017-09-23 04:24:42: The apply patch output is Oracle Interim Patch Installer version 126.96.36.199.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Argument(s) Error... Given 'ocmrf' file does not exists.
Please check the arguments and try again.
OPatch failed with error code 135
[oracle@racnode1 ~]$ ls -l /home/grid/responsefile/file.rsp
ls: cannot access /home/grid/responsefile/file.rsp: Permission denied
[grid@racnode1 ~]$ ls -l /home |grep grid
drwx------ 20 grid oinstall 4096 Sep 1 10:46 agrid
Solution Either open the permission of /home/grid path to be 755, eg:
$ chmod 755 /home/grid
The permission looks like:
drwxr-xr-x 20 grid oinstall 4096 Sep 1 10:46 grid
Or create a response file under a directory accessible by both grid user and oracle user, for example: […]
After a long time, I am going to write a theoretical topic which adds some different knowledge in our DBA career. I hope it will help our viewers to have deep knowledge about the database. Today I am going to explain about benchmarking in the database. Being a part of IT we have little idea about […]
SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, […]
Uninstalling SQLT removes the SQLT repository and all SQLTXPLAIN/SQLTXADMIN schema objects. SQLTXPLAIN and SQLTXADMIN users also gets dropped. To uninstall SQLT simply execute sqlt/install/sqdrop.sql connected as SYS.
[oracle@localhost ~]$ cd /home/oracle/sqlt/install
[oracle@localhost install]$ sqlplus / as sysdba
SQL*Plus: Release 188.8.131.52.0 Production on Wed Feb 14 04:31:10 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
SQL> START sqdrop.sql
... uninstalling SQLT, please wait
SQDOLD completed. Ignore errors from this script
SQDOBJ completed. Ignore errors from this script
2 my_count INTEGER;
5 SELECT COUNT(*)
6 INTO my_count
7 FROM sys.dba_users
8 WHERE username = 'TRCADMIN';
10 IF my_count = 0 THEN
12 EXECUTE IMMEDIATE 'DROP PROCEDURE sys.sqlt$_trca$_dir_set';
14 WHEN OTHERS THEN
15 DBMS_OUTPUT.PUT_LINE('Cannot drop procedure sys.sqlt$_trca$_dir_set. '||SQLERRM);
18 FOR i IN (SELECT directory_name
19 FROM sys.dba_directories
20 WHERE directory_name IN ('SQLT$UDUMP', 'SQLT$BDUMP', 'SQLT$STAGE', 'TRCA$INPUT1', 'TRCA$INPUT2', 'TRCA$STAGE'))
23 EXECUTE IMMEDIATE 'DROP DIRECTORY '||i.directory_name;
24 DBMS_OUTPUT.PUT_LINE('Dropped directory '||i.directory_name||'.');
26 WHEN OTHERS THEN
27 DBMS_OUTPUT.PUT_LINE('Cannot drop directory '||i.directory_name||'. '||SQLERRM);
29 END LOOP;
30 END IF;
Dropped directory TRCA$INPUT2.
Dropped directory TRCA$INPUT1.
Dropped directory SQLT$BDUMP.
Dropped directory SQLT$UDUMP.
Dropped directory TRCA$STAGE.
Dropped directory SQLT$STAGE.
PL/SQL procedure successfully completed.
SQL> WHENEVER SQLERROR CONTINUE;
SQL> PAU About to DROP users &&tool_repository_schema. and &&tool_administer_schema.. Press RETURN to continue.
About to DROP users SQLTXPLAIN and SQLTXADMIN. Press RETURN to continue.
SQL> DROP USER &&tool_administer_schema. CASCADE;
old 1: DROP USER &&tool_administer_schema. CASCADE
new 1: DROP USER SQLTXADMIN CASCADE
SQL> DROP USER &&tool_repository_schema. CASCADE;
old 1: DROP USER &&tool_repository_schema. CASCADE
new 1: DROP USER SQLTXPLAIN CASCADE
SQL> DROP ROLE &&role_name.;
old 1: DROP ROLE &&role_name.
new 1: DROP ROLE SQLT_USER_ROLE
SQL> SET ECHO OFF;
Disconnected from Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production
Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]
The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]
Database Design is the most important part of the IT project. This is the second post regarding Database Design. Normally we just think about software and some basic terms of hardware while we think about the database. Now let’s have deep look at Hardware Requirements. This post explains the technical terms which must keep in mind […]
As we know all that in the world of technology we have to fill ups user and password name multiple times . We must know what is actually happens while we enter incorrect password. First few lines give some basic idea about the Authentication. Authentication is a process in which the credentials provided are compared to those […]
Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]