| Oracle Connectivity Puzzle [message #303724] |
Sun, 02 March 2008 07:07  |
kelvs
Messages: 15
Registered: December 2006
|
Junior Member |
|
|
Guys,
I need help on this:
I've been asked to configure a "medium-rare" oracle setup. I've been able to setup the data and log files but I can't get the listener to run with a service
Here are the settings:
NAME VALUE
------------------------------ ------------------------------
db_domain aranetahome.net
instance_name
local_listener
db_name testdb2
echo $ORACLE_SID gives 9itestdb2
tried to configure the listener using static mode
LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.101)(PORT=5000)))
Services Summary...
Service "testdb2.aranetahome.net" has 1 instance(s).
Instance "9itestdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
I can't seem to get the service registered. Am I missing something here?
I haven't built the tnsnames.ora as well as sqlnet.ora, tried running netmgr but says that this machine's java is not registered with GLIB gees so guess, i have to do things manually.
|
|
|
|
|
|
| Re: Oracle Connectivity Puzzle [message #303791 is a reply to message #303782] |
Sun, 02 March 2008 21:18  |
kelvs
Messages: 15
Registered: December 2006
|
Junior Member |
|
|
hi ebrain
| ebrian wrote on Mon, 03 March 2008 08:54 | So what problem are you having?
ok, here's what i plan to do
1. get the listener up (on a different port other than 1521) and running with service
2. have it configured as shared server
| kelvs wrote on Sun, 02 March 2008 08:07 |
I can't seem to get the service registered.
|
Do you mean to get the service to register automatically, if so check Registering Information with a Nondefault Listener.
BTW...can you successfully launch Net Configuration Assistant (netca) ?
|
Service won't register with the listener, i followed the instructions written in the book. am i missing something?
that's one big no no here because of a compiler problem in linux. So I have to do things manually.
|
|
|
|
| Re: Oracle Connectivity Puzzle [message #303792 is a reply to message #303724] |
Sun, 02 March 2008 21:35 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Service won't register with the listener, i followed the instructions written in the book. am i missing something?
>that's one big no no here because of a compiler problem in linux. So I have to do things manually.
You keep reporting about problems, but you have steadfastly NEVER produced reproducible evidence of EXACTLY what you are doing & ACTUALLY how Oracle responds.
Is CUT & PASTE broken or do you need remedial training in using CUT & PASTE.
Since many, many others have made it work, therefore I conclude PEBKAC.
[Updated on: Sun, 02 March 2008 21:36] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Oracle Connectivity Puzzle [message #303820 is a reply to message #303724] |
Sun, 02 March 2008 23:34 |
kelvs
Messages: 15
Registered: December 2006
|
Junior Member |
|
|
ok, for the sake of others who wish to know what happened, I'll post what I did
1. I created the listener.ora file located inside $ORACLE_HOME/rdbms/admin directory
vi listener.ora
LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))
2. I started the listener by issuing (if there's a mistake here, kindly point it out. thanks)
lsnrctl stop
lsnrctl reload
lsnrctl start
and the result is, the listener is running on port 5000 but there are no services associated
3. I appended these statements on the listener.ora
vi listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))
so here's the result
LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))
4. I tried executing step 2 above and it indicated that there's
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00303: syntax error in NV string
Listener failed to start. See the error message(s) above...
5. After checking the lines to see if there was either a misspelled word or a missing closing parenthesis, I tried to format the SID_LIST_LISTENER part so
vi listener.ora
LISTENER=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=9itestdb2)))
6. I tried running step 2 above and the result was:
the listener is running on port 5000 BUT
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.101)(PORT=5000)))
Services Summary...
Service "testdb2.aranetahome.net" has 1 instance(s).
Instance "9itestdb2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
************************
the reason why I've pasted the settings above (on my first post) using the command
SELECT NAME, VALUE FROM V$SPPARAMETER;
NAME VALUE
------------------------------ ------------------------------
db_domain aranetahome.net
instance_name
local_listener
db_name testdb2
- is because I am wasting a lot of my time fixing things that were messed up rather than preparing for my exam, that's WHY i posted here to seek advice.
i was thinking, maybe since the db_name and the SID are different, it might contribute to the problem.
hope i've delivered things clearly
|
|
|
|
|
|
| Re: Oracle Connectivity Puzzle [message #303995 is a reply to message #303919] |
Mon, 03 March 2008 11:16 |
kelvs
Messages: 15
Registered: December 2006
|
Junior Member |
|
|
| ebrian wrote on Mon, 03 March 2008 19:21 | Why is your ORACLE_SID set to 9itestdb2 ? Try to set your ORACLE_SID to testdb2, then re-configure your listener.ora file to:
LISTENER=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)(HOST=192.168.150.101)(PORT=5000)))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=testdb2.aranetahome.net)
(ORACLE_HOME=/oracle/apps/product/9i)
(SID_NAME=testdb2)))
|
hi ebrian,
actually, it's also a big question for me because the instance was already created when it was passed on to me. Here's what I did (for the sake of moving on ...) I created another instance here are the parameters
ORACLE_SID=orion
db_name=orion
followed the instructions above
executed step no 2 and here's the output
*****************************************************************
[kelvin@aranetahome ~]$ lsnrctl status
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 01:05:12
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.105)(PORT=5000))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 04-MAR-2008 01:01:24
Uptime 0 days 0 hr. 3 min. 48 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/apps/product/9i/network/admin/listener.ora
Listener Log File /oracle/apps/product/9i/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.105)(PORT=5000)))
Services Summary...
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
*****************************************************************
so again, we're back to the same problem, now, i waited for 3 mins then executed lsnrctl status. the result is:
*****************************************************************
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
*****************************************************************
still unknown, however, i tried to connect
*****************************************************************
[kelvin@aranetahome ~]$ sqlplus kelvin@orion
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 4 01:04:23 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
*****************************************************************
it got connected! (even if the service is UNKNOWN), i tried executing lsnrctl service
*****************************************************************
[kelvin@aranetahome ~]$ lsnrctl service
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 04-MAR-2008 01:04:43
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.105)(PORT=5000))
Services Summary...
Service "orion.aranetahome.net" has 1 instance(s).
Instance "orion", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0
LOCAL SERVER
The command completed successfully
*****************************************************************
I can see the connection has been established ... This is getting weird than I expected.
|
|
|
|
|
|
| Re: Oracle Connectivity Puzzle [message #304118 is a reply to message #304005] |
Tue, 04 March 2008 02:31 |
kelvs
Messages: 15
Registered: December 2006
|
Junior Member |
|
|
| ebrian wrote on Tue, 04 March 2008 01:55 | OK, now we are getting somewhere.
You seemed to be concerned that the status is showing 'UNKNOWN'. That is nothing to be concerned about. It's due to the fact that you have statically defined the service in the listener.ora file and it's not set to dynamically register. This is basically the listener's way of saying that the listener does not know the status of the database.
|
actually, it's not only the status am worried about but the whole connectivity because I've also tried connecting to the first instance (the one with the mismatched SID and db name) but it didn't work out. For me, getting the listener up and running with be the first step, second is to get the services registered, third - to have clients connected to the instance via service name, fourth is to have the server configured to a shared server mode.
I'll keep you updated once I've done the last stage. thanks ebrian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
