Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

Oracle network service response file

Oracle Tips by George Goodfire

August 6, 2015


Question: I want a script to create a Network Service. I was told it can be done only by using a Response File. Is a response file also a script that can be executed after the DBCA scripts? Where can I find the available commands so I can produce a response file for a network service?

Answer: (By George Goodfire) provides this solution to create a network service response file as per this forum thread. Scenario took place on Oracle 11.2g on Windows 7

Oracle Configuration GUI Tools, Like "Oracle Universal Installer" ( OUI ), "Database Configuration Assistant" ( DBCA ) and "Network Configuration Assistant" ( NETCA ) may be called from a shell without showing any Graphic User Interface by typing the /silent command. You will have to provide all parameters - that you would otherwise input on the GUI - through a response file. A response file - has extension ".rsp" - is just a text file containing all the required parameters in the syntax required by the Oracle tool. For a complete list of all possible parameters of a response file in every tool, you can refer to the example Response Files found either in the Oracle Documentation, or inside your oracle_home at the path ORACLE_HOME\inventory\response\

On the OUI and DBCA scenario you might also pass the parameters inline as arguments, but this is not possible for the NETCA scenario - despite the commands resemblance. Thus when calling NETCA /silent you can provide the parameters only through a response file.

The full command syntax for netca is as follows

>netca /silent /responsefile /C:\yourpath\filename.rsp

On a typical NetService we would configure Protocol,Host,Port, DatabaseName, and the Name of the service itself to identify it.
For the above Scenario the final Response file will look like this:
QUOTE
[oracle.net.ca]
INSTALL_TYPE=""custom""
NAMING_METHODS={"TNSNAMES"}
NSN_NUMBER=1
NSN_NAMES={"DBNAME"}
NSN_SERVICE = {"TEST2"}
NSN_PROTOCOLS={"TCP;PCNAME;1521"}

Be very carefull with the syntax. For instance even if you miss double quotes on ""custom"" netca will fail.

Additional Attention to NetService Setup

netca -silent doesn't test if netservice works. It just adds the text to the tnsnames ora. Short say, input him any fake value it will exit successfully. netca will exit fatally only after following conditions
1. Cant find the response file or tnsnames.ora
2. Syntax of Parameters inside response file are wrong

Thus to ensure that the created Network Service works correctly, you have to make the test yourself afterward e.g. with the connect-disconnect sqlplus command " sqlplus -l " giving the netservice connect parameter you just created.

> sqlplus -l system/password@YourNewNetServiceName

Additional Info for newbies
netca is actually a batch file calling several "components" like java. Its located in the \bin folder of your Oracle Installation Directory - both Client and Server. This fullpath of netca, is included in the Windows PATH environment variable. So when you enter netca it will search-find it there and execute it.

Attention : If you have the Path of the Server Directory before the Client's Path, the Server's netca will be executed instead.

Creating a response file dynamically

With its RSP file demand, the NETCA /silent command isn't dynamic like DBCA or OUI inline parameters but you could create a shell script which creates dynamically the response file with your specific parameters, on the same directory, calls netca, and then deletes it. Something like this example windows batch script below.

The below script its just a minimal implementation as an example. A more Advanced script can be created with dynamic logging routines with date/time, throwing exception codes, auto setting localhost-1521 if not defined, adding also more operations like DBCA.
::Example call command>C:\path\AutoNetcaScratch.bat dbname password nsName LOCALHOST 1521
SET DB_NAME=%1
SET GPSWD=%2
SET NSNAME=%3
SET HOSTNAME=%4
SET PORT=%5
SET RSP_FULLPATH=%~dp0NAME_RSP_PREFIX%NSNAME%_%HOSTNAME%_%DB_NAME%_%PORT%.rsp
SET NL=^& ECHO.
:CREATE_RSP
ECHO [oracle.net.ca]> %RSP_FULLPATH%
ECHO %NL%INSTALL_TYPE=""custom"">> %RSP_FULLPATH%
ECHO %NL%NAMING_METHODS={"TNSNAMES"}>> %RSP_FULLPATH%
ECHO %NL%NSN_NUMBER=1 >> %RSP_FULLPATH%
ECHO %NL%NSN_NAMES={"%NSNAME%"}>> %RSP_FULLPATH%
ECHO %NL%NSN_SERVICE = {"%DB_NAME%"}>> %RSP_FULLPATH%
ECHO %NL%NSN_PROTOCOLS={"TCP;%HOSTNAME%;%PORT%"}>> %RSP_FULLPATH%
:CREATE_NETWORK_SERVICE
CALL netca /silent /responsefile /%RSP_FULLPATH%
:TEST_CONNECTION
ECHO EXIT sql.sqlcode; | sqlplus -l -s system@%NSNAME%/%GPSWD%
:DELETE_RSP
DEL %RSP_FULLPATH%



   
Oracle Training from Don Burleson 

The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Oracle training
 
 


 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster