Custom Oracle connection string

You can define a custom Oracle connection string. This connection string can be used for connecting to an Oracle RAC cluster, or for other purposes.

To define a custom ORACLE connection string, edit the $NCHOME/etc/precision/DbLogins.Domain.cfg configuration file, and configure the insert within the file to include an m_ConnectionString field so that the insert looks something like this:

insert into config.dbserver
(
    m_DbId,   
    m_Server,
    m_DbName,
    m_Schema,
    m_Hostname,
    m_Username,
    m_Password,
    m_PortNum,
    m_ConnectionString,
    m_EncryptedPwd,
    m_OracleService
)
values
(   
    "NCIM", 
    "oracle",
    "ORATEST",
    "ncim", 
    "server1.location1.acme.com",
    "ncim",
    "ncim",   
    1521,
    "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.location1.acme.com3)
(PORT=1521))(CONNECT_DATA=(SID=ORATEST)))",   
    0,
    1
);

By using the m_ConnectionString attribute in this way you effectively replace the values of m_DbName, m_Hostname and m_PortNum. You must still provide these values; however, they will be overridden by the value specified in the attribute m_ConnectionString when connecting to the database.