Questions tagged [oracle]
The oracle tag has no usage guidance.
85
questions
0
votes
0
answers
19
views
Mailx call in shell script suddenly sending blank messages
Similar to what was reported in posting, MAILX sends an email but with a blank subject and body text, I have an Oracle EBS 12.2 server that's using a concurrent program (java) to invoke a shell script ...
- 1
0
votes
1
answer
31
views
Cannot use SSH via internal IP address but can ping it easily
I have this setup in Oracle Cloud Infrastructure ...
I have two networks ..
Network 1:
internal cidr: 192.168.1.0/24
public IP: 10.0.0.1
Network 2:
internal cidr: 192.168.2.0/24
public IP: 10.0.0.2
...
- 101
0
votes
1
answer
73
views
Container - Id is shown as 2000
I installed Oracle Container using the image: oracleinanutshell/oracle-xe-11g:latest - on a Linux machine.
While doing, I copied one .sql file into /docker-entrypoint-initdb.d using "volumes"...
0
votes
1
answer
134
views
Boot broken on an Oracle VPS with msg "Gave up waiting for root file system device" & empty fstab
I'm using a free-tier Oracle VPS running Ubuntu and it seems like booting no longer works. I don't have physical access to the machine so I can't really try out solutions that ask for a reboot while ...
0
votes
0
answers
71
views
How to get GUI application to run on the cloud?
How to run Blender GUI on headless Oracle Cloud through VNC?
The compute must be VM.Standard.E2.1.Micro (AMD processor) or VM.Standard.A1.Flex (ARM processor). Both can be tried on their free tier. I ...
- 376
0
votes
1
answer
49
views
What determines UMASK for Oracle Job using UTL_FILE?
A PL/SQL job foobar622 writes files to UNIX/LINUX server using the following Oracle file I/O commands:
UTL_FILE.FILE_OPEN
UTL_FILE.PUT_LINE
UTL_FILE.FILE_CLOSE
In the past the files had these ...
- 331
0
votes
0
answers
213
views
/etc/named.conf error with command systemctl status named.service
I am using Rocky Linux 8.7 on 64-bit
I am configuring and trying to start a BIND domain as follows:
[root@dbwr1 ~]# ls -l /var/named/localdomain.zone
-rw-r-----. 1 root named 506 May 14 19:29 /var/...
- 1
0
votes
0
answers
105
views
Oracle Linux 8.x - Performance Test (Stress / Load / IO / Network Usage / Memory Usage)
I want to do performance test on Oracle Linux 8 KVM guest server (It will be used as Application server (WLS 14c) and/or Oracle DB server).
What are the best tools I can provide this with? I saw an ...
0
votes
0
answers
36
views
Danted proxy working with curl but not with anything else
I been trying to setup Dante proxy socks5 on oracle cloud ubuntu instance
Distributor ID: Ubuntu Description: Ubuntu 20.04.6 LTS Release:
20.04 Codename: focal
My danted config:
...
- 1
0
votes
0
answers
18
views
RMAN backup restoration
restoring datafile 00091 to /u02/oradata/hfd1/user/def04.dbf
Channel ORA_DISK_1: reading from backup piece /orac/backups/monthly/hfd2_rman_backup_monthly/rman_backup_04042023/HFD2_DB_bvlopk46_14719_1
...
- 2,732
1
vote
1
answer
49
views
Help with Folder permission problem with Oracle DB 7 and Solaris 7
I was wondering if anyone else has come across this issue with Solaris 7 and Oracle Database 7, I set the permissions of the folder as such chown -R oracle:dba /opt/oracle
but when trying to install ...
- 13
0
votes
2
answers
4k
views
How to write a shell script to run a sql query and send the query results in table format in email?
I need to run a SQL query using SHELL script in PUTTY and send the results in email body in table format with headers along with a message line on top.
I have written this so far but I am not able to ...
0
votes
1
answer
819
views
Error in PREIN scriptlet in rpm package
I'm stuck with a problem when I try to install a local .rpm packages.
Error message:
Total size: 124 M
Installed size: 124 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
...
- 137
0
votes
0
answers
105
views
Mismatch in the SID being used and that is causing the problem in connecting to DB
So i have error in Oracle Fusion Middleware, and server listen OSBPDB Service Name, but i need to change to listen on XEPDB1. How to do it? Does anyone know?
Error is
oracle.security.jps.JpsException: ...
- 1
0
votes
0
answers
59
views
sqlplus - read list of variables from flatfile to search in the DB
I am using sqlplus to connect to an Oracle DB via Linux command line. I would like to be able to read through a flatfile that contains a list of macro names I am searching for in the db. I would ...
- 1
2
votes
1
answer
4k
views
Always Free: NO NETWORK after Upgrade from Ubuntu 20.04 LTS ARM to Ubuntu 22.04 LTS ARM
Scenario is the following:
I upgraded from Ubuntu 20.04 LTS to Ubuntu 22.04 LTS. However, after upgrading I lost total connection to the host and I'm only able to access it through Cloud Shell Console....
- 23
0
votes
1
answer
2k
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 ...
2
votes
1
answer
197
views
How to start a bash script on Oracle Linux
What is the right way to start a bash script on Oracle Linux?
on a normal Linux server I use ./script.sh
But here is what I got when I do the same on Oracle Linux
[user@server ~]$ ./script.sh
bash: ./...
- 223
0
votes
0
answers
172
views
Exception in thread "main" java.lang.UnsatisfiedLinkError
Context:
Trying to install Oracle WebLogic Infrastructure 12.2.1.4.0 on Oracle Linux 8.5. JDK 7 & JDK 8 are installed.
Issue:
- 1
2
votes
2
answers
2k
views
How to store query multiple result in shell script variable(Array)?
I'm trying to do a query and store every row result in an array element in ksh (maybe bash).
I do:
result=($($PATH_UTI/querysh "
set heading off
set feedback off
SELECT columnA,columnb FROM user....
- 23
0
votes
1
answer
124
views
Oracle Linux or Ubuntu Server as a hypervisor?
I own a HP Proliant DL380 Rack Server. I would like to use it as a hypervisor for a production environment. I was thiking of installing CentOS with KVM on it, but unfortunately CentOS is not realiable ...
- 31
2
votes
1
answer
340
views
Install oracle on an AIX VM virtualizing with QEMU
I installed a Linux VM in the virtual box, and inside it I installed the QEMU package and virtualized an AIX 7.2 image. The entire installation went correctly.
But when I try to install an Oracle ...
- 121
0
votes
1
answer
124
views
Oracle Linux 6.7 - Nohup: Argument list too long
There are 1 million directories and some files in directories (.pdf, .csv etc.) under the path I have specified below:
/data/upl/repo/exp/
I want all files and folders older than 1 year to be deleted,...
- 23
0
votes
2
answers
2k
views
"python: command not found" on Oracle Linux 8
I have previous had no problem building a mirror server with Oracle Linux 7. I have followed the same steps registering the server, adding subscriptions. When I later run ./uln-yum-mirror script I ...
- 11
3
votes
2
answers
3k
views
Oracle Free Tier: Wireguard and iptables
Problem: Traffic not making it from "client" to "server" and back.
Configs:
"server":
[Interface]
Address = 10.8.0.1/24
ListenPort = 51820
PrivateKey = [redacted]
PostUp ...
- 33
1
vote
1
answer
102
views
How do I resize image jpg/png files in AIX based systems through linux commands (Not UNIX)
How do I resize image jpg/png files in AIX based systems through linux commands (Not UNIX).
I have already seen ImageMagick tool in many forums but it's only for unix based systems like ubuntu but it ...
- 19
0
votes
1
answer
562
views
Trying to install Ora2pg
I am on an Amazon EC2 server running RHEL. The version is:
NAME="Red Hat Enterprise Linux"
VERSION="8.3 (Ootpa)"
I am trying to install Ora2pg (it is based on Perl). But I'm ...
- 349
1
vote
0
answers
43
views
Cannot ChooseWhere to Install the Software and Configuring Storage: Installing oracle linux 8.3 on expired windows 7
I have created a bootable oracle linux 8.3 hard disk and restarted my windows machine by booting from the bootable hard disk which has oracle linux 8.3 iso.
It went well until this stage, where is it ...
- 111
0
votes
1
answer
36
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
-1
votes
1
answer
70
views
Pass a linux variable into oracle script [duplicate]
I am trying to pass mount_point details in my oracle script.
I am able to pass integer variable using below code but not able to send
mount point details in oracle script:
sed "s/@@pqr@@/$space/g&...
- 1
0
votes
1
answer
2k
views
Why virtual box disc can't be shrinked, when I specify the correct directory of my vm image?
this is my virtual box installation dir.
C:\Program Files\Oracle\VirtualBox
and this one is where my image (linux.vdi) is located.
C:\Users\hmkhitaryan\dev\vm\linux
Now I want to add disc size to my ...
- 101
0
votes
3
answers
4k
views
SSH return code status and error handling
I want to check if files count is 0 on Remote server using ssh.
Below code is only checking if file (ending with .dmp exists )
if ssh v0021x91 ls /apps/oracle/home/DB_1201/*.dmp
then
echo &...
- 33
0
votes
1
answer
81
views
Enabling Huge Pages on RHEL6 for Oracle 18C xe
I have been trying to switch from oracle AMM to ASMM huge pages. I have done the following changes on RHEL 6
Added following entry in /etc/sysctl.conf ( as suggested by hugepages_setting.sh )
...
- 213
1
vote
1
answer
148
views
Oracle Linux logon screen without login box
today my Oracle Linux Server 7.3 (installed on a Proxmox VM) just shows a gray window, where normaly the login prompt would be. The gray background is the regular "noisy" Oracle Server 7 ...
- 53
0
votes
1
answer
370
views
Running a .sh script with crontab [duplicate]
I have a file named diario.sh that I run manually using ./diario.sh
The script file contains the following:
#!/bin/bash
cd /home/etapa/Scripts
echo "@CDRS_ETAPATOTAL.sql" | sqlplus -s ...
0
votes
0
answers
460
views
Unable to boot Oracle Linux in Virtual Box
I hope this is the right place to ask this question.
I'm trying to install Oracle Linux 8.1. It works but then the reboot needed after the installation takes it back to the installation screen.
It ...
- 1
1
vote
1
answer
2k
views
Inserting into a Oracle table from a shell variable storing thousands of values
I'm trying to insert records into a column in Oracle where the values are passed from a shell variable. The variable itself stores pattern generated from a list of files. This pattern is generated on ...
- 13
4
votes
3
answers
413
views
Is there any UNIX V7 certified operating system?
I was just having a look at The Open Group official register of UNIX Certified Products, and it doesn't list any system to be registered for the UNIX V7 brand.
Nevertheless, I did remember that Oracle ...
0
votes
1
answer
490
views
Unix command substitution when using sqlplud
Trying to invoke a sql file from unix shells script.
ExecuteSql1.sh
#!/bin/sh
## steps to get the connection and form it.
result=`sqlplus -S ${connectURL} << EOF
SET PAGES 0 lines 800
@ /sql/...
- 103
0
votes
1
answer
4k
views
Can we install Oracle Database on Windows Subsystem for Linux
I tried to install Oracle Database on Windows Subsystem for LINUX and when i tried to execute command
./runInstaller following error occured
ERROR: Unable to verify the graphical display setup. This ...
0
votes
0
answers
210
views
Convert 2 HTML file which is output from SQL query into 1 main HTML output file in shell script
In shell script, I used 2 different SQL query & output of these 2 files in HTML format like (eg- ab.html, cd.html). Before DML operation 1 SQL query will run then after DML operation another query ...
- 13
0
votes
0
answers
99
views
Oracle JDeveloper install ERROR: Cannot locate the archive
I am trying to install Oracle JDeveloper Studio on a CentOS Virtual machine. I have downloaded the install .bin and .zip files using my user. I then tried to change the owner of the file to oracle as ...
- 101
1
vote
2
answers
3k
views
What does this error mean? AH01215: Schema .myuser@mydb. Password .mypass [closed]
I'm trying to deploy a page called 'Create' on my Redhat 7 linux web server using Apache. When I try to reach my page, I get the following error message from my error log:
[cgi:error] [pid 23367:tid ...
- 31
2
votes
1
answer
392
views
Add lines using sed matching two line
I have a file like below
SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DRCDBDB_DGMGRL)
(ORACLE_HOME = /ofa/u1002/18C_DB_HOME)
(SID_NAME = ...
- 23
1
vote
1
answer
6k
views
Can we connect to oracle database using python without cx_Oracle in Linux
Can we connect to oracle database using python in linux without "cx_Oracle" library. We have a restriction of installing "Oracle Instant client which is mandatory required for cx_oracle library" .
We ...
- 306
1
vote
0
answers
49
views
weblogic cluster between two different server
I have two server (for example 1.1.1.1 , 1.1.1.2).
I want to have one administrator tools and two managed servers (one on 1.1.1.1 and another on 1.1.1.2) and cluster these two nodes.
Is the base of ...
- 111
0
votes
1
answer
637
views
To print log file with out put of cron job scheduled for a sql block - with Date and time (all the executions of cron)
I have a shell script which executes a pl/sql block, I'm printing output to output file but it's not keeping old information and not displaying time and date when the script was executed.
My script ...
- 1
0
votes
1
answer
358
views
Change hostname in tnsnames.ora file
I'm trying to write a script to update just the hostname in the tnsnames.ora file.
I'm needing the entry to work case insensitive. For example ${DBNAME} is lowercase database name and in my tnsnames....
- 1
2
votes
0
answers
5k
views
E: Unable to locate package oracle-java8-installer
I've been using the below Dockerfile to install java8. However, all of a sudden while creating the docker image it breaks with error
E: Unable to locate package oracle-java8-installer
E: Unable to ...
- 289
1
vote
0
answers
83
views
Setup OpenLdap on Oracle Linux 6
I am currently trying to setup an openldap server on an Oracle Linux 6 VM (VirtualBox). Packagemanager yum installed openldap version 2.4.40-16.
Following this setup guide:
https://docs.oracle.com/cd/...
- 119