How to use DOS command line to connect to oracle database in WINDOWS system

This article shows you how to use the DOS command line to connect to the oracle database in the WINDOWS system, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

DOS command line connects to oracle database

Suppose you have an Oracle database with the following information:

IP:192.168.0.1

SID:orcl

Port number: 1521

User name: testuser

Password: 123456

The service name configured in the local client is: server1

1. Connect to the database through the service name

Sqlplus userName/userPassword@netServiceName

Example: sqlplus testuser/123456@server1

2. Connect to the database through IP:

Sqlplus userName/userPassword@//IP:port/SID

Example: sqlplus testuser/123456@//192.168.0.1:1521/orcl

After entering the command, the message in the yellow part of the following figure appears, indicating that the database is connected.

Oracle service operation

Start the service

Net start oracleservicebinbo

Turn on the listener

Lsnrctl start

Shut down the server

Net stop oracleservicebinbo

Turn off the listener

Lsnrctl stop

The above is how to use the DOS command line to connect to the oracle database in the WINDOWS system. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.