netca | SnapDBA

Creating an Oracle 11g Database using DBCA (non-ASM)

Posted on May 19, 2013 by Garth

In this example, I’ve already installed the Oracle Database 11gR2 software (11.2.0.4 in this example) on one of my Linux 6.4 machines, and I’m going to create a new database instance simply called ’emrep’ (as it’s going to be used for my EM12c database repository) using the DBCA tool. The data files will be stored under

Creating an Oracle Listener using NETCA

Posted on March 19, 2013 by Garth

In this example, I’m creating a simple Oracle Listener service called ‘LISTENER’ using the default port of 1521. Start the Oracle Net Configuration Assistant (NETCA) Open an X-Windows session to the server as the ‘oracle’ user. Set your ORACLE_HOME environment variable appropriately, then start the assistant by running the following: export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3 $ORACLE_HOME/bin/netca Once the GUI