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

This article mainly introduces "what operations have been done in the analysis database". In the daily operation, I believe that many people have doubts about analyzing what operations the database has done. The editor has consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "analyzing what operations the database has done". Next, please follow the editor to study!

Since the database is not opened to the nomount state, the database cannot open 10046, so we can only know what the database has done through the background log.

Execute the open command to allocate memory (this system does not use Large Page for memory allocation), and the memory page size is 4k.

2020-01-24T09:24:21.783126-05:00Starting ORACLE instance (normal) (OS id: 12978) 2020-01-24T09:24:21.897815-05:00***/dev/shm will be used for creating SGA Large pages will not be used Only standard 4K pages will be used

Dump system resources to SGA

* 2020-01-24T09:24:21.921610-05VOV 0000mm * * 2020-01-24T09:24:21.922030-05:00Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Then assign it according to the system / etc/security/limits.conf configuration

2020-01-24T09:24:21.922828-05:00 Per process system memlock (soft) limit = 3072M2020-01-24T09:24:21.923100-05:00 Expected per process system memlock (soft) limit to lock instance MAX SHARED GLOBAL AREA (SGA) into memory: 792M2020-01-24T09:24:21.923559-05:00 Available system pagesizes: 4K 2048K 2020-01-24T09:24:21.924205-05:00 Supported system pagesize (s): PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR (s) 4K Configured 202757 202757 NONE2020-01-24T09:24:21.925105-05:00 Reason for not supporting certain system pagesizes: 2048K-Dynamic allocate and free memory regions

Read CPU information

2020-01-24T09:24:21.925576-05-24T09:24:30.963798-05:00LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 02020-01-24T09:24:31 .028811-05:00Initial number of CPU is 2Number of processor cores in the system is 2Number of processor sockets in the system is 1

Environmental check

Capability Type: Network capabilities requested: 7 detected: 0 Simulated: 0Capability Type: Runtime Environment capabilities requested: 400000FF detected: 40000000 Simulated: 0Capability Type: Engineered Systems capabilities requested: 7 detected: 0 Simulated: 0Capability Type: Database Test capabilities requested: 3 detected: 0 Simulated: 0

Read parameter file

Using LOG_ARCHIVE_DEST_1 parameter default value as / u01/app/oracle/product/19.3.0/dbhome_1/dbs/archAutotune of undo retention is turned on. IMODE=BRILAT = 51LICENSE_MAX_USERS = 0SYS auditing is enabledNOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASMNOTE: remote asm mode is local (mode 0x1 From cluster type) NOTE: Cluster configuration type = NONE [2] Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-ProductionVersion 19.3.0.0.0.ORACLE_HOME: / u01/app/oracle/product/19.3.0/dbhome_1System name: LinuxNode name: node1Release: 3.10.0-957.el7.x86_64Version: # 1 SMP Thu Oct 4 20:48:51 UTC 2018Machine: x86_64Using parameter settings in server-side spfile / U01/app/oracle/product/19.3.0/dbhome_1/dbs/spfileorcl.oraSystem parameters with non-default values: processes = 300 nls_language = "AMERICAN" nls_territory = "AMERICA" memory_target = 792m control_files = "/ oradata/ORCL/control01.ctl" control_files = "/ oradata/ORCL/control02.ctl" db_ Block_size = 8192 compatible = "19.0.0" undo_tablespace = "UNDOTBS1" db_securefile = "PREFERRED" remote_login_passwordfile= "EXCLUSIVE" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" local_listener = "LISTENER_ORCL" audit_trail = "NONE" db_name = "orcl" open_cursors = 300diagnostic_dest = "/ u01/app/oracle"

Start to start all parts of the process

