oracle Questions

java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole – CentOS

My OS = CentOS-7 Oracle 18.4 XE Java 8 JDK + Tomcat 8 I facing the following error: Exception in thread "main" java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole at oracle.jdbc.driver.DMSFactory.<clinit>(DMSFactory.java:46) at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:1713) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:849) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:443) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:712) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247)…

VIEW QUESTION

How to create sh script which will run SQL file on CentOS without sqlplus lib

May 28, 2020
Cyril Gavala
3 Answers

I'd need to create a sh script, which will connect to Oracle DB and then execute a SQL file. The problem is that sqlplus is not installed on that Cent-OS machine and most probably it won't be installed either. Is…

VIEW QUESTION

Copy table from Oracle to Redis

January 7, 2020
Puneet Purohit
2 Answers

I have one table(1 cr records) in Oracle 12g which is getting updated(from other/ETL source) everyday at 4:00 AM which is my user master table. I am using this table to authenticate my user. So simple way is get it…

VIEW QUESTION

Oracle XE dg4odbc: connecting to SQL Server doesn't work – CentOS

September 24, 2019
Roberto Capancioni
2 Answers

I can't create a DBLink from Oracle XE 18c to SQL Server 2017 Express! I have an instance of Oracle XE 18c on my server centos 7.6 and an instance of SQL Server 2017 Express, both working properly. I'd like…

VIEW QUESTION

Oracle SQL Developer Works SQLplus DOESN'T – CentOS

July 3, 2019
user3308131
2 Answers

With Oracle SQL-Developer I'm able to connect to my VMware CentOS 7 Oracle database ORCL. if I try to connect with SQLPlus I'm told the realm doesn't exist. Any idea as to why I can connect with Oracle SQL-Developer and…

VIEW QUESTION

How do I connect PHP 7.x to Oracle database on RedHat / CentOS?

June 16, 2019
DrBorrow
2 Answers

I am struggling to connect my PHP application to an Oracle database. I have tried multiple options over the last week with no success. I have managed to install oci8 extension but the oci_connect function is not recognised. Please assist.…

VIEW QUESTION

generate hmac sha1 with unicode escaped payload, oracle plsql

January 10, 2019
localmonkey
3 Answers

so i have an ORDS endpoint (Oracle Rest Data Services) that receives a JSON payload from Facebook API, and a variable, X-Hub-Signature, which comes in the header of the request. i have to validate the request i receive, so i…

VIEW QUESTION

SQL request error – Artificial Intelligence

July 31, 2017
nickkislak
3 Answers

Good evening everyone, I'm working on a assignment and can't figure out the following, I have two tables: CREATE TABLE Rental ( rental_id DECIMAL(12) PRIMARY KEY, customer_id DECIMAL(12), movie_id DECIMAL(12), delivery_status VARCHAR(64), return_status VARCHAR(64)); and CREATE TABLE Movie ( movie_id…

VIEW QUESTION

query on hr schema – SEO

March 25, 2015
ahosbet1
3 Answers

I am new to SQL and am practicing on the HR schema available on Oracle 10g XE. This is the question: Write a query to select the name, job, and salary and department number of all employees except Sales Rep…

VIEW QUESTION

Show only 2 softwares for each category – Photoshop

August 20, 2014
Nejib Neymar
2 Answers

I have a table software (id_software, software_name, category) What SQL query to show only 2 software for each category ? For example I want to get : |id_software | software_name | category| -+------------+---------------+---------+- | 1 | Photoshop | 5 |…

VIEW QUESTION