Category: OCM 11g Preparation

In this topic we are not talking about grid or Oracle RAC yet, but this item is here. So, having proficiency in using the GI to manage a database (and we are still talking about standalone server) means to me "Oracle Restart". When installing grid infrastructure for a standalone, we get some utilities to set up and manage the …

Continue reading

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