top of page
Search
Hanh Nguyen
Nov 24, 20151 min read
ORA-00257:Archiver Error, Connect Internal Only Until Freed and ORA-16014 and ORA-00312
Cause The flash_recovery_area is full. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive...
2 views0 comments
Hanh Nguyen
Nov 24, 20155 min read
TNS-12518 TNS listener could not hand off client connection
Step 1. Is listener version compatible to the database Check if you are using compatible listener version for your database version. If...
3 views0 comments
Hanh Nguyen
Nov 17, 20159 min read
OCR – Vote disk Maintenace
Prepare the disks For OCR or voting disk addition or replacement, new disks need to be prepared. Please refer to Clusteware/Gird...
1 view0 comments
Hanh Nguyen
Nov 10, 201511 min read
An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file.
Oracle Error: ORA-1157 An ORA-01157 is issued whenever Oracle attempts to access a file but cannot find or lock the file. Error...
0 views0 comments
Hanh Nguyen
Nov 2, 20151 min read
How to Determine Shared Memory Usage within Solaris
To show system-wide shared memory allocations, use the following command: # ipcs -ma T ID KEY MODE OWNER GROUP CREATOR...
0 views0 comments
Hanh Nguyen
Oct 31, 201516 min read
Memory – Tuning the Shared Pool and Tuning Library Cache Latch Contention
Troubleshooting Steps What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area...
0 views0 comments
Hanh Nguyen
Oct 30, 20151 min read
AIX- 20.9 0503-903 CHEDITION: EDITION CANNOT BE DETERMINED
# chedition -l <– Shows what you have # chedition -x <– Sets to Express # chedition -s <– Set to Standard
3 views0 comments
Hanh Nguyen
Oct 30, 20151 min read
AIX – PERMISSION DENIED WITH SCP
Actually, you can fix it without un-mounting /usr or rebooting. Here’s how: mkdir /temproot mount / /temproot chmod a+rx /temproot/usr...
0 views0 comments
Hanh Nguyen
Oct 4, 20152 min read
ORA-12545 TNS: Host or Object Does not Exist
Symptoms When attempting to connect to a RAC service name, the connection intermittently fails with an ORA-12545 error: TNS: Host or...
0 views0 comments
Hanh Nguyen
Oct 4, 20154 min read
Data Collecting for Troubleshooting Oracle Clusterware (CRS or GI) And Real Application Cluster (RAC
PURPOSE This note lists what to collect for different type of Oracle Clusterware and Real Application Cluster issues, it’s not mandatory...
1 view0 comments
Hanh Nguyen
Oct 4, 201523 min read
Troubleshoot Grid Infrastructure Startup Issues
Scope This document is intended for Clusterware/RAC Database Administrators and Oracle support engineers. Details Start up sequence: In a...
0 views0 comments
bottom of page