Connect powerdesigner to a remote ORACLE database

I remember that I used powerdesigner to connect to the local Oracle database during my internship, But I installed the Oracle server on the local machine, therefore, the configuration of ODBC drivers and environment variables connecting to Oracle was very simple at that time. So naturally, there is no major problem when using the reverse engineering of powerdesigner and exporting its data model, and it is easy to configure it.

However, this time the Oracle server is not installed, but the Oracle client is installed, and then the Oracle database on the remote Unix server is accessed. Many problems have been encountered. I will share these questions and hope to help my friends who have encountered similar problems for your reference.

1. The installation is performed on the Oracle 10.2 client.

2. When you are finished, you are ready to configure the ODBC data source to connect to Oracle.

Start → programs → Oracle-OraDb10g_home1 → configuration and migration tools → Microsoft ODBC Administrator, select the system DSN tab and add oracle in your lient10g_home1.

Data Source Name: the name of the OCS data source.

TNS service name: OCs TNS service name. This is based on the tnsnames. ora C:/Oracle/ora90/Network/admin/configured in the earlier installation of the Oracle 9i client /)

Userid: ods30 remote database Login Name

 

After the password is entered for test connectionUnable to connect sqlstate = s1000 Error

ORA-12705: cannot access NLS data files or invalied environments specified

 

And

 

Unable to load the installation routine of the Oracle in oradb10g_home2 ODBC driver because of a system error code 998

(Add E:/Oracle/product/10.2.0/client_1/to the environment variable path /;)

 

Windows XP found on the InternetOracleAndODBC ConfigurationThe reason for the analysis is that the Oracle 10.2 client that has been installed previously has been installed with the Oracle9i thin client. When configuring ODBC, it cannot follow C:/Oracle/ora90/Network/admin/tnsnames. ora, but copy the configuration file tnsnames. oraE:/Oracle/product/10.2.0/client_1 in the installation directory of Oracle 10.2.

And modify the registry information: (reference link:Http://topic.csdn.net/u/20081106/13/df67a576-03eb-4aad-9e2a-d6e837e00d75.html)

For Windows, the/HKEY_LOCAL_MACHINE/software/Oracle search key nls_lang in the registry is created by installing the Oracle standard client with the value of Na. This caused a ORA-12705 error. The solution is to change na to simplified chinese_china.zhs16gbk.

 

 

Then test connection. Connection successful is displayed! OK,The ODBC data source is successfully configured.

 

3. After ODBC is configured, open the PD tool, configure the corresponding database connection, and generate the corresponding data model in reverse.

 

Open powerdesigner, database-> Configure connections. If the above configuration is successful, the corresponding data source will appear on the ODBC machine data sources tab.

Connect to the database, choose database-> connect, select ODBC machine data source, and select the configured OCs (Oracle in your lient 10g_home1) to ensure that the database login name and password are correct. The connection is normal.

 

Next, export the database table from the database to generate the corresponding data model in reverse direction: database-> reverse engineer database, select using a data source: OCs (Oracle in memory lient 10g_home1) you can generate the corresponding data model in the database.

 

If the unable to list users error occurs, it may be because the correct DBMS is not selected when the physical data model is created. The solution is

Database-> change current DBMS-> Oracle version 10g (the remote database version I connected here is Oracle 10g, and the corresponding OK is selected based on the database type and version I connected)