Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: mark on November 12, 2007, 01:02:04 PM
-
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
-
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 ?
-
Mark,
which OS are you running? Have you set beside ORACLE_HOME also ORACLE_SID and PATH variables?
-
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
-
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
-
Will have to ask one of our DBA's about ORACLE_SID then. LD_LIBRARY_PATH is set.
Mark
-
There are SID's set in tnsnames.ora, if that counts!
-
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"
-
In the log row you sent, looks like ID is missing?
Unknown: id=''
Did you set oracle_home/bin in your path?
-
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 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.
-
[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
-
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).
-
[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
-
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
-
The issue is with outbound dialling, starting the config layer is fine, everything works except outbound.
-
Hello Mark,
René provided again the correct answer with lca. I was also asking me how SCI could start applications with necessary environment variables on Unix.
I found this on DBserver User's Guide :
[i]Note that when you start the DB Server through the Management Layer, the server inherits environment variables from the Local Control Agent (LCA) component, which executes the startup command. That means you must also set the environment variables required for DB Server for the account that runs LCA. See Chapter 2, “DBMS Environment Settings,” on page 19 for more information.[/i]
Was this your problem ?
-
Nope, it's a completely unrelated problem.
Oddly, starting the dbserver from command line also gave the same ORACLE_HOME, which is where our confusion laid.
The actual resolution to the main issue has still not been solved and chances are we will need to perform the 10g upgrade again in our prod environment just to see if we can replicate the issue!
Nightmare.
Mark
-
Mark, could you post your .profile so we can take a look? I used to do a lot of unix and our Oracle DBA hid his information in a file used by the .profile. So if you look at the .profile you never would see the Oracle reference. But if you looked close you could see the reference.
thanks,
AsT
-
Issue was actually nothing to do with the oracle profile!
installing another instance of dbserver for outbound (which is out of scope..) solved the issue.
Weird!