I'm attempting to patch Oracle 10g from 10.0. to
Shutdown the databases using oradim then shut down all oracle services in management console.
Apply the patch
Then the documentation says:
For single-instance installations, use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:
C:\> sqlplus /NOLOG
SQL> CONNECT SYS/password AS SYSDBA
but I get the "ORA-12514: TNS listener does not currently know of service requested in connect descriptor."
So I can't do the next bit which is "startup upgrade"
So I then tried starting the database using oradim but if I specify -starttype inst I get "ORA-01092: ORACLE instance terminated. Disconnection forced" Using -starttype srvc doesn't seem to make any difference to anything.
The only joy I had was using the web based enterprise manager to mount the database then I can connect in SQLPlus but when I issue: "startup upgrade" it says the database is already started and it must be shutdown so then I issue "shutdown" and then "startup upgrade" and I'm back to "ORA-12514: TNS listener does not currently know of service requested in connect descriptor."
What am I missing here?