I'm testing 12cRAC database on RHEL5 and need your help to troubleshoot and fix the following issue -
DBCA fails at the end of the configuration to create and startup new RAC database with the following errors
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/TDB1/spfileTDB1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/TDB1/spfileTDB1.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/TDB1/spfiletdb1.ora
ORA-01017: invalid username/password; logon denied
I also tried executing script (which was created by DBCA) to create the new DB manually and got the same results - it happens during first attempt to start it up using SPFILE after new DB was successfully created (it was started up using pfile)
Clusterware with ASM install was successful, binaries were also installed without issues,
cluster seems healthy, I see correct files within ASM using asmcmd etc ..
got stuck here and need some directions ... very confused by ORA-01017 password error
wonder if anyone had same or similar issues ?
Thank you !
Thank you everyone for suggestions and recommendations -
ASM is accessible using asmcmd and I can see all the DB files incuding spfile, they were created by DBCA, alert log showed same information I posted
After extensive troubleshooting and testing the issue was idedntified and fixed - 'dba' group needs to be the primary group for 'oracle' user, not the secondary one. I suspected that something was not right with 'oracle' user access to asm based on that strange password error. There is more I need to check as the issue and fix with swapping groups seems strange. Secondary group is not enough ti have proper rights ??? my first reaction was - seriously ? wtf ?
Anyway - I need to move one now ...
Thank you again !