This morning, ran into an issue with my local Demantra install. When connecting to Business modeler I got a DB error " ORA-12154: TNS:could not resolve the connect identifier specified."
Additionally found that TOAD wont connect to my local DB 11g install too, giving the similar error. Checked that my DB services were running fine and TNSPING was responding well too.
Decided to bounce my DB using cmd prompt and found below error while doing it:
ORA-00065: initialization of FIXED_DATE failed
Recalled that last I used my DB I changed my DB settings to make it fixed date environment for some work and shutdown my DB with FIXED_DATE settings.
To resolve the issue, I took the option of creating a new PFILE using SPFILE and then edited the PFILE to take out the FIXED_DATE settings from it. Later I was able to make this change permanent by creating SPFILE using the PFILE.
Once created look for file named “initXXX.ora” where XXX stands for DB service name. e,g. VCPDB in DB Home install directory. Take out the FIXED DATE setting from init file and try starting server using :
SQL> startup pfile='uo1\dbhome_1\database\INITXXX.ORA' ;ORACLE instance started.
CREATE SPFILE from PFILE ='u01\dbhome_1\database\INITXXX.ORA' ;
RESTART again to use the SPFILE for starting the DB.
And... I am back in action with my local DB and Demantra install. :)
Additionally found that TOAD wont connect to my local DB 11g install too, giving the similar error. Checked that my DB services were running fine and TNSPING was responding well too.
Decided to bounce my DB using cmd prompt and found below error while doing it:
ORA-00065: initialization of FIXED_DATE failed
Recalled that last I used my DB I changed my DB settings to make it fixed date environment for some work and shutdown my DB with FIXED_DATE settings.
To resolve the issue, I took the option of creating a new PFILE using SPFILE and then edited the PFILE to take out the FIXED_DATE settings from it. Later I was able to make this change permanent by creating SPFILE using the PFILE.
CREATE PFILE FROM SPFILE;
Once created look for file named “initXXX.ora” where XXX stands for DB service name. e,g. VCPDB in DB Home install directory. Take out the FIXED DATE setting from init file and try starting server using :
SQL> startup pfile='uo1\dbhome_1\database\INITXXX.ORA' ;ORACLE instance started.
For making this change permanent:
CREATE SPFILE from PFILE ='u01\dbhome_1\database\INITXXX.ORA' ;
RESTART again to use the SPFILE for starting the DB.
And... I am back in action with my local DB and Demantra install. :)
