Use PLSQL Developer to remotely log on to oracle, and web management to log on to PLSQL Developer only after installation, you can access the local oracle, but there are some problems in accessing the remote server oracle or the oracle of the Virtual Machine. First, I will describe the configuration steps as follows: 1. First, go to the oracle official website to renew (10 Gb below ): the instantclient-basic-win32-10.2.0.4.zip instantclient-odbc-win32-10.2.0.4.zip instantclient-sqlplus-win32-10.2.0.4.zip decompress all downloaded installation packages in the same directory, such as at d: \ sqlplus. 2. "Control Panel"-"System"-"advanced"-"environment variables"-"system variables" add several environment variables:
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK (or AMERICAN_AMERICA.ZHS16GBK) TNS_ADMIN = d: \ sqlplus LD_LIBRARY_PATH = d: \ sqlplus SQLPATH = d: \ sqlplus
Add d: \ sqlplus at the end of the Path variable 3. Create tnsname in the d: \ sqlplus directory. the ORA file is prone to problems. We recommend that you copy it directly to the machine where the oracle database is installed. The content is as follows:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_2\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.205)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
In the preceding file, ORCL is a connection identifier and can be modified by yourself. The HOST is the address of the remote Oracle Server, and the PORT is the service PORT of Oracle. If it has not been modified, the default value is 1521. Service_name is the name of the remote instance. 4. Switch to d: \ sqlplusunder the command line, run odbc_install.exe, and install the ODBC driver. 5. Use SQL-plus to connect
Run sqlplus/nolog under the command line to enter the sqlplus prompt, enter connect/@ <connection identifier> or conn system/manager@192.168.208.120: 1521/orcl or directly conn system/manager @ '(description = (address_list = (address = (proto = tcp) (host = 192.168.208.120) (port = 1521 ))) (connect_data = (service_name = orcl )))'
6. After the command line is passed, you can use PLSQL Developer to log on.
PLSQL Developer configure login username password database ip: Port/Instance name connect as: normal
Click OK.