I execute the following query which returns one value and it works fine. The issue is that when the one value returned is too large it gets split in multiple rows thus the ETL tool that I further use gets problems. Therefore I have tried to use the linesize option but I am not able to combine it with the
Tag: oracle
Cx Oracle ‘TNS could not resolve the connect identifier’
I am connecting to an Oracle DB using LDAP and the Python cx_Oracle library. I have proper sqlnet.ora, ldap.ora and tnsnames.ora files. On my Windows machine everything works fine using the 12.1 Oracle client and the following Python code: I have installed the Oracle instant client 12.1 on my Linux machine (Debian) following the zip file installation method advised on
cannot call sqlplus from linux where password contains $ dollar sign
I have spent hours trying various suggestions and combinations but for the life of me cannot get a call to sqlplus from direct linux command line or from a bash script to work with a password containing a $ I have tried these I have tried the same as above but putting before the $, and various other attempts
How to pass parameter of oracle sql script file to sqlplus from shell prompt?
Objective: To invoke sqlplus with sql script file path as parameter from shell prompt Scenario: logged in as root and would like to execute the sql script file as oracle Command: Expected: sql commands in createschema.sql are to be executed Actual: getting only sql prompt Also, tried: a) b) whenever sqlerror exit sql.sqlcode; set echo off; set heading off; /tmp/downloads/oracle/instl/script/createschema.sql;
how to get a popup when someone has connected to particular database
Is there any way i can write a script to get a popup as an email that some x user has connected to a particular database Scenario: there was an “X” database and if some “ABC” user has logged into that database by using some account user id and password , an email should be triggered to some contacts :
How to connect Azure Web App througt a Hybrid Connection to Oracle Linux
I was looking for the way to connect my Azure Web App using a hybrid connection to my On Premise Database server, Oracle Linux. Any suggestions? greetings. Answer Unfortunately, Hybrid Connection Manager does not Support for Linux. The Hybrid Connections feature requires a relay agent in the network that hosts your Hybrid Connection endpoint. The reply agent (HCM) is not
Can not install Oracle database in Linux 7
I am trying to install Oracle database to Linux machine.I am getting error down below Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<< I run commands down below but it still returns error. What should I do? Linux Version Oracle Db Version 12.2.01 Answer This should do the
Containerized spring boot application with oracle database resetting connection
I am having a problem with a containerized spring boot application using oracle database. I successfully build my image but when I run it using docker the application gets stuck on getting a connection pool. The application runs with a connection reset exception and if I try to connect on it I get another connection reset exception, but if I
remove oracle user without uninstalling oracle ubuntu16.04 [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question
OBIEE 12.2.1.2 – Interface customizations
I am facing problems with interface customizations in the latest OBIEE release. Is it possible to “hide” the Mobile, VA and BiPublisher options – marked red in the appendix. (Privileges in Administration and roles in EM are configured – users can not access Mobile, BiPub however the buttons are still visible – OBI 11 did not display them afterwards…) I