Updating tnsnames ora

6854933580_2c8b688306_z

The default for the Solaris 2.6 Operating System is 32768 bytes.Usage Setting this parameter in the connect descriptor for a client overrides the RECV_BUF_SIZE parameter at the client-side Note: Additional protocols might support this parameter on certain operating systems.Default Note: Additional protocols might support this parameter on certain operating systems.Refer to operating-system specific documentation for information about additional protocols that support this parameter. Default The default value for this parameter is operating-system specific.

A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect.

Therefore, the file requires an entry for the Primavera Data Warehouse schema in order to make this connection.

See https://docs.oracle.com/database/121/NETRF/tnsnames.htm#NETRF007 for details on the file.

If you make configuration changes on the server ($ORACLE_HOME/network/admin/tnsnames.ora) ensure you can connect to the database through the listener if you are logged on to the server.

If you make configuration changes on the client (c:\oracle\product.1.0\db_1\network\admin\tnsnames.ora) ensure you can connect from your client workstation to the database through the listener running on the server. ORA file with an editor and plug in the required settings. Note the file is usually found in the ORACLE HOME/network/admin/ directory or %USERPROFILE%/App Data/Oracle with Windows 7.

Each connect descriptor can contain one or more protocol addresses.

You must have an account to comment. Please register or login here!