본문 바로가기

Database/Oracle

53 - [Oracle 19C] To create a new Instance

 

 

 

 

 

 

If you wish to use a different listener port number, select 'Create a new listener.'

 

 

 

 

 

 ~/StudioProjects/oracle$ cat *.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle88)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.com)
    )
  )

 

 

 

 

 

 

[oracle@test admin]$ sqlplus sys/Manager123#@ORS as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 28 16:36:00 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0


SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT


SQL> show parameter db_name;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 ORS


SQL> select name, cdb, con_id, OPEN_MODE from V$DATABASE;

NAME	  CDB	  CON_ID OPEN_MODE
--------- --- ---------- --------------------
ORS	  YES	       0 READ WRITE


SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production


SQL> select instance_name, version_full, status, database_status from v$instance;

INSTANCE_NAME	 VERSION_FULL	   STATUS	DATABASE_STATUS
---------------- ----------------- ------------ -----------------
ORS		 19.3.0.0.0	   OPEN 	ACTIVE


SQL> show parameter instance_name

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
instance_name			     string	 ORS


SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 ORSPDB			  READ WRITE NO
     
     
SQL> select con_id, name, open_mode from V$CONTAINERS;

    CON_ID NAME 		OPEN_MODE
---------- -------------------- ----------
	 1 CDB$ROOT		READ WRITE
	 2 PDB$SEED		READ ONLY
	 3 ORSPDB		READ WRITE

 

 

 

 

Refer to the bottom section of the content in the following link for information regarding multi-instance and multi-Listener settings:

 

2023.11.30 - [Database/Oracle] - 56 - [Oracle 19C] The default listener - non-default port

 

56 - [Oracle 19C] The default listener - non-default port

Non-default port - to change PORT as 1529 [oracle@test admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/19/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST =

unsungit.tistory.com