Confserv / dbserver on Oracle - where does dbserver get the ORACLE_HOME value?

[mark]

A question for those with some Oracle knowledge I think!

In dbserver logs we can see a reference to oracle home, where is this value picked up from?
We have changed the ORACLE_HOME location in both 'env' and .profile, yet DBserver gives the value of the pre change oracle home - even after a restart of dbserver and confserv.

Any ideas?

Mark

[Sylvainsjc]

I never seen this (dbserver with oracle on solaris or Aix or Linux)
Mark can you copy the log part where you see a reference to oracle_home ?

[Fra]

Mark,

which OS are you running? Have you set beside ORACLE_HOME also ORACLE_SID and PATH variables?

[mark]

Fra - I have no idea on ORACLE_SID, would it be in env or .profile (of which I cannot see it in either), PATH has been set.
Running Solaris with an Oracle 8.1.7 DB (tried to upgrade to 10g on the weekend)

Sylvain -

On startup, after LCALayer: REventRegistered on LCA..

04:35:25.779 Dbg 10739 Unknown: id='' req='-1' ORACLE_HOME is '/oracle01/product/8.1.7/64/a'.

Mark

[Fra]

Mark,

I'm sorry but I don't know where ORACLE_SID is but it must be set to the default SID for your database; and in addition to that, LD_LIBRARY_PATH variable should be set to $ORACLE_HOME/lib.

Hope it helps,

Fra

[mark]

Will have to ask one of our DBA's about ORACLE_SID then. LD_LIBRARY_PATH is set.

Mark

[mark]

There are SID's set in tnsnames.ora, if that counts!

[Sylvainsjc]

Can you give us the result of the command "set" ?
You have set also confserv.conf with the ORACLE_SID value ?
Have you tried the command tnsping ? Example : if SID=CTI75 the "tnsping CTI75"

[exchelente]

In the log row you sent, looks like ID is missing?

Unknown: id=''

Did you set oracle_home/bin in your path?

[René]

Hi Mark,

I'm not 100% sure but... Starting Genesys application using LCA means that the application is going to be started under the same user/profile as LCA is running. So you have to restart LCA in case of modification of user's profile. Otherwise the changes in the profile won't be applied.

René

[mark]

[quote author=Sylvainsjc link=topic=2574.msg10002#msg10002 date=1194882221]
Can you give us the result of the command "set" ?
You have set also confserv.conf with the ORACLE_SID value ?
Have you tried the command tnsping ? Example : if SID=CTI75 the "tnsping CTI75"

[/quote]

confserv.conf does not have ORACLE_SID set, it also is not set in our pre-prod environment, where outbound dialling works fine.
tnsping returns ok.

[mark]

[quote author=René link=topic=2574.msg10008#msg10008 date=1194883667]
Hi Mark,

I'm not 100% sure but... Starting Genesys application using LCA means that the application is going to be started under the same user/profile as LCA is running. So you have to restart LCA in case of modification of user's profile. Otherwise the changes in the profile won't be applied.

René
[/quote]

A good point, we did do a full shutdown after the 10g upgrade just to make sure. I will have a play in pre-prod to see if values change after an LCA restart.

[quote author=exchelente link=topic=2574.msg10003#msg10003 date=1194882326]
In the log row you sent, looks like ID is missing?

Unknown: id=''

Did you set oracle_home/bin in your path?
[/quote]

we see the same in pre-prod 'Unknown: id='' req='-1'' yet it still returns the ORACLE_HOME value and outbound works fine.

Mark

[Sylvainsjc]

Mark,
as far as i known (and you can see this in the framework configuration option reference manual), the listener service (SID) is to be set in the confserv.conf (option dbserver=SID).
Is there another way for config server to reach a database

dbserver
Default Value: No default value
Valid Values: Any valid entry name
Changes Take Effect: After restart
Specifies the name or alias identifying the DBMS that handles the
Configuration Database. The value of this option is communicated to
DB Server so that it connects to the correct DBMS:
• For Sybase, this value is the server name stored in the Sybase interface file.
• [u][b]For Oracle, the value is the name of the Listener service.[/b][/u]
• For Informix, this value is the name of SQL server, specified in the
sqlhosts file.
• For Microsoft SQL, set this value to the SQL server name (usually the
same as the host name of the computer where Microsoft SQL runs).

[mark]

[quote author=Sylvainsjc link=topic=2574.msg10021#msg10021 date=1194946728]
Mark,
as far as i known (and you can see this in the framework configuration option reference manual), the listener service (SID) is to be set in the confserv.conf (option dbserver=SID).

[/quote]

dbserver is set in confserv.conf and works fine, we would experience other issues more prominent than not outbound dialling otherwise hehe

I thought you were saying you need to set a new value of ORACLE_SID :]

Mark

[Sylvainsjc]

Sorry mark but my english is poor... Is your problem about starting configuration layer and accessing configuration database or outbound dialing
Yes i was saying the need to set the value of ORACLE_SID for dbserver option in confserv.conf