Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
mattp's user avatar
  • 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 ...
Mr.P's user avatar
  • 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"...
user3055964's user avatar
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 ...
Ishan Goel's user avatar
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 ...
wjwrpoyob's user avatar
  • 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 ...
zundarz's user avatar
  • 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/...
Rich007's user avatar
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 ...
rndm_acct1's user avatar
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: ...
Sane's user avatar
  • 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 ...
Nainita's user avatar
  • 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 ...
Wpgn's user avatar
  • 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 ...
UserGoogle's user avatar
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 ...
N. J's user avatar
  • 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: ...
Boro's user avatar
  • 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 ...
Joel's user avatar
  • 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....
kiraitachi's user avatar
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 ...
Mohamed Douzi's user avatar
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: ./...
Angel115's user avatar
  • 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:
Axel's user avatar
  • 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....
defekas17's user avatar
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 ...
Adrián's user avatar
  • 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 ...
Luis Henrique's user avatar
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,...
jrdba123's user avatar
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 ...
DeveloperRB's user avatar
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 ...
stinkfoot's user avatar
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 ...
Pramod's user avatar
  • 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 ...
J86's user avatar
  • 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 ...
chas's user avatar
  • 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&...
Divya's user avatar
  • 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&...
Divya's user avatar
  • 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 ...
Hayk  Mkhitaryan's user avatar
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 &...
Veera V's user avatar
  • 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 ) ...
Prem's user avatar
  • 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 ...
DoubleVoid's user avatar
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 ...
Roberto Vélez's user avatar
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 ...
Simi's user avatar
  • 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 ...
AntiNational's user avatar
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 ...
Gabriele Scarlatti's user avatar
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/...
Tim's user avatar
  • 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 ...
bhanuvinayes's user avatar
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 ...
user8487380's user avatar
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 ...
Superdooperhero's user avatar
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 ...
casper1111's user avatar
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 = ...
Raj's user avatar
  • 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 ...
Arya's user avatar
  • 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 ...
Elham_Jahani's user avatar
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 ...
james k's user avatar
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....
idkdba's user avatar
  • 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 ...
Omnipresent's user avatar
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/...
Thomas's user avatar
  • 119