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.