Current location - Quotes Website - Collection of slogans - How to view the port number of oracle database?
How to view the port number of oracle database?
View method:

Information to be input in direct connection mode: user name, password and service name (these three points are the same as those in client mode). IP, port number.

There is a place to pay attention to here. Generally, the port number is 152 1, but if you change the port number when installing Oracle, you need to check the port number on the Oracle server. You can read the information of the database through the tnsnames.ora file.

You can see something similar to the following:

HOST= is the host address (if it is a written host name, you can check the IP address corresponding to the host name in the /etc/hosts file).

POST= is the open port of the database.

Oracle system is a database management system based on Oracle relational database for data storage and management. ? Oracle, the world's first commercial database supporting SQL language, is located in high-end workstations and small computers as servers, such as IBM P series servers, HP Integraty servers and Sun? Fire server. Oracle's entire product line includes database servers, enterprise business application suites, application development and decision support tools.