Splunk Search

Why am I getting errors writing a query after installing Splunk DB Connect and connecting to Oracle database?

gajananh999
Contributor

Hello,

I have installed splunk db connnect app and connecting to oracle database i am trying to write query
select * from etl_job;
i am getting this error can anyone please help me

command="dbquery", A database error occurred: ORA-00911: invalid character

Thank

Gajanan Hiorji

Ayn
Legend

I imagine the semicolon (;) shouldn't be there?

0 Karma

gajananh999
Contributor

I am doing a database query in database Query tab. and my query is "select process_flag from etl_job"

0 Karma

gaikarmayur
New Member

use below format

| dbxquery query="(your db query)" connection="(nameof DB Connection)"

use command dbxquery remove ( ,) after dbxquery

0 Karma

Ayn
Legend

Exactly how does your complete search string in Splunk look?

0 Karma

gajananh999
Contributor

I have tried that also but no luck here is the another error
command="dbquery", A database error occurred: ORA-00923: FROM keyword not found where expected

0 Karma
Get Updates on the Splunk Community!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...