djguvnor
asked on
Patching Oracle 10g on Win 2k3
Hi there,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What's the " export ORACLE_SID=mydb ###Unix/Linux" all about?
ASKER
I get: "'export' is not recognized as an internal or external command, operable program or batch file."
ASKER
Aha, well it was nearly right.
instead of export use:
set oracle_sid=mydb
then same as above, though in my case I was upgrading so I used startup upgrade.
Thanks for the pointer jrb1.
instead of export use:
set oracle_sid=mydb
then same as above, though in my case I was upgrading so I used startup upgrade.
Thanks for the pointer jrb1.
Sorry, that was the Unix syntax. You got the windows syntax down.
ASKER