I have a real case, it would be of great help if someone could help me solve it.
I have installed webM 7.1 IS & a Oracle 10G XE edition database. I have not done any configurations in that. I just created a administrator user with full access.
Case:1
While i enable the create tablespace and give the admin password, it says invalid credentials, logon denied, but i am pretty sure that the user name and password is correct and without any special characters. when i remove that option of creating tablespace, it gives me an error saying that WEBMDATA and WEBMINDX or so doesnt exist. so i installed a SQL developer and created those two tablespaces, after that some components got installed or created, and again i am getting error some COMPONENT_ID is missing in some tracking sql file-cannot insert null, so i went to all those files and added a column component_id and a dummy value 1. Now it gives me a variety of new errors.
Does someone know the process to be followed to get it configured and functional ?? if you have some docs, you can also mail it to girish87@gmail.com, i went throught the standard installation doc of webM but could resolve it.
Girish, What exactly you trying to configure?
To configure DB, DB user should have Administrator access.
While installing installer ask for DB details and configure the JDBC pools during installation time. In 7.1 we have DB configurator as well, if you run this it will take care of configuring tables for all components.
I guess this should solve your problem. In case you are looking at some different kind of information, please provide the exact details where you facing the issue or in which step, which tool you are facing the issue.
Thank you
hey mangat, hope ur doing well, regarding the query:
The DB user ofcourse has the administrator access. But still it is not working.
I am using the Database configurator of 7.1 only in which there is an option to check the create tablespace checkbox, i did that but it is not able to create the tablespace saying invalid credential or so. But i am sure its the correct credential. seems little strange but even i am lost of such error.
i have heard many complaints of this problem with oracle 10G XE (ligght edition), any idea ?
Hi, I have installed and reinstalled oracle10g 3 times in the last 6 months on a windows Vista system. I configure via DbConfigurator and start webMethods correctly with configure dbpools and start and view trading networks. However when I restart the computer for some reason all connections and configurations to the database appear to be lost, it has lost all the connections to the database pools in the integration server and cannot even connect to show catalog or print via the configurator. I have posted a question asking for another free database that can be used. I have spent to much time with Oracle10g, please don’t make the same mistake. Life is to short
Finally after installing the full version of Oracle 10G R2. And a manual configuration for file_create_dest intialization parameter in the database. The Database Component Configurator 7.1 ran successfully.
I created the JDBC pools and associated it, the test was successful again. When i checked the error log, audit log, it was working. But after sometime to my surprise, it gave errors that “Oracle exception,table or view does not exist”
Then i tried to start MWS in cmd mode, it starts so many internal components but after few lines, it says “Invalid Database Schema specified.” I have no clue as all the schemas should ve been created automatically and i dont understand why is it invalid.
Since you claimed that DB configuration ran successfully… i m considering it was … what all the components you configured there…
Please cross check if you have done the above activity for MywebmethodsServer, this is one the database component available to create from DB configuator tool… once it is done… set the DB properties in db.xml file (location : WM installation dir\MWS\server\default\config).
Set the properties depending upon the DB type you have and then try.
revert back… if you still find any issue.
I had already tried that even But anyways Thanks for your very closest and relevant reply. Infact i had tried to check the config of that file even during installation, i found something suspective there. Thats the reason i did a reconfigure of dbconfigurator for MWS only. After tht it looked better, but still a segment had repeated twice which is still suspective. I have messed it up trying to manually correct it with no use.
May be i think i forgot to drop and create while doing it again for MWS. Let me try that once again and update u with the proceedings.
hi, sorry for the delay. I had upgraded to a new system with windows 7 64 bit, the IS seems to work fine, but again the same invalild schema issue when i start the MWS. The Database configurator is successfull for all components. Also when i run the tests for JDBC pool that was created automatically with my database is successfull. But in the error log, i see table or view does not exist.
Is there any specific jar files or drivers to be installed for it to function ?
which table does error log in the database normally ?
luck doesnt seem to favour me still when i try the catalog i get the following error.
Database Connection error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
although i have specified the url as jdbc:wm:oracle://127.0.0.1:1521;SID=xe;sysLoginRole=sysdba
but it is not taking into effect the part sysLoginRole=sysdba, no idea why.
And then, i think my database schema problem is related to the character set encoding, i think for oracle it should be AL32UTF8, and this should correspond to the parameter NLS_LANG but i have only NLS_LANGUAGE parameter which is currently set to AMERICAN and i am struggling to get it changed.
Can u think if something strikes after reading the above updates pls