All Questions
Tagged with connection oracle
304
questions
0
votes
0
answers
35
views
Call PL/SQL from JDBC has different behaviour with OracleConnection and Connection
I need to change package variable using JDBC and get new value back.
Oracle package:
create or replace package test_pkg
as
test_num number := 10;
end;
When I do it via java.sql....
0
votes
1
answer
69
views
Connecting from the outside to oracle in docker container giving issues
I'm in need of an explanation for this issue I have.
I installed a docker container with oracle 19 on my Mac with M1 processor following this guide: https://itnext.io/oracle-on-arm-mac-m1-m2-docker-...
0
votes
2
answers
47
views
Cannot connect to an Oracle XE database from C#
The connection keeps timing out in this C# code:
private const string _connectionString = "User Id=c##BookingApp;Password=ftn;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=...
1
vote
1
answer
23
views
Powershell Oracle connection using SecureStore
I need to be able to run a script and get the Get-Secret and run $sqlQuery on same line
This works:
Get-Secret -Vault DBASecretStore -Name dbautil -AsPlainText | sqlplus dbautil/
But I need to be ...
0
votes
0
answers
17
views
connection tab does not appear [duplicate]
I installed Oracle SQL Developer. But when i want to create a connection , the tabs does not appear. I tried all the ways but none of them worked. Could you please direct me or give me an advice.
...
0
votes
0
answers
27
views
Python Class Instance in MultiProcess giving error when it contains DB connection
import oracledb
import getpass
import pyodbc
import multiprocessing
from datetime import datetime
def insertInOracle_worker(test):
print(type(test))
if __name__ == "__main__":
...
0
votes
0
answers
43
views
Node.js connecting to Oracle via only oracledb on production server
Works great on dev machine.
Copy application to server and it doesn't connect.
i am using built in oracledb functionality so don't need the Oracle ODAC with it's TNSnames.ora file. (in fact i locally ...
0
votes
0
answers
176
views
How to resolve issue I am getting while creating oracle connection in SSIS project?
I am creating one SSIS project where I am supposed to fetch data from my sql server dev environment to my local oracle server.
I tried creating oracle connection with the help of OLEDB DB Source's ...
0
votes
0
answers
194
views
How can I connect to Oracle database by ConnectorX Python
I am trying to connect Oracle database by ConnectorX Python
When my database has 1 server 1 port, I can connect normally. But when my database have many server and many port. I don’t know how to ...
-2
votes
1
answer
529
views
Error - JDBC Connection issue - unable to acquire
11-08-2023 06:10:03.380 [ERROR] [biller-connect] com.billdesk.service.BillerConnectCRRMServiceImpl | traceId=PP012308110440256981807957132230440_fetch, bbpsTxnId=null, requestType=FETCH, billerId=...
0
votes
0
answers
419
views
I am unable to create a connection in Oracle Sql Developer in Macbook air m2
An error was encountered performing the requested operation:
IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ttQn+vElQMiIMuRuCPEntw==)
Vendor code 17002
i am unable to ...
0
votes
1
answer
1k
views
Using Ansible how to connect Oracle DB on Linux & run command "show pdb" to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB
Using Ansible how to connect Oracle DB on Linux Machine to use commands "show pdb" to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB. please guide.
I ...
0
votes
1
answer
924
views
I have successful connection to oracle database through python using cx_oracle but I couldn't connect to the database using sqlalchemy
import cx_Oracle
import sqlalchemy
import pandas as pd
from sqlalchemy import create_engine
hostname = r'myhost'
port = '0000'
sid = 'ssss'
username = 'myusername'
password = 'mypass'
...
0
votes
1
answer
613
views
Tomcat connection to Oracle via TCPS: The Network Adapter could not establish the connection
I have a document management system as a Tomcat servlet with a separate config.xml.
The DMS system needs a database for correct functionality. In this case an Oracle 19c.
I want to encrypt the ...
0
votes
0
answers
95
views
How to connect to an oracle database securely ? How to avoid clear text passwords?
I am developing a php application but my password is in clear text when I connect to my oracle database.
Is there a solution to avoid this?
$login = '..';
$password = '..';
$db= '..';
$conn= ...