|
Home > Archive > Tools for Oracle database > February 2006 > Listener Question with 10g install
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Listener Question with 10g install
|
|
| art@chicagorsvp.com 2006-02-09, 9:23 am |
| Hi Everyone,
We are trying this again since we have not gotten anywhere since
yesterday.
We are upgrading from 9i to 10g. We are following the steps in the
manual. We are a bit confused. The manual says the run the Network
Configuration Assistant before running the Database Upgrade Assistant.
We already have a listener running for 9i. The manual says we need a
different one for 10g. Since we are upgrading the database, the SID
stays the same.
So, we are a bit lost on what to run, and how. Are we supposed to stop
the 9i database and run a 10g listener? We are just not sure of what
steps to take.
Anyone who has performed an upgrade like this, if you can offer us any
assistance, it would be helpful........
Thank you
| |
| sybrandb@yahoo.com 2006-02-09, 11:23 am |
| Ok, I will try this also again.
Listeners are *brokers* only. They don't *NEED* a database to run!!
You should stop the 9i listener, configure the 10g listener, and start
it.
The database is not affected at all.
--
Sybrand Bakker
Senior Oracle DBA
| |
| art@chicagorsvp.com 2006-02-09, 11:23 am |
| We appreciate the advice. We tried stopping the 9i database, placing a
listener.ora in the new ORACLE_HOME and starting it. We received the
following error: TNS-12618: TNS:versions are incompatible
Here is our listener.ora. I'm looking to make sure there is nothing in
the file that identifies is as a 9i file.......
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= yogii)(Port= 1521))
(ADDRESS= (PROTOCOL= IPC)(KEY = PNPKEY))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SERVICE_NAME = YOG.coc.org)
(ORACLE_HOME = /ora2/app/oracle/product/10g)
(SID_NAME = YOG)
)
)
STARTUP_WAIT_TIME_LI
STENER = 0
CONNECT_TIMEOUT_LIST
ENER = 10
TRACE_LEVEL_LISTENER
= OFF
| |
| art@chicagorsvp.com 2006-02-09, 11:23 am |
| Actually Sybrad, we were able to find it. Turns out it was the PATH
variable. It was still looking at the 9i /bin directory........
All fixed, for now.........
Thank you.
|
|
|
|
|