I am getting the error ".. some services stop automatically if they are not use by other service or program" when starting the TNS listener.
I am encountering the above error because I tried to set the compatibility to 12.2 from 12.1, which I believe is not possible.
When starting the database through command line:
I am getting the ff error:
C:\WINDOWS\system32>set oracle_sid=SID
C:\WINDOWS\system32>sqlplus startup;
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 22 22:16:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name: USERNAME
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name: USERNAME
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
I tried to search for the solution to revert back the setting and there are bunch of high level steps regarding creation of new pfile etc, which is I am not familiar.
Can somebody provide me the step by step guide on how to fix or revert the setting back?