Up sqlplus lis_cysf/lis_cysf @ '(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(Host=10.69.1.88) (1521) Port=) (CONNECT_DATA=https://bbs.csdn.net/topics/(SID=orcl1)))'
The above statement can be normal use, return to normal,

Up sqlplus lis_cysf/[email protected]:1521: orcl1
Unable to use exceptions, ora - 12545
Connect to a database and use the program is abnormal, excuse me what reason?

CodePudding user response:

Up sqlplus lis_cysf/[email protected]:1521/orcl1


Written/is:

CodePudding user response:

The first writing, is a configuration of TNS, the second should not,

CodePudding user response:

To view the Oracle database sqlnet. Ora configuration;

You can refer to the following information:
https://www.2cto.com/database/201212/177654.html

Sqlnet configuration file location is in commonly: $ORACLE_HOME/network/admin directory

Commonly used parameter Settings
1. Set the Windows allows you to use Windows nt local certification
SQLNET. AUTHENTICATION_SERVICES=(NTS)

2. Set the Oracle client connection string name lookup order
NAMES. DIRECTORY_PATH=(tnsnames onames, ezconnect)

Allowed values are:
1. Use client tnsnames tnsnames. Ora parsing
2. Use the ldap directory access protocol parsing, it is necessary to have a directory service
3. Ezconnect or hostname, allows the use of TCP/IP connection string, contains the host name, port and service name
4. CDS distributed environment database name