As the data is read from the other party’s view, due to the confidentiality requirement of Party A, the listener.ora file said on the Internet cannot be modified. After checking the original URL = JDBC: Oracle: Thin: @10.22.1.99:1250: SSDB
The url to
JDBC: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (TCP) PROTOCOL = (HOST = 10.22.1.96) (1521) PORT =)) (CONNECT_DATA = (SERVICE_NAME = SSDB)))
or
JDBC: oracle: thin: the username/password @// 10.22.1.96:1521/instance name
The pro test will be successful.
Note the difference between oracle SID and service name selection here:
The error indicates that the SID is not found because the view provided by Party A is logged in as the service name and the configuration file is SID logged in.
The SID is internal and is a name for the instance to be used internally. The service name is external and is a database-level name that tells outsiders what the database is called.
The url to
JDBC: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (TCP) PROTOCOL = (HOST = 10.22.1.96) (1521) PORT =)) (CONNECT_DATA = (SERVICE_NAME = SSDB)))
or
JDBC: oracle: thin: the username/password @// 10.22.1.96:1521/instance name
The pro test will be successful.
Note the difference between oracle SID and service name selection here:
The error indicates that the SID is not found because the view provided by Party A is logged in as the service name and the configuration file is SID logged in.
The SID is internal and is a name for the instance to be used internally. The service name is external and is a database-level name that tells outsiders what the database is called.
Read More:
- [Solved] SpringBoot Integrating Oracle reports errors: ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Navicate premium Connecting to a remote Oracle，ORA-12514: TNS:listener does not currently know of service requested in c
- Oracle11gr2 database suddenly “TNS no listener” protocol adapter error
- Solve the problems of (deployment descriptor: project name) and (jax-ws web services) under the new eclipse project
- JDBC connection to Oracle: listener used the connection with the following error: ora-12505
- Oracle error – ora-12519, TNS:no appropriate service handler found
- “Permission denied” error in Oracle10g installation
- After Oracle 11g is installed, SQL_ Plus.exe The problem of Chinese garbled in command window
- Win7_ Dim-00019 appears after x64 installation of Oracle11g
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- Oracle 11g installation prompt ora-27102: out of memory
- The solution of PL / SQL can’t connect to the remote server after installing Oracle locally
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- Ngnix+gunicorn+Flag project deployment in Ubuntu
- AS3.5 Error gradle project sync failed.Basic functionality(e.g.editing,debugging) will not work
- 【Oracle】 ORA-00257: archiver error. Connect internal only, until freed
- Oracle Data Guard Ping [arc2]: heartbeat failed to connect to standby “. Error is 12514 fault analysis
- How to Fix “Oracle sp2-0640 unable to connect” Error
- Error:Failed to notify project evaluation listener.