Where is my tnsnames.ora in an Oracle Fusion Middleware 11g environment?

Today a really short, but I hope useful blog post :-) I got regulary the question from customers and/or colleagues "Where is my tnsnames.ora?". I can really understand this question, as the directory structure and layout for an Oracle Fusion Middleware 11g environment is slightly different from the directory structure of the previous Oracle Application Server 10g environment. The answer is really simple on where to find the tnsnames.ora in an Oracle Fusion Middleware 11g environment: just go to $MW_HOME/<InstanceName>/config here you will...

Read More

The new sports - Plagiarism

Some time ago I saw in Tim Hall's Blog a post that his complete site has been stolen (My whole website stolen again…) and republished under another name. Now it also hits me, not the whole site was copied, at the moment only one complete article of me (Oracle Internet Directory Light for tnsnames Resolution - Dirk ...) Seems that Plagiarism is the new sport :-) The article were re-published under the site BLOG.ABIGOLD.FR with a One-To-One copy,...

Read More

Switching Oracle HTTP Server to Port 80

If you are using the Oracle Webtier 11g (11.1.1.2.0 / 11.1.1.3.0 / 11.1.1.4.0) in your projects and specially the Oracle HTTP Server, you face normally the problem, that the Oracle HTTP Server is configured with a Listen Port of 7777 or something like this. But endusers dont like to remember always the Port number of the Oracle HTTP Server, so the goal is to reconfigure the Oracle HTTP Server. Under a UNIX operating system you have to consider one...

Read More

My Oracle ACE Trophy arrived

Today I received a small package with a warning label "Please handle with care - Glass", inside was my Oracle ACE Trophy :-) Looks cool on my desk ...

Read More

Why you should check the default grants to PUBLIC

Today something Oracle Database Security related: Why you should have a look on the default grants to PUBLIC in an Oracle Database. Just a small showcase: One Application Schema APP_USER which owns some tables One Application related Role APP_READ to which grant select on APP_USER.<TABLENAME> were given One Enduser named EVIL :-) which got create session and hold the APP_READ role One Enduser named FRIENDLY :-) which got create session and hold the APP_READ role -- First lets create the Application Schema APP_USER create user APP_USER identified...

Read More