Search This Blog

Total Pageviews

Wednesday, 18 May 2011

Oracle NetCA in silent mode

Oracle NetCA

oracle response file location

http://download.oracle.com/docs/html/B14399_01/app_nonint.htm

=================================================================
Enter a command similar to the following to run NetCA in silent mode:

$ $ORACLE_HOME/bin/netca /silent /responsefile=/local_dir/netca.rsp <<<<<<<<<-- worng in some of Oracle Doc remove "=" in this command

In this example:

* The /silent option indicates that you want to run NetCA in silent mode
* local_dir is the full path of the directory where you copied the netca.rsp response file template

================================================================

you will get this file "netca.rsp" in

oracle@apt-amd-02:~> cd database/ <<<<<<<<<< from Oracle software
oracle@apt-amd-02:~/database> ls -ltr
total 32
-rw-r--r-- 1 oracle oinstall 4835 2008-10-06 09:35 welcome.html
-rwxr-xr-x 1 oracle oinstall 3226 2008-10-06 09:35 runInstaller
drwxr-xr-x 14 oracle oinstall 4096 2008-10-06 09:57 stage
drwxr-xr-x 5 oracle oinstall 4096 2008-10-06 09:57 install
drwxr-xr-x 11 oracle oinstall 4096 2008-10-06 09:57 doc
-rw-r--r-- 1 oracle oinstall 123 2008-10-06 09:58 README
drwxr-xr-x 2 oracle oinstall 4096 2011-05-16 11:17 response

oracle@apt-amd-02:~/database> cd response/
oracle@apt-amd-02:~/database/response> ls -ltr
total 268
-rw-r--r-- 1 oracle oinstall 88279 2008-10-06 09:35 standard.rsp
-rw-r--r-- 1 oracle oinstall 5743 2008-10-06 09:35 netca.rsp
-rw-r--r-- 1 oracle oinstall 88298 2008-10-06 09:35 enterprise.rsp
-rw-r--r-- 1 oracle oinstall 48199 2008-10-06 09:35 dbca.rsp
-rw-r--r-- 1 oracle oinstall 26205 2008-10-06 09:35 custom.rsp


oracle@apt-amd-02:~/database/response> cp netca.rsp /opt/app/oracle/product/11.2/network/admin/

if you want to make a change in netca.rsp file take a backup of this file , and then change in netca.rsp file


from INSTALL_TYPE=""typical"" to ""custom""


#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom" <<<<<<<<<<<<<<<<-------------
INSTALL_TYPE=""custom""



my changed value are

oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> grep -i '=' /opt/app/oracle/product/11.2/network/admin/netca.rsp |grep -v '#'
RESPONSEFILE_VERSION="11.1"
CREATE_TYPE= "CUSTOM"
LOG_FILE=""/tmp/netca.log""
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""custom""
LISTENER_NUMBER=1
LISTENER_NAMES={"ANUJLISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""ANUJLISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE = {"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}



run this file like this


oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> /opt/app/oracle/product/11.2/bin/netca /silent /responsefile /opt/app/oracle/product/11.2/network/admin/netca.rsp

Wed May 18 08:07:13 GMT 2011 Oracle Net Configuration Assistant
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /opt/app/oracle/product/11.2/network/admin/netca.rsp
Parameter "log" = /tmp/netca.log
Done parsing command line arguments.
Oracle Net Services Configuration:
Configuring Listener:ANUJLISTENER
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/opt/app/oracle/product/11.2/bin/lsnrctl start ANUJLISTENER
Listener Control complete.
Listener started successfully.
Profile configuration complete.
Oracle Net Services configuration successful. The exit code is 0
oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> mv listener.ora listener.ora20110518^C
oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> ps -ef|grep LIST
oracle 26643 1 0 08:07 ? 00:00:00 /opt/app/oracle/product/11.2/bin/tnslsnr ANUJLISTENER -inherit
oracle 26652 24229 0 08:07 pts/16 00:00:00 grep LIST
oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> cat listener.ora
# listener.ora Network Configuration File: /opt/app/oracle/product/11.2/network/admin/listener.ora
# Generated by Oracle configuration tools.



this will start LISTENER with the name of ANUJLISTENER

oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> ps -ef|grep LIST
oracle 26643 1 0 08:07 ? 00:00:00 /opt/app/oracle/product/11.2/bin/tnslsnr ANUJLISTENER -inherit




final output of listener file

oracle@apt-amd-02:/opt/app/oracle/product/11.2/network/admin> cat listener.ora
# listener.ora Network Configuration File: /opt/app/oracle/product/11.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

ANUJLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = apt-amd-02.aptus.co.uk)(PORT = 1521))
)
)

ADR_BASE_ANUJLISTENER = /opt/app/oracle

1 comment:

Unknown said...

i want the netca to create and configure tnsnames. ora and sql.ora file as well.

if i want to completely automate oracle installation with dbcreation, listnercreation and tnsb=names. what is the correct order to run response files?

i had run oracle_installation.rsp. with oracle_home =/uo1/app/oracle/product/12.0.1/dbhome_1 then created a NON_CDB

ran oracle_installation.rsp. AGAIN with oracle_home =/uo1/app/oracle/product/12.0.1/dbhome_2 then created a CDB


THEN i ran netca.rsp.
BUT it it did not create tnsnames.ora and sqlnet

Canyou please help?

Oracle DBA

anuj blog Archive