Skip to main content

Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5 votes
1 answer
383 views

How to specify dynamic "Environment" variables in a systemd unit file?

This $(ls -d...) does not work in a systemd unit file: [Service] Type=forking Environment="ORACLE_HOME=$(ls -d /usr/lib/oracle/*/client64 | sort -rV | head -n1)" Environment="TNS_ADMIN=$...
Sybil's user avatar
  • 1,913
1 vote
0 answers
62 views

Error while trying to install Solaris in VirtualBox

Hello i tried to install Solaris on virtualbox but after i choose instalation method in grub it is stuck at this I dont know how to fix it. Can someone help me? Thanks
Crazegi Contact's user avatar
0 votes
1 answer
51 views

Rescue data on Oracle Cloud after "chmod 700 -r /"

I'll preceed by saying I'm a novice in unix, I use Oracle Always Free for small personal projects. Also this is me trying to save the data specifically on Oracle Cloud. I accidentally ran sudo chmod ...
Victor Lundgren's user avatar
0 votes
0 answers
126 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
141 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
422 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
192 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
1 answer
114 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
  • 363
0 votes
0 answers
744 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
256 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
1 vote
1 answer
102 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
8k 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
1k 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
  • 177
2 votes
1 answer
5k 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
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 ...
Mohamed Douzi's user avatar
2 votes
1 answer
444 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
222 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
159 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
397 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
163 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
1 vote
2 answers
3k 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
124 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
777 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
  • 393
1 vote
0 answers
50 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
55 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
73 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
3k 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
5k 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
  • 43
0 votes
1 answer
99 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
  • 243
1 vote
1 answer
178 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
483 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
495 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
476 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
565 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
252 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
104 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
4k 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
472 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
7k 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
  • 316
1 vote
0 answers
53 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
700 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
456 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
99 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
2 votes
1 answer
783 views

Install Java command line - webupd8team PPA DISCONTINUED

Java can't be installed from webupd8team PPA since the Oracle JDK License has changed for releases starting April 16, 2019: https://launchpad.net/~webupd8team/+archive/ubuntu/java Oracle Java ...
anber's user avatar
  • 143
0 votes
1 answer
270 views

oracle 11g installation on ubuntu 16.04 sysctl permission denied?

I am trying to install oracle 11g on ubuntu 16.04 after setting oracle 11g xe kernel parameters successfully # Oracle 11g XE kernel parameters fs.file-max=6815744 net.ipv4.ip_local_port_range=...
user8716806's user avatar