Oracle Research topics: Oracle system Installation and configuration

Recently started to study Oracle database, the company's system is either Oracle or MySQL.

As an IT worker, it's an incredible thing not to touch Oracle. It's too low to think about the past few years, or even the start of the IT industry, when you've only played SQL Server.

So it's better to learn from now on. Oracle database is not only the development of Plsql, but also the tuning and configuration of Oracle.

Two files downloaded from Oracle Web: Database and Client

Database address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

The client only needs to install the dozens of gigabit Instant client:http://www.oracle.com/technetwork/topics/winx64soft-089540.html

After downloading, the database and client are installed.

Next is the installation of PL/SQL Developer, online to download.

In the installation directory of the Oracle database, find the 2 files of Listener.ora and Sqlnet.ora, which exist in: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN \ Down

whichListener.oraContent: Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = mengxin) #数据库实例 (oracle_home = D:\oracle\Administrator\product \11.2.0\dbhome_1) #安装数据库目录 (Envs = "extproc_dlls=only:d:\oracle\administrator\product\11.2.0\dbhome_1\bin\ Oraclr11.dll ") #连接dll)) LISTENER = (Description_list = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 15 )) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = mengxin))) Adr_base_listener = D:\oracle\Administrator #安装目录Sqlnet.oraSqlnet.authentication_services= (NTS) NAMES (no change is generally required). Directory_path= (TNSNames, Ezconnect)

In the Oracle Client installation directory, locate Tnsnames.ora, which is configured as follows:

Listener_mengxin = #LISTENER_实例名

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) Mengxin = #连接名 (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))) (Connect_data = (SER Vice_name = mengxin)) So Oracle's pre-use configuration is over!

Oracle Research topics: Oracle system Installation and configuration