Oracle Database Security Assessment Sample Report

Highly Confidential Assessment Date & Time Date of Data CollectionDate of ReportReporter VersionSun Apr 25 2021 00:12:00Sun Apr 25 2021 00:22:012.2.1 (May 2020) - f3a1 Database Identity NameContainer (Type:ID)PlatformDatabase RoleLog ModeCreatedORCLCDBPDB1 (PDB:4)Linux x86 64-bitPRIMARYNOARCHIVELOGMon Jan 13 2020 20:12:00 Summary SectionPassEvaluateAdvisoryLowRiskMediumRiskHighRiskTotalFindingsBasic Information0000011User Accounts70222013Privileges and Roles156100022Authorization Control0020002Fine-Grained Access Control0050005Auditing08500013Encryption0110002Database Configuration92010113Network Configuration0110103Operating System2200105Total33201734279 Basic Information Database Version Oracle … Continue reading Oracle Database Security Assessment Sample Report

Installing SH Sample Schema

Preparation: Before running the installation script (sh_main.sql), please edit the following two files:sh_main.sql & sh_olp_c.sqlunder D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema\sales_history and replace "__SUB__CWD__" with "D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema" or the directory where you extracted the sample schema scripts. Here is a live demo about installation: https://www.youtube.com/watch?v=ZRodqYAUxtk ThanksAhmed

ORA-03113 when running a specific query

I got a question from one of my clients that he has a query that he used to run it successfully on Oracle Database 10g,but when he run the same query on Oracle Database 12.1.0.1, the query failed and the connection dropped with the following errors: He confirmed many times that the same query with … Continue reading ORA-03113 when running a specific query

When to use SET DBID in RMAN?

According to oracle documentation:Specify a database's database identifier (DBID) when restoring a control file or server parameter file. Restrictions and Usage Notes for the SET DBID Command You should only run the SET DBID command in the following specialized circumstances: You are not connected to a recovery catalog and want to restore the control file … Continue reading When to use SET DBID in RMAN?

Oracle RMAN Multi-Section Feature

RMAN can optionally break up large files into sections and back up and restore these sections independently. This feature is built into RMAN. You can use it by creating multisection backups, which break up the files generated for the backup set into separate files. This can be done for backup sets and image copies. Each … Continue reading Oracle RMAN Multi-Section Feature

Change “Value” Column Width for “show parameter” in sqlplus

If you tried to increase the width of the "VALUE" column, nothing changed: I found that the NAME & Value columns have special names (for type column , it is normal): column NAME_COL_PLUS_SHOW_PARAM format A20column VALUE_COL_PLUS_SHOW_PARAM format A80 Now, it is fine.

TNS-04012: Unable to start Oracle Connection Manager instance.

Background: One advantage of the "Connection Manager" is that it can act as if a proxy server between the database client and the database server, especially when there is a firewall between the client and the server.I installed Oracle Client 19c (only the "Connection Manager" and the "Oracle Net Listener" components): https://www.youtube.com/watch?v=R-tSVkRckfs Then I configured … Continue reading TNS-04012: Unable to start Oracle Connection Manager instance.