topic Re: Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied in Security

Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied

vikas_gopal — Mon, 09 Dec 2013 11:49:21 GMT

Hi Guys,

I am new to SPLUNK.

I am trying to connect to a Oracle database using SPLUNK DB .While Velidating database connection following error occurs "Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied".

Please help

Re: Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied

martin_mueller — Mon, 09 Dec 2013 12:04:26 GMT

Are you sure the user is called EDREPROT and not EDREPORT?

Re: Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied

vikas_gopal — Mon, 09 Dec 2013 13:05:01 GMT

Thanks for your responce Martin, yes user name is correct it is EDReprot only as after changing in the setting with EDReport , SPLUNK shows an error "Error connecting to database: java.sql.SQLException: ORA-01017: invalid username/password; logon denied".....As per my understanding somethign is wrong with the DB connect ...please correct me if I am wrong , I have just placed ojdbc6.jar file in the $SPLUNK_HOME/etc/apps/dbx/bin/lib directory .That is it or still I need to install or download something ..?

Re: Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied

pmdba — Wed, 18 Dec 2013 05:09:01 GMT

There is nothing wrong with your connect settings. Rather, this error is proof that you are connecting to the database. The problem is that the database account has not been correctly provisioned. It lacks at least one key privilege (create session). It may be missing others as well. Check with your database administrator to make sure the account is correctly configured to meet your needs.

Re: Loading...Encountered the following error while trying to update: In handler 'databases': Error connecting to database: java.sql.SQLException: ORA-01045: user EDREPROT lacks CREATE SESSION privilege; logon denied

vikas_gopal — Wed, 18 Dec 2013 11:10:14 GMT

Thanks,

You are right this user does not have the privilege to cerate the session .I am in touch with my DBA.Thanks!!