Oracle Learning (1), oracle Learning

Oracle Learning (1), oracle Learning

1. After the oracle database is installed, the system cannot log on to the database for the first time. You need to enter the sys user and change it to make it valid.

2. When TNS reads the configuration, if TNS_ADMIN has been configured in the environment variable, it will be read directly from this directory. 3. Configure the path to the bin directory of the oracle client. You can use the tnsping command to test the connection. About PLSQL query tool configuration: Problem: 1. I used the instant client/oracle client for configuration. I found that the previous lightweight tool was simple, but I still used the Complete oracle client for configuration. The specific configuration steps are as follows: Download the oracle client address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html 32-bit to download and install, install and use the net configuration assistant and net manager tool to configure, for example, I cannot understand the differences between the two tools in the red box, because after I directly use the net configuration assistant to configure it, see the following blog for the differences between the two: ORACLE installation directory TNS _ After configuring % ORACLE_HOME %/BIN in the path of the ADMIN listening file directory (that is, the directory where tnsnames.org is located) for various commands, such as SQLPLUS/TNSPING, you can use PLSQL to connect to the database. Before that, I only listened to the TNSPING test, so I directly tried to use IP + port number and Instance name to log on, however, you cannot directly log on with the network service name and identify it as a problem with tnsnames.org. (There should be no problem between them, because they are too anxious to wait for the response from the service, so they keep making mistakes)