Oracle Concept Network Service name and sid

Source: Internet
Author: User

The Oracle Concept Network Service name and sid SID are the unique identifier of the database. SERVICENAME is the name of the network service and can be set at will. It is equivalent to the alias of a database instance and can be remembered and accessed for example: if oracle 10 Gb is installed on machine A, how can I log on to machine B with SQLPlus? A: When the Oracle client is installed on machine B, use Net Configuration Assistant to configure a local service name. You can also use tnsnames. configure NETWORKSERVICE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.254.10) (PORT = 1521) in ora) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) // SID) then input sqlplus username/password @ NETWORKSERVICE in cmd, for example: use expdb to export the database expdp ubssdic/ubssdic @ networkservice directory = expdp DUMPFILE = dumpfile. dmp FULL = y LOGFILE = logger. if the system variable set ORACLE_SID = orcl is configured on the Oracle server, you can export expdp ubssdic/ubssdic DIRECTORY = expdp DUMPFILE = dumpfile without using the network service name on the Oracle server. dmp FULL = y LOGFILE = logger. log

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.