[Oracle] Pro * c link to oracle Database

[Oracle] Pro * c link oracle database 1 program Link oracle database:

    EXEC SQL CONNECT :DbUser IDENTIFIED BY :DbPasswd USING :DbServer;

 

DbServer is the definition of no IP address found in the UCRC file. How do I connect to a remote database? ---------------------------------------------------- The storage path of the tnsnames. ora file is $ ORACLE_HOME/network/admin. The following is an example:

　　OID.LOCALDOMAIN =　　(DESCRIPTION =　　 (ADDRESS_LIST =　　 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT =　　1521))　　 )　　 (CONNECT_DATA =　　 (SERVICE_NAME = oid)　　 )　　)　　CAMS.LOCALDOMAIN =　　(DESCRIPTION =　　 (ADDRESS_LIST =　　 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT =　　1521))　　 )　　 (CONNECT_DATA =　　 (SERVICE_NAME = cams)　　 )　　)　　INST1_HTTP.LOCALDOMAIN =　　(DESCRIPTION =　　 (ADDRESS_LIST =　　 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT =　　　　1521))　　 )　　 (CONNECT_DATA =　　 (SERVER = SHARED)　　 (SERVICE_NAME = MODOSE)　　 (divSENTATION = http://admin)　　 )　　 )　　EXTPROC_CONNECTION_DATA.LOCALDOMAIN =　　 (DESCRIPTION =　　 (ADDRESS_LIST =　　 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))　　 )　　 (CONNECT_DATA =　　 (SID = PLSExtProc1)　　 (divSENTATION = RO)　　 )　　 )

 

The tnsnames. ora file defines one or more network services. The network service corresponding to the net service cams instance is

　　CAMS.LOCALDOMAIN =　　(DESCRIPTION =　　 (ADDRESS_LIST =　　 (ADDRESS =　　 (PROTOCOL = TCP)　　 (HOST = localhost.localdomain)　　 (PORT = 1521))　　 )　　 (CONNECT_DATA =　　 (SERVICE_NAME = cams)　　 )　　)

 

Note that the ADDRESS item contains three sub-parameters: PROTOCOL: default protocol tcp host: ip address port: PORT. The default value is 1521 CAMS. LOCALDOMAIN is the data name. Make sure that there is a corresponding ADDRESS item in the listener file that also contains the same three sub-parameters and the sub-parameter values are equal. In addition, the value of SERVICE_NAME must be consistent the value of the SID_NAME parameter under the SID_DESC item in the listener file is equal.