?
Solved

Patching Oracle 10g on Win 2k3

Posted on 2006-07-08
6
Medium Priority
?
757 Views
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
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?

0
Comment
Question by:djguvnor
[X]
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
6 Comments
 
LVL 1

Author Comment

by:djguvnor
ID: 17066824
Sorry, that should be upgrading from 10.2.0.1 to Oracle Database 10g Release 10.2.0.2
0
 
LVL 25

Accepted Solution

by:
jrb1 earned 600 total points
ID: 17066866
Hi djguvnor,

I think this is your problem:

http://www.dba-oracle.com/t_ora_12514_tns_listener_service_name.htm

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

Regards,
John
0
 
LVL 1

Author Comment

by:djguvnor
ID: 17066938
What's the " export ORACLE_SID=mydb  ###Unix/Linux" all about?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

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

Author Comment

by:djguvnor
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.
0
 
LVL 25

Expert Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

770 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