May 2015 archive

Usually we create an entry in tnsnames.ora of our server when we want to connect remotely via sqlplus, do a tnsping, duplicate via rman, etc. What it you want to connect w/o set up a tnsnames.ora file? You can using a connection method called EZCONNECT (EZ=Easy). The syntax is pretty simple: CONNECT username@[//]host[:port][/service_name][:server][/instance_name] i.e: CONNECT …

Continue reading

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

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

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

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