Author Archives: james huang

ORA-15260: permission denied on ASM disk group

Problem Try to set ASM diskgroup attribute, then get below errors: $ sqlplus / as sysdba … .. . SQL> alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′; alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′ * ERROR at line 1: ORA-15032: … Continue reading

Posted in ASM, GI and RAC, ORA- ERRORS, User Privileges and Roles | Tagged , , | Leave a comment

CRS-4995: The command ‘Delete resource’ is invalid in crsctl. Use srvctl for this command.

Situation Trying to delete the database resource “ora.RACTEST.db” by using CRSCTL, because ORACLE_HOME has been uninsulated. But below error occurred. $crsctl delete resource ora.RACTEST.db CRS-4995: The command ‘Delete resource’ is invalid in crsctl. Use srvctl for this command. Solution Add … Continue reading

Posted in GI and RAC | Tagged , , , , | Leave a comment

SP2-0027: Input is too long (> 2499 characters) – line ignored

Sometimes execute SQL scripts from SQL*PLUS, then  get below error: SP2-0027: Input is too long (> 2499 characters) – line ignored Workaround: To make one line sql script into different lines, which have less than 2500 characters fir each line. … Continue reading

Posted in Client, SQL Net, SQL Scripts For DBA | Tagged , | Leave a comment

How to Monitor DataPump

1) Get DataPump job details from database: SQL>select JOB_NAME,OPERATION,JOB_MODE,DEGREE,ATTACHED_SESSIONS , STATE from dba_datapump_jobs JOB_NAME OPERATION JOB_MODE DEGREE ATTACHED_SESSIONS STATE ————————– ———- ———- ———- —————– —————————— SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA 4 1 EXECUTING 2) Also the job name can be found from … Continue reading

Posted in DataPump | Tagged , , , , , , | Leave a comment

Unable to load Sfix.ini file: java.io.FileNotFoundException: 22644310\sfix.ini (The system cannot find the path specified)

Situation Trying to apply two below patches onto ORMB database, then got the below errors: 08/08/2017 11:52 AM <DIR> 20986229 02/04/2016 04:11 AM <DIR> 22329775 Directory of D:\PATCHES\V4.3.0.1.0-25963443_MultiPlatform\FW.V4.3.0.1.0-25963443\prereqpatches\RollupPack\FW\Database 08/08/2017 11:52 AM <DIR> . 08/08/2017 11:52 AM <DIR> .. 08/08/2017 11:52 … Continue reading

Posted in ORMB | Tagged , , , , , , , , , , , , | Leave a comment

The agent is overloaded [current requests: 128]

Situation Below alerts are received from racnode1 -“The agent is overloaded [current requests: 128]” From: oracle Sent: Friday, 4 August 2017 7:07 PM Cc: Subject: EM Event: Warning: racnode1 – Agent Unreachable (REASON = The agent is overloaded [current requests: … Continue reading

Posted in OEM12c, OEM13c | Tagged , , , , , , , | Leave a comment

High Swap Usage On Oracle Database Server

Situation: When investigating one client’s Oracle database server high swap memory usage, we find the swap space usage is constantly very high on this Linux server, which causes Oracle database a big performance issue. OS: RHEL 7.3 DB: Oracle 12.2.0.1 … Continue reading

Posted in Linux, Performance Tunning | Tagged , , , , , , , , , , , , , , | Leave a comment

ohasd failed to start

Situation : 1) Two 11.2.0.4 RAC nodes( racnode1/2). Deleted node racnode2 . Upgraded OS from RHEL 4  to RHEL 7 for racnode2, then tried to add node racnode2 back into cluster from racnode1. 2) export IGNORE_PREADDNODE_CHECKS=Y, Ran addnode.sh ->  orainstRoot.sh->root.sh, … Continue reading

Posted in GI and RAC, Upgrading and Patching | Tagged , , , , , , , , , , | Leave a comment

Copy Oracle Home Binary from One RAC Node to Another RAC Node

For some reason on RAC node 2 ( racnode2) , RAC oracle home binary needs to be copied from another node racnode1. 1)As RAC Oracle home owner, go to ORACLE_HOME/oui/bin  on racnode1: oracle@racnode1:/u01/app/oracle/product/11.2.0/dbhome_1/oui/bin$ ./addNode.sh “CLUSTER_NEW_NODES={racnode2}” Performing pre-checks for node addition … Continue reading

Posted in GI and RAC, Install and Upgrade | Tagged , , , , | Leave a comment

Move OCR, Voting Disk File, ASM SPILE to a New Diskgroup ( 11.2.0.4 )

Below exercise is to move everything from old OCR/VOTING diskgroup OCR_VOTE  to new diskgroup OCR_VOTE2. 1)Create New CRS Diskgroup: SQL> create diskgroup OCR_VOTE2 external redundancy disk ‘ORCL:OCR_VOTE2’; Diskgroup created. SQL> alter diskgroup OCR_VOTE2 set attribute ‘compatible.asm’=’11.2.0.0’; Diskgroup altered. 2) Mount … Continue reading

Posted in ASM, GI and RAC | Tagged , , , , , , , , , , , | Leave a comment