Post database creation CRS Health check:
2.1 Check that the crs daemons are running on each node, if not then start them.
ps –ef|grep d.bin should return
evmd.bin
ocssd.bin
crsd.bin
oprocd.bin
To start them login as root and source the .profile in /home/oracle and then run the following command
crsctl start crs
2.2 Run the following command as the oracle user on one of the nodes in the cluster and check that everything is online.
crs_stat –t –v
2.3 Run the following command as the oracle user on all nodes in the cluster
olsnodes
This should return all of the nodes of the cluster and that css is up and running and css on each node can talk to the css of the other nodes in the cluster.
2.4 Run the following commands as the root user on each node
crsctl check crs
crsctl check cssd
crsctl check crsd
crsctl check evmd
All of these commands should return that the daemon appears healthy
2.5 As the oracle user check the OCR integrity
Ocrcheck
2.6 Backup the OCR by running the following command as the root user
ocrconfig –export $CRS_HOME/manual_backups/ocr_export
2.7 As the root user check the automatic backups of the OCR
ocrconfig –showbackup
Random Posts
Blog Archive
ORACLE DBA
Search This Blog
Blog Archive
-
▼
2011
(101)
-
▼
July
(79)
- oracle RAC Commands
- 10g ORACLE
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- To monitor job progress[RMAN]
- systemstate and hang analyse
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- UNIX raw filesystem commands for dba
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- ENQUEUE LOCK:
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- The Archiver hung alerts
- How to register database with RMAN recovery catalog
- Thirupal_Boreddy_oracle_DBA: Procedure to relocate...
- dbms_metadata
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- set date format
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- Static Parameter
- HSMP cluster commands:
- HSMP cluster commands:
- systemstate and hang analyse
- OMS Commands
- Thirupal_Boreddy_oracle_DBA: OMS Commands
- crs commands
- crs commands
- crs commands
- Process for clearing down archivelogs via Rman
- Thiru: Process for clearing down archivelogs via Rman
- Converting to archive log mode in RAC
- Thiru: Converting to archive log mode in RAC
- Steps for VIP Relocation
- Thiru: Converting to archive log mode in RAC
- Add space in RAC DB TABLESPACES:
- Thiru: Process for clearing down archivelogs via Rman
- Chang Archive log destination
- Thiru: Chang Archive log destination
- Manual Archive Backup
- Thiru: Manual Archive Backup
- Thiru: To monitor job progress[RMAN]
- Thiru: Thirupal_Boreddy_oracle_DBA: ENQUEUE LOCK:
- Thiru: Chang Archive log destination
- RMAN Checks
- Thiru: RMAN Checks
- ASM – basic things to look for
- Thiru: RMAN Checks
- Killing a Hanging CRSD Daemon;
- Thiru: ASM – basic things to look for
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Thiru: Useful CRS Commands
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Operating System Commands
- Thiru: Useful CRS Commands
- Tracing a SQL session
- Check cluster name
- The Archiver hung alerts
- Log file locations in RAC
- Thiru: Tracing a SQL session
- System state dump and Hanganalyze
- Thiru: The Archiver hung alerts
- RAC - Healthchecking the Startup of Oracle for a g...
- Thiru: Log file locations in RAC
- RAC - Stopping everything Oracle-related for a giv...
- Thiru: Procedure to relocate services in RAC nodes
- Enabling Archive Logs in a RAC Environment
- Adding a new vote disk
- Thiru: Enabling Archive Logs in a RAC Environment
- Export of table Partition
- Flashback setup in RAC
- Voting Disk
- Post database creation CRS Health check
- RAC Troubleshooting
- Change the parameters for RAC database
- Compressed Export and Import
- Adding the space to tablespace
- Change db_recovery_file_dest_size
- Restarting SSH broker in the event of a hang
- Thiru: Thirupal_Boreddy_oracle_DBA: oracle RAC Com...
-
▼
July
(79)
Thirupal Boreddy. Powered by Blogger.
My Blog List
Followers
Lorem 1
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Lorem 4
Tagged with: Post database creation CRS Health check
About Oracle DBA World
WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
Subscribe to:
Post Comments (Atom)
QUERY FOR CPU USAGE
select a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...


No comments