Recently, when using PowerDesigner to connect remote Oracle for reverse engineering, there have been a number of problems that are common, mostly due to configuration
Description
(1) Remote database version Q oracle11g 64bit
(2) Local simultaneous installation:
ORACLE11G Client 32bit
oracle11g 64bit
(3) Native installation PowerDesigner 15.2
(3) Pre-preparation:
Direct copy of ORACLE server%oracle_home%\network\admin\tnsnames.ora file
To the ORACLE client%oracle_client%\network\admin\ directory
Problem:
Issue One, Ora-12560:tns: Protocol Adapter error
Issue two, Ora-12557:tns: protocol Adapter not loadable
Question three, Ora-12504:tns listener program in Connect-data not get service-name
Reference articles
http://coffeehot.iteye.com/blog/2151955
Http://blog.sina.com.cn/s/blog_677d8b260100w0vg.html
http://worms.blog.51cto.com/969144/1293265
http://quentinxu.iteye.com/blog/1988107
Http://www.xuebuyuan.com/1026765.html
Problems and processing summaries for each step when using PowerDesigner to connect remote Oracle for reverse engineering:
Question one:
Initiating a reverse engineering connection to a remote Oracle database to report the first error
ORA-12560:TNS: Protocol Adapter error
The problem is confirmed that the Oracle server is installed locally and the Oracle client
and the local Path environment variable is written to both the Oracle server and the Oracle client's Bin directory,
I handle this as the local Oracle server-side Bin directory string in the PATH environment variable, preserving only the bin directory path string for the local Oracle client.
Note:
The methods included in the reference links above are
(1) The bin directory of the client that removes the PATH environment variable,
(2) Switch the local Oracle server-side Bin directory path string in the PATH environment variable to the local Oracle client's Bin directory path string before
(3) Setting Oracle_sid
I did not succeed after trying the above methods
Question two:
After completing the above configuration processing, reverse engineer to connect to remote Oracle, another error is reported
Ora-12557:tns: Protocol adapter is not loadable
See http://blog.sina.com.cn/s/blog_677d8b260100w0vg.html.
The process steps are
(1) Execute the following command to register the Oracle client's Oracle OLE driver, such as the native directory as follows
regsvr32 E:\app32\Administrator\product\11.2.0\dbhome_1\BIN\OraOLEDB11.dll
This completes the registration,
Note:
Since this involves only powerdesigner connecting Oracle for reverse engineering, the operation on Plsql is not within the scope of processing.
Question three:
Complete the above two issues, re-execute PowerDesigner reverse engineering, connect to remote Oracle, continue to error
Ora-12504:tns listener not getting service-name in Connect-data
This issue can be confirmed as a configuration issue for the client%oracle_client%\network\admin\ directory Tnsnames.ora file
The following are examples of configurations
localhost =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
orcl.16.56.232 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.56.232) (PORT = 1521))
)
(Connect_data =
(service_name = orcl.16.56.232)
)
)
General description: I configured localhost to connect to the local Oracle server
and 172.16.56.232 that connect to the remote Oracle server
Summarize:
1. If you have a similar problem, first check that the Oracle service starts correctly
2, the Client environment variable configuration is correct (refer to the contents of the text)
3. When the server and the client are installed, the configuration is especially important.
Oracle_ Protocol Adapter Error _ protocol adapter not loaded _tns listener is not available in Connect-data Service-name