I am trying to install xi on one of my machines running on windows 2000. I selected following options during installation:
server components
new installation without sqlserver option
install tomcat
iis server option
In the next screen i am selecting oracle database and server name as localhost username scott and tiger password. After the installation it is unable to logon to cmc. I went to services and cmc service is not started when i try to start i am getting the message "unable to start windows did not return any code"
In the event log it is showing unable to connect database. database connection string error. Can anybody know how to solve this . I am trying on a stand alone system.
You need to create a BRAND NEW schema for the system database. scott/tiger login is for the demo schema. If you don’t know how to create new schema, you can ask your DBA to assist you.
First read install guide
Also check database connection by doing ping and tnsping. or via tool like toad.
GO to CCM and point to the database schema you want to use as your CMS database
Thank you for your replies. I tried creating new account on oracle and installed from xi from the begining still having same problem. Tried tnsping working fine.
In ccm everything is running except cms. I am getting "failed to retrieve cluster name from the database. Reason.unable to connect to the database using the provided connection string. Reason:ORA-12541:TNS: no listener." error if i select configuration tab in cms properties.
I checked in the services. ORAserviceora and oraclehomeoratnslistner are started. Please let me know what i have to do.
This is a connectivity issue are you running test as same user you are using in CCM? does that user has proper previalages on the database? e.g create table.
did you test by pointing CMS database to an mysql or local sqlserver DSN to test.
sfaridi i didnt get your first point how would i know which user i am using in ccm. If i got u correctly u r talking about the loginas option in cms properties . I am using systemaccount in that case.
I am not familiar with sql server. If i go for select a datasource option and select the mqis machine datasource it is asking for user name and password. i dont' konw what to enter. Can u plz let me know the admin username and password in SQLSERVER.
I am getting “failed to retrieve cluster name from database. Reason: database access failure” message when i use msqi machine data source. when i use BOE11 machine data source when selecting sql server it is running and everything seems to be fine.
But if i select oracle it is asking for server name userid and password. After entering all details it is giving error. Do you think there is problem with oracle installation. I do have 6.5 running fine on the same system with orcle database.
After entering all the details. I am getting this error “failed to retrieve cluster name from the database. Reason.unable to connect to the database using the provided connection string. Reason:ORA-12541:TNS: no listener.” With oracle database
Now it is working with oracle. I opted new data source and gave server name and oracle userid and password. After i get the message set up successful and the screen returns to configuration tab i selected change cluster name to and i gave my system name.
Now it is working well with oracle . I am not sure why it is doing like that. If i didn’t change the cluster name it is giving a message cluster name not found.
Congratulations
it must be an entery in your tnsname.ora file.
did you use the exact same name when you did tnsping as you were previously using in cms?
I have got the same problem, took a lot of time to figure it out . Here is the solution…
When you are in the CMS data source, choose specify and select oracle native driver and when prompted enter the dsn name and give the schema name/password. Select change cluster name and give your computer name and then click apply. It should be up and running… 8)
Reply to me if you need any further clarifications.
THANKS!!! I was seeing the same error, but I thought it was a port issue because the app default port is 6400 (we use 1521), so I was waiting till they opened up that port. After reading this post I decided to tinker with it and I tried it using the dsn instead of the server name and low and behold…IT WORKED!
(BOB member since 2004-01-16)
(BOB member since 2002-08-29)
(BOB member since 2004-01-09)
(BOB member since 2004-07-16)
. Here is the solution…