Remotely Connect Oracle Services

Remote Service side
Operating system: Windows Server 2003 Enterprise Edition SP2
Oracle version: Oracle 9.2.0.1.0 official edition

Local client
Operating system: Windows Server 2003 Enterprise Edition SP2
Oracle version: Oracle 9.2.0.1.0 full version (client)

Remote server Configuration
1. Database Configuration
Because you want to provide data services to external clients, be sure to configure the database operating mode to Shared service mode. I just made this mistake. The operation mode is configured as a "Dedicated server Mode", which leads to remote clients not being able to connect properly.
If you are unsure of the operating mode of the database, you can configure the Configure database in database option on the Oracle Configuration Assistant tool.
If you create a new database, you must not forget to configure the database operating mode to Shared service mode.

2. Database Services
Determine that the database service is started.
Method: Type "services.msc" at the command line
Locate your database service in the Windows Services window (typically named in the form of the Oracleservice DB instance name) to see if it is a "started" state, or start the service.

3. Listening programs
Make sure that the database is already attached to the listener and that the listener is enabled.
Method: Type "Lsnrctl" at the command line
Type the "Services listener name" in the Lsnrctl console window

If summary information appears, the listener is started

If the word "no listener" appears, the listener is not started
Type "Start listener name" in the Lsnrctl console window to start the listener
You can also type "services.msc" at the command line
Locate your listener service in the Windows Services window (typically named as the Oracleorahome92tnslistener listener name, the default listener service named "Oracleorahome92tnslistener"). Check to see if the status is started, otherwise start the service.

4. Network Status
Determine the port that the listener is using to be included in the firewall allowed column.

Local Client Configuration
1. Test the connection
Method: Type "tnsping server IP Address" below the command line
If the word "OK (xx milliseconds)" appears, you can establish a connection with the server. Otherwise, check the server configuration.

2. Add a service Name
Method: Open Oracle Database Configuration Assistant tool, "Local NET service name Configuration", "Add", select Oracle databases or services (according to the personal server settings to choose the appropriate, my is 8 I or later version:) Input service name (the global database name entered when the library is built), TCP-and host name Input server IP address, port input service-side listener listening Port------------the first test may fail, Because the default username password does not necessarily match the server, click Change Login to enter a valid user name and password to determine if the "test succeeded", the connection is successful, click Next, enter the local service name---until completed.

Remotely Connect Oracle Services