Installing Oracle Database 12c Release 1 (12.1.0.2.0) under Windows-Enterprise Edition

Installing Oracle Database 12c Release 1 (12.1.0.2.0) under Windows

Recently, Oracle database 12c Release 1 (12.1.0.2.0)-Enterprise Edition needs to be installed due to the need to establish an ODI repository on Oracle databases.

Software download

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen

installation process

Software update configuration, skipping:

Select the installation method, install and configure a DB instance

Select system type, Desktop class

Specify Windows users

Typical installation: Configure installation path, storage type, global database name and database password, container database name

Prerequisite Checks

Installation Summary

Start installation

Creating a database during installation

Specify password

Installation Complete

The installation is complete and you can access the database and instance information by logging into Enterprise Manager https://localhost:5500/em. The following ends are shown:

ORA-01219 pluggable database is not open

After the installation is complete, test the connection ORCL successfully with Navicat

Test PDBORCL failed

Refer to Article http://www.xifenfei.com/4432.html, the solution is as follows

Tnsnames.ora

Tnsnames.ora content at this time

# Tnsnames.ora Network Configuration file:c:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. LISTENER_ORCL = (  ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) Oraclr_connection_data =  (DESCRIPTION =    (address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))    )    (Connect_data =      (SID = Clrextproc)      (PRESENTATION = RO)    )  ORCL =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))    (Connect_data =      (SERVER = dedicated)      (service_name = ORCL)    )  )

You can also add PDBORCL to the Tnsnames.ora.

# Tnsnames.ora Network Configuration file:c:\app\oracle\product\12.1.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. LISTENER_ORCL = (  ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) Oraclr_connection_data =  (DESCRIPTION =    (address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))    )    (Connect_data =      (SID = Clrextproc)      (PRESENTATION = RO)    )  ORCL =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))    (Connect_data =      (SERVER = dedicated)      (service_name = ORCL)    )  )  PDBORCL =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))      (Connect_data =        (SERVER = dedicated)        (service_name = PDBORCL)      )  )

tnsping command test, the connection will be successful

You can also not add PDBORCL in Tnsnames.ora, by logging into the CDB

Alter Set Container=PDBORCL

Installing Oracle Database 12c Release 1 (12.1.0.2.0) under Windows-Enterprise Edition