It might be a silly thing for Siebel giants but it cost me my full day….What I was trying to do:
I need to Check In my new objects to dev server.
I need to Check In my new objects to dev server.
Steps I followed:
1.) Made TNS entry in TNSNAMES.ORA file
2.) Create a new ODBC entry
3.) Replace ODBC name in CFG file
Lets go into details….
How to make TNS entry
Go to Oracle Home: D:Oracleproduct11.1.0client_2networkadmintnsnames.ora, copy or modify TNSNAMES.ORA file. Make your server entry in this file as below:
TESTSVC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ##)(PORT = ##))
(CONNECT_DATA =
(SERVICE_NAME = TESTSVC)
)
)
How to create new ODBC entry
Go to Administrative Tools -> Data Sources (ODBC).
Go to System DSN, create a new entry for Siebel Oracle 90. say it DEV.
 |
| ODBC Entry |
What changes need to do in CFG file
Go to tools.cfg and make changes in below section:
[Siebel]
ServerDbODBCDataSource = DEV
It is the ODBC name what we created in last step.
[DataSources]
DEVServerDataSrc = SERVER
[DEVServerDataSrc]
ConnectString = DEV
TableOwner = SIEBEL
Thats all to connect to server, I have Test Connection successfully from new ODBC entry.
What is the new problem
I am not able to Check In my new objects on server. When I select object to Check IN, Check In button disabled for me.
Root Cause
After wasting my full day on this, one of senior colleague told me that when we create a new ODBC entry we need to make its parameter entry in registry itself.
Well I don’t what are those parameters and how to make entries in registry. So, finally we came to conclusion that we need to use existing one SSD Default instance.
Now it works fine for me, I can Check In – Check Out successfully.
But I know its not a full proof solution, what if we need to create one more entry ???
I need to find this answer…………
Thanks for subscribing to SimplySiebel.
3 comments for “Unable to Check In – Check Out in Siebel Tools”