2020-01-24T09:24:31.719373-05:00===NOTE: PatchLevel of this instance 0===WARNING: Invalid value for listener related parameter MIXED LISTENER2020-01-24T09:24:31.962206-05:00ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalidORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'Starting background process PMON2020-01-24T09:24:32.059335-05:00PMON started with pid=2, OS id=13012 Starting background process CLMN2020-01-24T09:24:32.130665-05:00CLMN started with pid=3 OS id=13014 Starting background process PSP02020-01-24T09:24:32.226568-05:00PSP0 started with pid=4, OS id=13016 Starting background process VKTM2020-01-24T09:24:33.424618-05:00VKTM started with pid=5, OS id=13019 at elevated (RT) priority2020-01-24T09:24:33.443572-05:00Starting background process GEN02020-01-24T09:24:33.457207-05:00VKTM running at (1) millisec precision with DBRM quantum msStarting background process MMAN2020-01-24T09:24:33.526550-05:00GEN0 started with pid=6 OS id=13024 2020-01-24T09:24:33.594270-05:00MMAN started with pid=7, OS id=13026 Starting background process GEN12020-01-24T09:24:33.846502-05:00GEN1 started with pid=9, OS id=13030_13031 Starting background process DIAG2020-01-24T09:24:33.914542-05:00DIAG started with pid=11, OS id=13033 Starting background process OFSD2020-01-24T09:24:34.021251-05:00OFSD started with pid=12 OS id=13035_13036 Starting background process DBRM2020-01-24T09:24:34.029524-05:00Oracle running with ofslib:'Oracle File Server Library' version=22020-01-24T09:24:34.072386-05:00DBRM started with pid=8, OS id=13038 Starting background process VKRM2020-01-24T09:24:34.148547-05:00VKRM started with pid=14, OS id=13040 Starting background process SVCB2020-01-24T09:24:34.206158-05:00SVCB started with pid=15, OS id=13042 Starting background process PMAN2020-01-24T09:24:34.274700-05:00PMAN started with pid=16 OS id=13044 Starting background process DIA02020-01-24T09:24:34.357435-05:00DIA0 started with pid=17, OS id=13046 Starting background process DBW02020-01-24T09:24:34.483648-05:00Starting background process LGWR2020-01-24T09:24:34.483685-05:00DBW0 started with pid=18, OS id=13048 Starting background process CKPT2020-01-24T09:24:34.547257-05:00LGWR started with pid=19, OS id=13051 2020-01-24T09:24:34.625889-05:00CKPT started with pid=20 OS id=13053 2020-01-24T09:24:34.708849-05:00LGWR slave LG00 created with pid=21, OS pid=13055Starting background process SMON2020-01-24T09:24:34.771650-05:00SMON started with pid=22, OS id=13057 LGWR slave LG01 created with pid=23, OS pid=13059Starting background process SMCOStarting background process RECO2020-01-24T09:24:34.910826-05:00SMCO started with pid=24, OS id=13061 2020-01-24T09:24:34.981554-05:00RECO started with pid=25, OS id=13063 Starting background process LREG2020-01-24T09:24:35.115737-05:00LREG started with pid=27 OS id=13067 Starting background process PXMN2020-01-24T09:24:35.253859-05:00PXMN started with pid=29, OS id=13071 Starting background process FENC2020-01-24T09:24:35.321431-05:00FENC started with pid=30, OS id=13073 Starting background process MMON2020-01-24T09:24:35.379970-05:00MMON started with pid=31 OS id=13075 Starting background process MMNL2020-01-24T09:24:35.417133-05:00starting up 1 dispatcher (s) for network address'(ADDRESS= (PARTIAL=YES) (PROTOCOL=TCP)) '... 2020-01-24T09:24:35.417175-05:00MMNL started with pid=30, OS id=13077 starting up 1 shared server (s)... 2020-01-24T09:24:35.565561-05:00Starting background process TMON2020-01-24T09:24:35.637575-05:00TMON started with pid=34, OS id=13083 so far The study on "analyzing what the database has done" is over. I hope to be able to solve everyone's 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.