Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install Oracle 12c". In daily operation, I believe many people have doubts about how to install Oracle 12c. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to install Oracle 12c". Next, please follow the editor to study!

The installation process of non-rac has not changed much compared with the previous version, and the database connection after installation has changed compared with 11g.

View the monitoring status:

C:\ Users\ lenovo > lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0-Production on December-March-2019 11:26:26

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=lenovo-PC) (PORT=1521)

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0-Production

Launch date 08-March-2019 09:43:09

Uptime 4 days, 1 hour, 43 minutes, 20 seconds.

Trace level off

Security ON: Local OS Authentication

SNMP OFF

Listener parameter file D:\ app\ oracle\ product\ 12.2.0\ dbhome_1\ network\ admin\ listener.ora

Listener log file D:\ app\ oracle\ diag\ tnslsnr\ lenovo-PC\ listener\ alert\ log.xml

Listening Endpoint Summary.

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=lenovo-PC) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (PIPENAME=\\.\ pipe\ EXTPROC1521ipc))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=lenovo-PC) (PORT=5500)) (Security= (my_wallet_directory=D:\ APP\ ORACLE\ admin\ ly23c\ xdb_wallet)) (Presentation=HTTP) (Session=RAW))

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 1 handler for this service.

The service "d0d52dfdff7d487396eb1612830970db" contains 1 instance.

Instance "ly23c", status READY, contains 1 handler for this service.

The service "ly23c" contains 1 instance.

Instance "ly23c", status READY, contains 1 handler for this service.

The service "ly23cXDB" contains 1 instance.

Instance "ly23c", status READY, contains 1 handler for this service.

The service "orclpdb1" contains 1 instance.

Instance "ly23c", status READY, contains 1 handler for this service.

Command executed successfully

Connection method 1: configure tnsname.ora file

-- Connect to cdb

Sqlplus system/oracle@LY_PDB1

-- Connect to pdb

Sqlplus hr/oracle@ly_pdb1

LY_CDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = lenovo-PC) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ly23c)

)

)

LY_PDB1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = lenovo-PC) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orclpdb1)

)

)

Connection mode 2: ip direct connection

-- Connect to cdb

Sqlplus system/oracle@lenovo-pc:1521/ly23c

-- Connect to pdb

Sqlplus hr/oracle@lenovo-pc:1521/orclpdb1

At this point, the study on "how to install Oracle 12c" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.