Turn: http://blog.itpub.net/22664653/viewspace-722463/The logging system in an Oracle RAC environment is more complex than a single system: see:Brief Introduction to the Oracle cluster environment in the log architecture, in the face of problems, you can quickly find the required log files, timely positioning problems ~1.Oracle file path for cluster logsthe logs involved in an ORACLE cluster are primarily located in the "$GRID _home/log" and "$ORACLE _home/log" directories. 2. LOG directory Structurelog structure of the Clusterware layer:[email protected]:/home/grid>tree-d $ORACLE _home/log/opt/rac/11.2.0/grid/log|--CRS|--diag| '--Clients| '--User_root| '--host_1874443374_76| |--Alert| |--Cdump| |--incident| |--incpkg| |--Lck| |--metadata| |--Stage| |--Sweep| '--Trace'--Rac1|--Admin|--Agent | |--CRSD | | |--Oraagent_grid | | |--oraagent_oracle | | '--Orarootagent_root | '--OHASD | |--Oraagent_grid | |--Oracssdagent_root | |--Oracssdmonitor_root | '--Orarootagent_root|--Client|--CRSD|--CSSD|--CTSSD|--DiskMon|--EVMD|--GIPCD|--GNSD|--GPNPD|--MDNSD|--OHASD|--RACG | |--Racgeut | |--RACGEVTF | '--Racgmain'--SRVMDirectorieslog structure of the RMDBS layer:[email protected]:/opt/rac/oracle/diag/rdbms/rac>tree-d rac1Rac1|--Alert|--Cdump|--HM|--Incident|--incpkg|--ir|--lck|--Metadata|--Stage|--Sweep'--TraceDirectorieswhere "Rac1" is the host name. 3. Log directory Function Description1) The CRS log is stored in the "$GRID _home/log/2) CSS log is stored in the "$GRID _HOME/LOG/<HOSTNAME>/CSSD" directory, the system will be archived every 20M of the log;3) The EVM log is stored in the "$GRID _home/log/4) The log of the RACG executable file is recorded in the RACG directory in the "$GRID _home/log/5) The "$GRID _home/log/alert logs for 4.Oracle clustersthe alert log file in an Oracle RAC environment is the same as the alert log for an Oracle single instance. The file is located under the "$ORACLE _base/rdbms/This warning log records important warning messages about the Oracle cluster RDBMS level. [email protected]:/opt/rac/oracle/diag/rdbms/rac/rac1/trace>more alert_rac1.logStarting up:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the partitioning, Real application Clusters, OLAP, Data Miningand Real application testing options.Using parameter settings in Client-side Pfile/opt/rac/oracle/admin/rac/pfile/init.ora on machine Rac1System parameters with Non-default values:processes =nls_language = "Simplified Chinese"nls_territory = "China"memory_target = 1584Mcontrol_files = "+data2/rac/controlfile/current.260.781821965"db_block_size = 8192compatible = "11.2.0.0.0"log_archive_dest_1 = "Location=+data2"Log_archive_format = "YANGDB_%T_%S_%R.DBF"db_create_file_dest = "+data2"undo_tablespace = "UNDOTBS1"Instance_number = 1remote_login_passwordfile= "EXCLUSIVE"db_domain = ""dispatchers = "(protocol=tcp) (service=racxdb)"Remote_listener = "scan:1521"audit_file_dest = "/opt/rac/oracle/admin/rac/adump"audit_trail = "DB"db_name = "RAC"open_cursors =diagnostic_dest = "/opt/rac/oracle"Cluster Communication is configured to use the following interface (s) for this instance10.10.10.10Cluster interconnect IPC version:oracle udp/ip (generic)IPC Vendor 1 Proto 2Sat APR 20:50:38Pmon started with pid=2, OS id=16042Sat APR 20:50:38Vktm started with pid=3, OS id=16044 on elevated priorityVktm running at (ten) Millisec precision with DBRM quantum (+) MsSat APR 20:50:39GEN0 started with pid=4, OS id=16048Sat APR 20:50:39DIAG started with pid=5, OS id=16050Sat APR 20:50:39DBRM started with pid=6, OS id=160525. Summaryfamiliar with the location and function of log files in Oracle cluster environment can help to quickly locate the location of the fault and make good use of it. ora-29780:unable to connect Gpnp daemon [Clsgpnp_err] after the installation completes 11GR2 Grid, the following error is encountered when creating a disk group using ASMCA:Started getting following errorora-29780:unable to connect to GPNP daemon [Clsgpnp_err]Google is related to the environment variables: (Crs/grid is working properly).[email protected]/oragrid/dbs> env | grep ORAGrid_home=/opt/11.2.0/grid <====== inherited from the old bash_profle! ORACLE_SID=+ASM1Oracle_base=/opt/rac/gridOracle_home=/opt/rac/11.2.0/grid$GRID The _home variable must be consistent with $oracle_home, or you will not recognize the ASM disk when you create the disk with ASMCA!
Log architecture for Oracle RAC environments
