Please check wheather the Oracle Listner is running or not by using following command.
lsnrctl status(if it shows up any instances then its ok or please reboot your machine and again brign up database and Listner)
If you are not able to connect DB, please start it as sysdba as follows:
sqplus username as sysdba
and then again start Listner
then give try to install your ITSM suite(I hope you are already installed ARS and Atrium).
If it is still giving the error then as per my observation seems to be the issue with Character set. For this you need to re-install oracle and choose System class while installing it and then you see some advanced configurations and Character Set option in that you can select third radio button and then in the list you can select LAN-AL32UTF8 and then proceed.
After this you need to re-install ARS, ATrium and then ITSM.
Thanks for the response, I am quite sure that this is not a connection issueas I have checked several times before starting the installation. As to theCharacter Set you mentioned, that could be one the issues and I am going to tryand let you know the results. But what really puzzles me most is that I am ableto do the installation of ARS and ITSM without any problems. This only arisesif I am using Stack Installer. Besides, if you check the log I am also gettingduplicate index error messages. So I believe this issue is not only aboutcharacter set though that could be one of them.
Some times the database should shows up and also it shows up the Listner is up only but it should through an error message because while installing database some files have been missed.
If you are doing fresh installtion and if it is VM(Linux box) please format the box and start installtion. Because if you un-install(remove the all oracle relaetd files) even it should not success some times due to some fiels missing related Oracle in the VM box
As you mentioned, you would install Atrium core before procedding the ITSM.
And also while installing Oracle please set all kernel parameters and install all necessary rpm pacckages and also set all env variable in .bash_profile and /etc/profile. After setting you can run these two profile by using following commands
. .bash_profile and . /etc/profile
Thanks a lot for your help Raju I was able to resolve theissue.
Here are the steps I followed:
- - On a clean Windows Server R2 Enterprise, reinstalledOracle, selected Character set (Unicode – AL32UTF8)
- - Changed NS_LANG from AMERICAN_AMERICA.WE8MSWIN1252 to AMERICAN_AMERICA.AL32UTF8on the Registry of the database server