Updating tnsnames

Put this parameter under the = (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=...) (CONNECT_DATA= (SERVICE_NAME=generic) (RDB_DATABASE=[.mf]mf_personal.rdb) (GLOBAL_NAME=alpha5)) (TYPE_OF_SERVICE=rdb_database)) (DESCRIPTION= (ADDRESS=...) (CONNECT_DATA= (SERVICE_NAME=example.com)) (TYPE_OF_SERVICE=oracle11_database))) net_service_name= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=example.com))) = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=example.com)) (SECURITY= (SSL_SERVER_CERT_DN="cn=sales,cn=Oracle Context,dc=us,dc=acme,dc=com"))) of the database server.Usage Notes The client uses this information to obtain the list of DNs it expects for each of the servers, enforcing the database server DN to match its service name.

updating tnsnames-31

Multiple connect descriptors are characterized by the DESCRIPTION_LIST parameter. file specifies the protocol addresses of the listener.Put this parameter under either the Purpose To specify the type of service to use for an Oracle Rdb database.Usage Notes This parameter should only be used if the application supports both an Oracle Rdb and Oracle database service, and you want the application to load balance between the two.Very importantly, the IP address (or hostname) for the database server itself must be included in the TCP. INVITED_NODES.[[email protected] admin]$ cat # Network Configuration File: /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora# Generated by Oracle configuration tools. A net service name is an alias mapped to a database network address contained in a connect descriptor.

821

Leave a Reply