Hi,
It is true that development and testing was done on Oracle10g2, but it is
strange this to affect the logging process. Really the DB admin job is
pretty nit-picking job by you can check a few things more:
- check if this is a cases sensitivity issue.
- check if the oracle service has a public name in long format (like:
ORCL.myserver.dom). If so - you should mention the full name in the
configuration file too.
About the Oracle Express: There is an easy solution to that:
- Open the "<KIM_HOME>\config\document.repository.rebuild" configuration
file
- Change the parameter "com.ontotext.kim.KIMConstants.COREDB_EXTENDED_QUERY"
to false
- Then start KIM with the command "startKIM_RebuildIndex"
This will force KIM to use only reduced set of schema elements which are
available to Oracle Express
Good Luck!
DanKo
----- Original Message -----
From: <[email protected]>
To: <[email protected]>; <[email protected]>; <[email protected]>
Cc: <[email protected]>
Sent: Monday, June 29, 2009 12:43 PM
Subject: RE: [Kim-discussion] CoreDB: Issue connecting to Oracle
Hi Danko,
Thanks for getting back to me.
The answer is yes to all three questions. As I mentioned, I can connect
to the database with no problem using my own java class and the ojdbc
jar file.
I'm wondering if the problem is that I'm using Oracle 11g or using a 64
bit version of Oracle.
I also tried using Oracle express eddition 10g. I can connect to that OK
but when it tries to create the necessary tables, KIM complains that
partitioning is not enabled. It seems that Oracle express doesn't
support partitioning.
I'm trying to find an instance of the full edition of 10g and am hoping
that will solve the problem. Any help appreciated.
Regards,
Alistair
Alistair Duke
Next Generation Web Research
Centre for Information & Security Systems Research
BT Innovate
___________________________
Office: +44(0) 1473 608192
Mobile: +44(0) 7730 426257
Fax : +44(0) 1473 606755
Email: [email protected]
This email contains BT information, which may be privileged or
confidential.
It's meant only for the individual(s) or entity named above. If you're
not the intended
recipient, note that disclosing, copying, distributing or using this
information
is prohibited. If you've received this email in error, please let me
know immediately
on the email address above. Thank you.
We monitor our email system, and may record your emails.
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no: 1800000
-----Original Message-----
From: DanKo [mailto:[email protected]]
Sent: 29 June 2009 09:18
To: Duke,AK,Alistair,CXR3 R; [email protected]; [email protected]
Cc: [email protected]
Subject: Re: [Kim-discussion] CoreDB: Issue connecting to Oracle
Hi Aliastar,
We are very sorry for our delay!
Could you please check a few thing in your Oracle setup:
1) Is the name of your Oracle service named:
ORCL
2) Is the user created by you named:
KIM
3) Is the user's password set to:
password
Thanks in advance for your efforts!
Greetings
DanKo
Senior Dev. KIM
----- Original Message -----
From: <[email protected]>
To: <[email protected]>; <[email protected]>
Cc: <[email protected]>
Sent: Tuesday, June 23, 2009 1:23 PM
Subject: [Kim-discussion] CoreDB: Issue connecting to Oracle
> Hi again,
>
> I'm trying to use the CoreDB feature of KIM but I'm having a problem
> connecting to the oracle database. I've created a new user and
> tablespace and pointed KIM at it using the following settings:
>
> com.ontotext.kim.KIMConstants.DOCUMENT_REPOSITORY_TYPE = coredb
>
com.ontotext.kim.KIMConstants.COREDB_CONNECTION_STRING=jdbc:or
acle:thin:
> @//localhost:1521/ORCL
> com.ontotext.kim.KIMConstants.COREDB_USER=KIM
> com.ontotext.kim.KIMConstants.COREDB_PASS=password
>
> However, when I run KIM I get the following error:
>
> Attempt to get connection failed due to: ORA-01017: invalid
> username/password; logon denied
>
> And after a few attempts the user account gets locked. The
fact that I
> can then unlock the KIM account and see the error revert to
ORA-01017
> seems to indicate that the connection string and user details are
> correct.
>
> I've tried connecting via my own java class using the same
jar file that
> KIM uses (ojdbc14-10.2.0.4.0.jar) and it connects with no problem.
>
> I'm running Oracle Enterprise Edition Release 11.1.0.6.0 - 64bit.
>
> Hoping you can help.
>
> Regards,
>
> Alistair
>
> Alistair Duke
> Next Generation Web Research
> Centre for Information & Security Systems Research
> BT Innovate
> ___________________________
> Office: +44(0) 1473 608192
> Mobile: +44(0) 7730 426257
> Fax : +44(0) 1473 606755
> Email: [email protected]
> This email contains BT information, which may be privileged or
> confidential.
> It's meant only for the individual(s) or entity named
above. If you're
> not the intended
> recipient, note that disclosing, copying, distributing or using this
> information
> is prohibited. If you've received this email in error, please let me
> know immediately
> on the email address above. Thank you.
> We monitor our email system, and may record your emails.
> British Telecommunications plc
> Registered office: 81 Newgate Street London EC1A 7AJ
> Registered in England no: 1800000
>
> _______________________________________________
> Kim-discussion mailing list
> [email protected]
> http://ontotext.com/mailman/listinfo/kim-discussion
_______________________________________________
Kim-discussion mailing list
[email protected]
http://ontotext.com/mailman/listinfo/kim-discussion