Oracle Learning (1)

1. After the Oracle database is installed, the remote cannot log on for the first time, and after entering the SYS user, the change will be effective thereafter.

2, when TNS to read the configuration, if the environment variable has been configured Tns_admin, then read directly from this directory. 3, the path is configured under the Oracle Client directory bin, you can use the tnsping command to test the connection. About Plsql Query tool configuration: Issue: 1, using the Instant client/oracle client clients to configure, found that the previous lightweight is indeed simple, but still use the Oracle client complete clients to do configuration. The specific configuration steps are as follows: Download Oracle client clients Address: HTTP://WWW.ORACLE.COM/TECHNETWORK/DATABASE/ENTERPRISE-EDITION/DOWNLOADS/112010-WI N32soft-098987.html 32-bit can be downloaded after installation, after installation using the NET Configuration assistant and Net Manager two tools to configure, such as red box about the above two tools different, I also do not understand, Since I use net config Assistant configuration without fruit, and then use Net Manager configuration, I found that the effect of the two different can refer to the following blog: http://www.xuebuyuan.com/2190783.html "It may also be the problem I configured environment variables before, several clients have been installed before, so the environment variable has changed" oracle_home ORACLE installation directory tns_admin listening file directory (that is, tnsnames.org directory) path under configuration%oracle_ Home%/bin used for a variety of commands such as sqlplus/tnsping and other configuration, you can use the Plsql to connect to the database note, before I just tnsping test through the monitoring, so directly try to use the ip+ port number and instance name to log in, found that you can, But always can not use the direct network service name Landing, judge is tnsnames.org problem, so repeatedly try to reconfigure, finally good. (should be no problem between, because too anxious, not waiting for the service response, so has been wrong)

Oracle Learning (1)