Patching Oracle 10g on Win 2k3

Posted on 2006-07-08
Last Modified: 2008-01-09
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

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?

Question by:djguvnor
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2

Author Comment

ID: 17066824
Sorry, that should be upgrading from to Oracle Database 10g Release
LVL 25

Accepted Solution

jrb1 earned 200 total points
ID: 17066866
Hi djguvnor,

I think this is your problem:

I avoid using a listener connection when I startup or shutdown, as a matter of practice. I realize that cannot always be done. Are you physically on the machine? Can you ssh or telnet in and run sqlplus on the box? Then connect like so:

export ORACLE_SID=mydb  ###Unix/Linux
sqlplus sys as sysdba
[no password needed - just hit return ]
SQL> startup mount


Author Comment

ID: 17066938
What's the " export ORACLE_SID=mydb  ###Unix/Linux" all about?
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 17066987
I get: "'export' is not recognized as an internal or external command, operable program or batch file."

Author Comment

ID: 17067051
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.
LVL 25

Expert Comment

ID: 17067100
Sorry, that was the Unix syntax.  You got the windows syntax down.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question