Security Message

On generic Linux OS we’re able to add some stuff in file “/etc/motd” in order to give you a security WARNING or a FUNNY logo. Of course you can read my this post to find out something. Then in Oracle how could I archive the same effect when logging on to the command line window of SQL*Plus? After reading David Fitzjarrell‘s article “Setting A Logon Security Message In Oracle” I know the answer.

David mentioned a parameter “SEC_USER_AUDIT_ACTION_BANNER” which has been added in file “sqlnet.ora” that is located in the “$ORACLE_HOME/network/admin” directory on his post. Next I search that parameter on Oracle Docs and have understood it has existed from version 11g and later. The following 2 screenshots can also indicate it.

Get DDL of an Oracle DPV

As well known as there have major two views which are both SDDV and DPV on Oracle Database Reference of 11.2,  perhaps you once remembered that my previous note have mentioned how to get DDL of an Oracle SDDV hence next this note I’ll introduce how to get DDL of an Oracle DPV.

Get DDL of an Oracle SDDV

A couple of days ago I glanced at Oracle 11.2 Database Reference from official documentations.

As you can see from the previous picture Part II introduces the Static Data Dictionary Views (SDDV) of Oracle and Part III lists all of the Dynamic Performance Views (DPV). Let me give an example if you want to see/know some basic info of SDDV “DBA_TEMP_FREE_SPACE” and you solely find the following this picture from the manual.

Steven Feuerstein help me better understand exception handle in ORACLE PL/SQL block

You know, Steven Feuerstein is as well known as the Oracle PL/SQL guru around (all over) the world. Particularly following him to learn PL/SQL should be the most efficient method and the fastest road. I eventually found he published a series of PL/SQL 101 articles from 2011 to 2013 on Oracle Magazine. In order to quickly searching and finding out those pretty nice articles from Oracle official website I have sufficient reasons to attach the following some screenshots that are arranged in order.

OGB Appreciaiton Day : The Oracle Community

A couple of days ago I noticed Tim Hall‘s this blog post – OGB Appreciation Day 2019 (#ThanksOGB) from LinkedIn. Actually last year I knew Tim had organised this similar event (2016, 2017 and 2018) because the updating frequence of his blog post is much more high. In addition this year I’ve honored to become an Oracle ACE Associate hence I have more than a thousand of reasons to say proudly “Thanks Oracle Community, and thanks Oracle GroundBreakers“.

As you know Oracle Community includes a series of communication platform and learning resources. Such as, AskTOM, ODC and etc.

I benefit a lot from ODC and AskTOM, here I just list some stuff learning from Oracle Community this year.

• Why is it different for the query result of my two SQL?
• ORA-00933: SQL command not properly ended
• How to query App machines’ IP by log.xml on SQL*Plus?
• How to output character strings with blank space using prompt on SQL*Plus?
• ORA-01427: single-row subquery returns more than one row
• ORA-01756: quoted string not properly terminated
• ORA-01775: looping chain of synonyms
• Showing 4 number of compilation errors when running my procedure
• Warning: Procedure created with compilation errors – PLS-00103

• How to analyse or dig log.xml of Oracle Listener Log with XMLTABLE?

Four Approaches about Digging IP Address Connecting to Oracle Database Server

A couple of days ago my customer asked me a question – whether he could find out all of IP Addresses even connecting to an Oracle Database Server on Production System. With his question whom I once researched/studied for a while.

Hence today’s note I’ll try my best to introduce total 4 approaches about digging IP Address connecting to Oracle Database Server. Of course every approach has its own advantage and disadvantage, which all depends on how you treat and distinguish them.

Actually to classify these 4 number of methods means to divide them into two kinds (types) of forms. They’re as follows,

• Checking oracle dynamic performance view “v$session”;
• Exploring oracle listener log file “log.xml”;

Among the previous two types of forms every form has also been divided into two number of specific stuff. You can see the following bullet list,

• v$session
  • creating an oracle trigger on SYS schema
  • creating an oracle function on SYS schema
• log.xml
  • writing a Linux SHELL script on ORACLE user of OS
  • writing an Oracle SQL script on ORACLE user of OS

Let me start to respectively introduce them.

WordPress (itself)’s issue or bug?

From time to time I’ve written my blog post and note on WordPress so far there has approximately two years.

On the while (overall) wordpress is very friendly and convenient for writing and publishing some articles for me because my oracle guys and buddies have been using it all the time. They’re Jonathan Lewis, Connor McDonald, Richard Foote, David Fitzjarrell, Stew Ashton, Mohamed Houri and so on (here I can’t all list them).