Database (237) 썸네일형 리스트형 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.. 39 - [Oracle 19C] CONTAINER clause in alter system ISSES_MODIFIABLE is false that means you cannot change it in the session, but you can change it. ISSYS_MODIFIABLE(system modifiable) is immediate. This means that I can change the value in the memory level. FALSE: You can only change the value with a static parameter using scope=spfile. In other words, the change will take effect from the next restart of the database. IMMEDIATE: If you change th.. 38 - [Oracle 19C] Default scope in alter system Alter system set parameter=value - If a server parameter file was used to start up the database, then BOTH is the default. Alter system set parameter=value same as Alter system set parameter=value scope=both - If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify. Alter system set parameter=value same as Alter system set para.. 이전 1 ··· 22 23 24 25 26 27 28 ··· 30 다음