May 13

OCM 11g Preparation – Configure the network environment to allow connections to multiple databases

You can run multiple listeners in the same server. Thus, it’s possible to: Have 1 listener pointing to multiple databases services. Have multiple listeners pointing to a single service. Have multiple listeners pointing to multiple services. By default, when you start a listener without a listener.ora, it will listen on 2 addresses: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Also, by …

Continue reading

May 13

OCM 11g Preparation – Manage Oracle network processes

Oracle network processes is basically “lsnrctl” command that runs in background the “tnslsnr” oracle binary. So what to know here? Type help inside lsnrctl prompt and check if you know all of them. If you miss any, go to the official documentation. The basic syntax (that I hope you know since your 1st fundamentals exam) …

Continue reading

May 12

OCM 11g Preparation – Set up network tracing

Set up network tracing is very important when some client complains “I’m having troubles when trying to connect in the DB and the application logs are inaccessible”. It’s also important for OCM if we need to find the RC of some network problem. So, how to enable it? Probably touching the network configuration files listener.ora …

Continue reading

May 11

OCM 11g Preparation – Configure the database instance to support shared server connections

It’s hard to find servers that use shared server option. Usually in my customers, the database is connected by a middleware that manage the client connections and only make a few connections to the database. Anyway, for OCM you may need to think in a DB that is accessed by 4k clients connections and only …

Continue reading

May 09

OCM 11g Preparation – Create and manage multiple network configuration files

You may think: I know how to create and manage network configuration files. I simply run netca or netmgr and setup my needs. And what if they ask you to set this up using no GUI ? So, doing it manually is not hard also. Personally, after many years of oracle experience I don’t know …

Continue reading