분류 전체보기 (658) 썸네일형 리스트형 63 - [Oracle 19C] Grant Privileges of system and objects # 1 you have to connect sys as sysdba # 2 when the DBA connect, it will be on root container db show con_name /* CON_NAME ------------------------------ CDB$ROOT */ alter session set container=orclpdb /* Session altered. */ show con_name /* CON_NAME ------------------------------ ORCLPDB */ col username for a20 col account_status for a20 col common for a20 select username,account_status,common f.. 62 - [Oracle 19C] DB Link DATABASE LINK • A database link is a schema object in one database that enables you to access objects on another database. • The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services. • After you have created a database link, you can use it in SQL statements to refer to tables, views, and PL/SQL objects in the other.. 61 - [Oracle 19C] Oracle Net Manager (netmgr) Add Listener.ora Add tnsnames.ora 60 - [Oracle 19C] Oracle net configuration assistant(netca) Tools to configure listeners - Oracle Net Manager(netmgr) - Oracle Net Configuration Assistant(netca) - Listener Control utility - Enterprise Manager Cloud Cntrol - Database Configuration Assistant(allows you to create a listener when you create a CDB) # add listener [oracle@test admin]$ netca Oracle Net Services Configuration: Configuring Listener:LISTENER_TEST Listener configuration complete. .. 59 - [Oracle 19C] Creating static listener example 1. adding SID_LIST into listener.ora [oracle@test admin]$ echo $ORACLE_HOME /u01/app/oracle/product/19/db_1 SQL> show parameter instance NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ active_instance_count integer cluster_database_instances integer 1 instance_abort_delay_time integer 0 instance_groups string instance_mode string READ-WRITE instanc.. 58 - [Oracle 19C] Starting multi-instance & listener [oracle@test trace]$ echo $ORACLE_SID orcl [oracle@test trace]$ export ORACLE_SID=hong [oracle@test trace]$ echo $ORACLE_SID hong [oracle@test trace]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 30 13:57:01 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System G.. 57 - [Oracle 19C] Creating dynamic listener example 새로운 동적인 리스너를 추가하는 방법 1. tnsnames.ora 수정 - LISTENER2 추가 2. listener.ora 수정 - LISTENER2 추가 3. update local_listener [oracle@test ~]$ cd /u01/app/oracle/product/19/db_1/network/admin/ [oracle@test admin]$ ll 합계 28 -rw-r----- 1 oracle oinstall 452 11월 29 22:24 listener.ora -rw-r----- 1 oracle oinstall 328 11월 29 22:24 listener23112910PM2442.bak drwxr-xr-x 2 oracle oinstall 64 4월 17 2019 samples -rw-.. 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 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1529)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) port is 1529 [or.. 이전 1 ··· 20 21 22 23 24 25 26 ··· 83 다음
