Confusion during Oracle database installation-The record is an article I wrote on Weibo before

career change for it beginners about Oracle Database grooming
The first time you install a database is to follow the steps of the operation step by step to install, and did not have any doubts about the operation steps or why do you want to do so?
December 8, 2017 read the installation instructions again when there is a new understanding, so use the micro-blog to record, convenient for their own later to view:
1. When accessing the database with a browser, select http://localhost:5560/isqlplus/Access isql:http://localhost:1158/em/console/logon/logon;jsessionid= C0A8017548635961AC24D82439B8181847E496525C8 access to the Web version of the database Oracle Enterprise Manager 10G, why use browser access to this 1158,5560 port to access it? When viewing the PID port number via Task Manager, is oracle.exe named Port 1316?
Through degrees Niang know, in the Oracle installation directory has a file: Portlist.ini default port file txt format:
Isql*plus HTTP Port number =5560
Enterprise Manager Console HTTP port (ORCL) = 1158
Enterprise Manager Agent port (ORCL) = 3938
Otherwise, this file defaults to the port number when the Web page accesses the database.
2, the Oracle installation directory has a db_1 file, this is a database file, if there is db_2, stating that there are two Oracle database, only the name is not the same!
3, the first time to configure the Oracle database, the use of the Sys login, this is the permissions of the database administrator, here is not to repeat.
4, SQL Plus is the Oracle Environment tool, application development tools, you can use SQL Plus to access the database. Here's how to use SQL Plus: Https://baike.baidu.com/item/SQL%2APLUS/8985197?fr=aladdin
What about isql plus? The literal meaning and usage should be the web version of SQL Plus, which accesses the data directly from the Web page. If the same computer can be accessed through the following URL http://localhost:5560/isqlplus/, if the database on another computer, you can access the IP address http://ip:5560/isqlplus/.
5, access the database in the 3 method:
(1), through the Oracle database comes with the Environment tool/application development tool SQL Plus to access;
(2), using the web version of the SQL Plus tool isql plus for access;
(3), using the Remote Connection Tool Plsql tool for access;
6. Plsql Remote Connection Tool Plsql and instantclient Connection tool
(1), instantclient Chinese as an instant client, is the development of Oracle 10G after the installation of the light-free road color of the lightweight client, directly decompression can be used, there is no need to install Oracle client. We modify the configuration when configuring the Instantclient listener file Tnsnames.ora To change the IP address to the physical IP address of the computer where the Oracle data is installed. This file Tnsnames.ora corresponds to the Tnsnames.ora file in the Oracle installation file.
Instantclient in the learning process Configure the properties of the Tnsnames.ora file: IP and port number of the IP address of the computer that installed the Oracle database, the port is 1521, why is 1521, through the online query learned that the Oracle database installation file also has a Tnsnames.ora listening file, there is a phase Guan the configuration of the slogan 1521, which is why the instantclient in the listening file port is 1521.
The Instant Client tool configuration is complete after configuring the Plsql Remote Connection tool: Oracle home directory name and OCI library.
OCI Library, by Enquiry: OCI (Oracle Call Interface) is an application development tool developed by Oracle, a server that accesses the Oracle database to control the execution of various SQL statements, The application Interface (API) of the application is then created. It supports all SQL data definition, data operations, queries, transaction management operations, support for C and C + + data types, invocation, syntax and semantics. It provides a set of interface subroutines (functions) that can be accessed from an Oracle database.

Confusion during Oracle database installation-The record is an article I wrote on Weibo before