Every patch is different from another, so there is no rule for applying a patch. You need to read the doc before! Don't simply do an "apply patch" w/o reading it before (I just underline it because I know some people that like to read it after, when things are already messed up)! So for this …

Continue reading

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