Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

mounting windows to linux using cif utils : SOA unable to access the mounted directory

Here I'm trying to write file to a target mounted directory using oracle soa. However, on writing file I got below: Exception occurred when binding was invoked. Exception occurred during invocation of ...
user avatar
0 votes
0 answers
27 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:
user avatar
  • 1
2 votes
2 answers
380 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....
user avatar
0 votes
1 answer
72 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 ...
user avatar
  • 31
2 votes
1 answer
183 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 ...
user avatar
0 votes
0 answers
54 views

Oracle Linux - "dzdo yum update yum" and "dnf module list" not working and showing timeout error

dzdo yum update yum Total download size: 2.9 M Is this ok [y/N]: y Downloading Packages: ^[OC(1-3/7): dnf-4.4.2-11.el8.noarch.rpm 0% [ ...
user avatar
0 votes
1 answer
57 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,...
user avatar
0 votes
2 answers
910 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 ...
user avatar
0 votes
0 answers
20 views

Error when installing oracle database rpm

I am getting an error when I try to install the oracle rpm. I tried to fix it using --nodigest but it says file not found.
user avatar
2 votes
2 answers
2k 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 ...
user avatar
1 vote
1 answer
65 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 ...
user avatar
  • 19
0 votes
0 answers
127 views

is it applicable to install oracle db 19c on pacemaker cluster?

I want to install oracle 19 c on an RHEL Cluster. I configure 2 RHEL 7.7 with pacemaker cluster and all is working well for VIP IP and shared disk. Is it applicable to install the oracle database on ...
user avatar
0 votes
1 answer
256 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 ...
user avatar
  • 275
1 vote
0 answers
29 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 ...
user avatar
  • 111
0 votes
1 answer
26 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&...
user avatar
  • 1
-1 votes
1 answer
57 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&...
user avatar
  • 1
0 votes
1 answer
221 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 ...
user avatar
0 votes
3 answers
2k 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 &...
user avatar
  • 11
0 votes
1 answer
52 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 ) ...
user avatar
  • 203
1 vote
1 answer
98 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 ...
user avatar
0 votes
1 answer
232 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 ...
user avatar
0 votes
0 answers
280 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 ...
user avatar
  • 1
1 vote
1 answer
1k 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 ...
user avatar
4 votes
3 answers
301 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 ...
user avatar
0 votes
1 answer
303 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/...
user avatar
  • 103
0 votes
1 answer
3k 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 ...
user avatar
0 votes
0 answers
107 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 ...
user avatar
0 votes
0 answers
62 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 ...
user avatar
1 vote
2 answers
2k 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 ...
user avatar
2 votes
1 answer
104 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 = ...
user avatar
  • 23
1 vote
1 answer
5k 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 ...
user avatar
  • 262
1 vote
0 answers
47 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 ...
user avatar
0 votes
1 answer
478 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 ...
user avatar
0 votes
1 answer
253 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....
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 ...
user avatar
1 vote
0 answers
68 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/...
user avatar
  • 119
2 votes
1 answer
741 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 ...
user avatar
  • 143
0 votes
1 answer
198 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=...
user avatar
0 votes
2 answers
142 views

Why does my hostname show as "Unknown-08-00-27-50-25-08" when using a bridged connection?

I am running an Oracle Linux 7 VM. I have booted the VM up separately with different network options, NAT and Bridged connection. I would like to use a bridged connection so I can SSH in easily. When ...
user avatar
  • 53
-1 votes
1 answer
6k views

how to enable GUI mode in oracle linux 6

WE are trying to opening Graphical user interface services , but not able to open in Oracle Linux 6.10. Please provide any solution how to enable GUI mode in oracle linux 6.1 .
user avatar
0 votes
1 answer
530 views

Oracle Linux 7 mounting SAN storage issue

I have a scenario where I am trying to mount SAN storage to my linux machine. My environment details are- Oracle VM manager for VM creation Fiber Channel HP3PAR SAN storage attached as physical disk ...
user avatar
  • 101
0 votes
1 answer
573 views

Solaris 11 change current image / "entire" package

I need to install a new Solaris image on our server as it used to be under a support agreement but is not anymore, and as such I'm unable to download any new packages from the (https://pkg.oracle.com/...
user avatar
0 votes
1 answer
454 views

How to compile a ".pc" file on Debian 9?

I need to compile a Pro*C - .pc file on Ubuntu. So far what I have realised is that I need a Pro*C compiler to translate the Pro*C - .pc file into pure / standard C code.  But I need to have Oracle ...
user avatar
  • 1
-1 votes
3 answers
436 views

Can I change the SHELL on a running Oracle database?

I just started a new contract and have run into an issue I have never encountered before. Their Oracle database was started under a korn shell. oracle:x:500:100:Oracle user:/home/oracle:/usr/bin/ksh ...
user avatar
  • 288
0 votes
2 answers
445 views

Install Java 6 from Oracle to Debian Lenny

Since Java 6 is not available in Debian 5 I decided to take it from Oracle. I have downloaded Java 6 SDK in file jdk-6u45-linux-i586-rpm.bin. But how to install it? I executed jdk-6u45-linux-i586-rpm....
user avatar
  • 733
2 votes
1 answer
2k views

editing sysctl.conf on oracle linux 7.5

I am going to install oracle database 12c on oracle linux 7.5. In the process, I have to edit following kernel parameters and set values. fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = ...
user avatar
0 votes
1 answer
401 views

cron reschedule seems not to be taken into account unless reboot occurs?

I have read a number of posts on SE.com regarding cronjobs, crontab, and how to reschedule cron jobs. But it seems that, in my Debian environment, a session cleanup job schedule simply called "php", ...
user avatar
0 votes
1 answer
614 views

Execute a block based on the output of a variable [closed]

Below is the script i drafted, that will work based on the SIDs it will get from ps -ef | grep pmon Once the SID is grepped, it will pass the SID to dbenv() to set the necessary parameters, and it ...
user avatar
0 votes
1 answer
1k views

text based browser with javascript support [closed]

What I want to ask is purely for educational and learning purpose. I am trying to download and install Oracle 11g R2 on a CentOS 7 system in text mode. The text based browsers I tried are lynx, links,...
user avatar
1 vote
2 answers
713 views

SLES 12.3 and oracleasm module issue

So... Fresh installation of Sles 12.3, kernel 4.4.73-5-default, x64, Oracle support packages installed using zypper from official SUSE repositories... ~:rpm -qa | grep orac oracleasm-support-2.1.8-1....
user avatar
  • 161