Installing Oracle 10 Gb database on a Linux virtual machine now allows remote plsql access

Source: Internet
Author: User

I have installed the Oracle 10 Gb database on a Linux Virtual Machine. How can I access the remote plsql?

I have created an orcl instance. How can I connect the remote plsql to my instance? Use TCP to configure the TNSNAMES. ORA file to support remote connection to the directory database. Oracle Net can be used on the client

Configuration Assistant or oracle Net Manager graphical Configuration tool can be directly edited in a text editor.

Add the configuration of a local Net server as follows:

XIAODON = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = xiaodon) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xiaodon )))

PROTOCOL: the PROTOCOL for communications between the client and the server, which is generally TCP.

HOST: The name or IP address of the machine on which the database listens.

PORT: Specifies the PORT on which the database listens. You can view the listener. ora file on the server or the host on which the database listens.

Run the lnsrctl status [listener name] command at the command prompt. The Port value must be under investigation with the Database Listener.

The listening port is the same.

SERVICE_NAME: on the server side, run the "sqlplus> show parameter service_name" command after logging on to the system.

The upstairs is the ORACLE settings.

The network settings of key VMWARE should be correct.

Simply set the briage mode. <

1. VMWARE hosts can ping lan hosts. In this way, the system is installed successfully.

2. The ORACLE Data is normally installed on the VMWARE Host. do know how to test it-you can enter the database through the connection string.

3. After step 3 is feasible, after TNSNAMES is configured on the LAN machine, it is necessary to connect to the VMWARE Host. <

I also encountered the same problem, but I am using the host method.

Related Article

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.