분류 전체보기 (658) 썸네일형 리스트형 47 - [Oracle 19C] To create PDB from seed PBD(DBCA) # to create tablespace manually if you did not choose the default user tablespace CREATE TABLESPACE pdb2 DATAFILE '/u01/app/oracle/oradata/ORCL/pdb2/pdb2_01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; ALTER TABLESPACE pdb2 ADD DATAFILE '/u01/app/oracle/oradata/ORCL/pdb2/pdb2_02.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- ---------- PDB.. 46 - [Oracle 19C] Connecting to the new PDB SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> col name format a20 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- ---------- PDB$SEED READ ONLY ORCLPDB READ WRITE PDB1 READ WRITE SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NO.. 45 - [Oracle 19C] To create PDB from seed PBD We do this by create pluggable database statement. This will copy data files from seed to new location. This will create system and sysaux tablespaces. This will create default schemas and common users . Sys user will be super user. system user can manage the PDB. This will create the DB service automatically. What is the prerequisites for using create pluggable database statement?.. 44 - [Oracle 19C] V$SPPARAMETER # shutdown immediate; [oracle@test dbs]$ ls -ltr 합계 28 -rw-r--r-- 1 oracle oinstall 3079 5월 14 2015 init.ora -rw-r----- 1 oracle oinstall 24 11월 11 01:00 lkORCL -rw-r----- 1 oracle oinstall 2048 11월 14 16:58 orapworcl -rw-r--r-- 1 oracle oinstall 1035 11월 22 11:37 initorcl.ora -rw-r--r-- 1 oracle oinstall 1054 11월 22 13:14 test.ora -rw-r----- 1 oracle oinstall 3584 11월 24 11:21 spfileorcl.ora -r.. 43 - [Oracle 19C] Enable DDL logging SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter session set container=orclpdb; Session altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 ORCLPDB READ WRITE NO SQL> show con_name CON_NAME ------------------------------ ORCLPDB SQL> show parameter ddl; NAME TYPE VALUE -----------------------.. 42 - [Oracle 19C] (ADR)Trace files • Trace files contain: Error information (contact Oracle Support Services if internal error occurs) Information that can provide guidance for tuning applications or an instance • Each server and background process can write to an associated trace file. • Trace file names for background processes are named after their processes. Exception: Trace files generated by job queue processes • Oracle Dat.. 41 - [Oracle 19C] View alert log using ADRCI [oracle@test Desktop]$ adrci ADRCI: Release 19.0.0.0.0 - Production on Thu Nov 23 16:23:17 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show alert Choose the home from which to view the alert log: 1: diag/rdbms/orcl/orcl 2: diag/clients/user_oracle/host_1461729758_110 3: diag/tnslsnr/test/listener Q: to quit Please select o.. 40 - [Oracle 19C] Automatic Diagnostic Repository (ADR) Typical installations will have the ADR_BASE set to the ORACLE_BASE [oracle@test ~]$ echo $ORACLE_BASE /u01/app/oracle • You can make sure from parameter diagnostic_dest • The ADR home path is "/u01/app/oracle/diag/rdbms/orcl/orcl" SQL> show parameter diagnostic_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/or.. 이전 1 ··· 22 23 24 25 26 27 28 ··· 83 다음
