Oracle remote database connection Configuration

Oracle remote database connection configuration introduction Oracle Database remote connection can be achieved through a variety of methods, this article we mainly introduce four remote connection methods and precautions, and through examples to illustrate, next we will begin to introduce. First case: www.2cto.com if the oracle server is installed on the local machine, it will not be said, the connection is just a problem of the user name and password. However, check whether the environment variable % ORACLE_HOME %/network/admin/is set. Case 2: the oracle server is not installed or the oracle client is not installed. However, pl SQL development, toad SQL development, SQL navigator, and other database management tools are installed. An oracle server is installed on a virtual machine or another computer, that is, a virtual machine or another computer. In this case, I use pl SQL development to remotely connect to the ORACLE server database as an example: 1. Search for the following files on the machine where the oracle server is installed: oci. dllocijdbc10.dllociw32. dllorannzsbb10.dlloraocci10. dlloraociei10.dllsqlnet. oratnsnames. oraclasses12.jarojdbc14. jar copies these files to a folder, such as publish lient, and copies them to the client machine. For example, the placement path is D: clientlient. 2. Configure tnsnames. ora and modify the database connection string. Oracledata = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = oracledata) where, oracledata is the service name to be connected; HOST = 192.168.0.58 is the Server IP address; PORT = 1521 is the PORT number. 3. Add the first environment variable named TNS_ADMIN with the value tnsnames. path of the ora file (for example, D: Connector lient, especially after reinstallation or other operations, if you forget the TNS_ADMIN variable, the connection identifier cannot be parsed when you log on to plsql ), this is to find the tnsnames mentioned above. ora. This step is the most important. Add the second environment variable (optional): "NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK". (AMERICAN_AMERICA.US7ASCII is of the ASCII encoding type. For other types, go to the server and check it online) (This step is correct for the time being. If the encoding is incorrect, garbled characters are generated ). 4. download and install the pl SQL Developer configuration application: Open pl SQL Developer, click Cancel on the logon page, and choose tools> preferences> connection: Oracle Home = D: oracleclient OCI library = D: oracleclientoci. dll 5. If you enable plsql again, you can log on to the database by entering the username and password with the oracledata option. Case 3: ORACLE server is not installed on the local machine, but the oracle client is installed, and database management tools such as pl SQL development, toad SQL development, and SQL navigator are installed. An oracle server is installed on a virtual machine or another computer, that is, a virtual machine or another computer. In this case, I use pl SQL development to remotely connect to the oracle server database as an example: 1. Open the net manager in the oracle client and configure the Database Name and IP address to be remotely connected, if the net manager does not have the name of the database to be remotely connected, create a new database. 2. The other steps are the same as 2-5 in the second case. Case 4: the oracle server is not installed on the local machine, pl SQL development, toad SQL development, SQL navigator, and other database management tools are not installed, but the oracle client is installed. An ORACLE server is installed on a virtual machine or another computer, that is, a virtual machine or another computer. In this case, I use sqlplus in the oracle client to remotely connect to the oracle server database as an example: 1. Open the net manager in the oracle client and configure the Database Name and IP address to be remotely connected, if the net manager does not have the name of the database to be remotely connected, create a new database. 2. Same as step 2 in the second case. 3. In the same case as in step 3. 4. Open sqlplus: (1) If you log on with sys, log on to the database with the username: sys password: xxxxxx host string: as sysdba. (2) If you use another user to log on, the user name is xxx password: xxxxxx host string: name of the database to be connected. log on to the database. Note: 1. The server and client firewalls need to be disabled. 2. If the *** service cannot be started, you need to enable the Net Configuration Assistant, or create a *** service. 3. What should I do if I forget my Database Password? Follow these steps to change the password: start --> Run --> cmd input: sqlplus/nolog press Enter: connect/as sysdba press enter user unlock: alter user system account unlock press ENTER Change Password: alter user system identified by manager4. How can I determine whether the database is running in archive mode or non-archive mode? Go to dbastudio, and choose history> database> archive.