Questions tagged [oracle-database]
The oracle-database tag has no summary.
107 questions
3
votes
0
answers
35
views
OracleDB: Encrypt Connection Descriptor In Network Communication
I have recently dumped the network traffic from my application server that talks to my Oracle database server.
I configured the Oracle DB server to encrypt the data using TLSv1.2 when sending over the ...
- 165
1
vote
1
answer
510
views
Why is ulimit -l (max locked memory) value 64?
I am trying to prepare the server running Oracle Linux 8.8 for Oracle database 19c installation.
I installed oracle-database-preinstall-19c.rpm and noticed that ulimit -l value is showing unexpected ...
- 41
0
votes
1
answer
779
views
Trouble Installing Oracle 19c on Oracle Linux 9
I am following a tutorial to install Oracle 19c on Oracle Linux 9.
If I run the installer (runInstaller) as a non-root user, I get a permissions denied error. But if I run it with sudo, I get Oracle's ...
0
votes
1
answer
372
views
Python module not available to another user in same group
Both users foobar and foobiz are in same group on RHEL.
foobar$ python3 -m pip list
Package Version
----------------- -------
oracledb 1.4.2
pip 21.3.1
foobiz$ ...
- 393
0
votes
0
answers
76
views
Binary file with field seperator ^A is not loading using SQLLDR
I'm trying to upload .dat file to Oracle DB using SQLLDR.
File data columns are separated by "^A".
File charset is of binary.
bash-4.4$ file -i /tmp/t_details_all_data_20240209.dat
/tmp/...
- 239
0
votes
0
answers
2k
views
Installing oracle-database-preinstall-21c - Oracle Linux
I am completely new to the Linux world. I am following a course on Udemy and trying to install the Oracle database on Oracle Linux 9.1.
One of the prerequisites is to run the following command:
dnf ...
- 101
0
votes
1
answer
166
views
How to debug StoreOnce Oracle RMAN plugin on HP-UX?
We have an old Oracle 10g database on old Itanium machine (BL870c i2) which is running HP-UX B.11.31 (it appears to be latest version). Also we have a StoreOnce 3640 (s/w version 4.2.1-1942.21, which ...
- 1,779
0
votes
1
answer
4k
views
Error installing oracle 19c database pre-install on oracle linux server 7.6
I'm tryin to install oracle 19c on oracle linux 7.6, I'm required to install oracle 19c preinstall , knowing that this is a fresh install I don't understand why i'm getting these errors :
yum -y ...
0
votes
0
answers
115
views
Count read, rejected and discarded data from CSV
So for example, I have tried inserting 9 columns in the oracle sql table.
Table ACCOUNTREQUEST:
7 Rows successfully loaded.
2 Rows not loaded due to data errors.
I want to create a echo.txt or .log ...
0
votes
0
answers
370
views
What is missing from these Oracle Solaris 11.4 firewall rules to allow traffic
I am trying to reach a separate, in-house application server from our Solaris server. The only firewalls that exist between these two are the native firewalls.
We have set the following rules on the ...
- 1
0
votes
1
answer
406
views
How to distinguish between a oracle database installation and oracle client installation
hello experts,
I have a bash script to execute which when executing on a oracle database server will do things like reading some files , and populating some tables but if same is executed on a oracle ...
- 21
0
votes
1
answer
318
views
ORA-01017 from sqldeveloper but ok from sqlplus
I've logged into Oracle 19c via sqldeveloper as sys and created a new user
-- USER SQL
CREATE USER data_owner IDENTIFIED BY "password!"
DEFAULT TABLESPACE "USERS"
TEMPORARY ...
- 125
0
votes
1
answer
100
views
Can I install an Oracle DB on a Solaris 10/11 VM (not sparc)?
I have Solaris machines (10/11) which are running on VMware and I am intending on installing a DB on them.
Can I install on Oracle DB if it's not on sparc? if so- where can I find instructions?
If not-...
- 101
1
vote
1
answer
17k
views
I try to install Oracle 19 on CENTOS 8 GUI by run vncserver and X11
I try to install Oracle 19 on CENTOS 8-GUI by using vncserver and X11.
When I try to run this ./runInstaller, I got this ERROR: Unavale to verify the graphical display setup. This application requires ...
- 31
0
votes
1
answer
81
views
Pass Linux variable in Oracle script
How to pass Linux variable in Oracle code?
I need to pass it in below format and it should not ask for "enter a value for 1:"
Please advise.
mount='/u08/dbname/'
sqlplus -s "/ as sysdba&...
- 1