Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 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 ...
0
votes
3answers
68 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 &...
0
votes
0answers
8 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 ) ...
0
votes
0answers
24 views

How to create a oracle wallet with chain certificates?

I have three certificates, root, intermediate and server. Intermediate certificate is signed by root certificate and server certificate is signed by intermediate certificate. What are the steps to ...
1
vote
1answer
40 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 ...
0
votes
1answer
38 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
0answers
18 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
vote
1answer
65 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 ...
0
votes
0answers
13 views

Configure huge pages for Oracle RAC installation

I am going to install an Oracle RAC 18c environment over rhel 7.5 and I do not fully understand how I should configure the huge pages section ... specifically what values to put in nr_hugepages and if ...
1
vote
2answers
75 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
1answer
41 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/...
0
votes
0answers
6 views

When cloning from an OEL7 template VM in VMware, how do you change any unique identifying info that may be redundant on all clones?

I know there is UUID and other info that is used for disk partitions and network. I am most concerned that I would have issues somewhere by all machines in an environment that were built using the ...
0
votes
1answer
673 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
0answers
184 views

Pacemaker RHEL 7 - Oracle Listener stopped on Failover

We have two node cluster using a shared storage (HA-LVM) for Oracle Database. And i created following resources stgdbfence1 (stonith:fence_vmware_soap): Started RTG-STGDB-01.gulfpc.com ...
0
votes
0answers
23 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 ...
0
votes
0answers
26 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 ...
0
votes
0answers
77 views

Missing steps to run OMSPatcher?

I'm having some trouble applying an Oracle patch to the Management Services. After downloading and unzipping the particular patch in ORACLE_HOME, I get an error that I don't understand when trying to ...
1
vote
2answers
421 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 ...
2
votes
1answer
54 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 = ...
-1
votes
1answer
3k 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 ...
1
vote
0answers
38 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 ...
0
votes
1answer
242 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 ...
0
votes
1answer
129 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....
2
votes
0answers
4k 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 ...
1
vote
0answers
40 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/...
2
votes
1answer
690 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 ...
0
votes
1answer
113 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=...
0
votes
2answers
86 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 ...
-1
votes
1answer
3k 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 .
0
votes
1answer
342 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 ...
0
votes
1answer
385 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/...
0
votes
1answer
251 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 ...
-1
votes
3answers
298 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 ...
0
votes
2answers
307 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....
2
votes
1answer
1k 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 = ...
0
votes
1answer
261 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", ...
0
votes
1answer
444 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 ...
0
votes
1answer
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,...
1
vote
2answers
576 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....
0
votes
1answer
322 views

Clear OS-level cache

I have Red Hat Enterprise Linux 6 with Oracle 12c database. I am doing performance benchmarking but there seems to be an OS level cache causing only 1st time read to take significant time. How can I ...
0
votes
1answer
19 views

VBoxGuestAdditions Error 112

How to fix this error that occurs while trying to install VBoxGuestAdditions?
0
votes
1answer
2k views

How to insert null for missing column? [closed]

I want to write a script that inserts values into a list of tables as follows. Example: insert into TABLE1 ( a,b,c) select a,b,c from TABLE2; But TABLE2 does not have column C, so I want to insert ...
2
votes
1answer
554 views

How to make a script “wait” for an operation to finish?

I have two scripts, or maybe better call one a wrapper for the another. Here comes the wrapper: #!/usr/bin/expect set timeout 20 spawn "./installOracleDatabase.sh" expect "replace Disk1/upgrade/...
0
votes
1answer
776 views

Problem running a web server in Oracle VM Virtualbox with Port Forwarding

I am using Oracle VM VirtualBox and running a CentOS 7 instance on it. I have setup two network adapters for this machine. One is set in Host Only mode and the other one is in NAT mode. I am able to ...
1
vote
0answers
27 views

How to make an SQL statement display how many rows it has counted so far?

Suppose there is a table with billion rows, and I issue a select statement as below, SQL> select * from big_table; During the statement execution is it possible to print the number the rows it ...
0
votes
1answer
2k views

bash: /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh: No such file or directory

When I open my terminal, I see this on top of the terminal. I removed Oracle XE. However, I cannot remove this line from my terminal. Also I cannot remove Oracle user from my group. What can I do? ...
1
vote
2answers
77 views

Select the contents respective to some specific content from a file and move it to an output file

I have a file tnsnames.ora and its contents are as below. NEWDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linuxerp.de.mph.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = ...
0
votes
1answer
2k views

Problem running rman in cron

I have a problem with script scheduled in cron. In cron I have following line: 33 09 * * 1-5 oracle /data1/backup/scripts-test/rman.sh > /data1/backup/log.txt 2> /data1/backup/log_err.txt As ...
3
votes
1answer
1k views

su cannot open session error when starting Oracle XE database

I have a RHEL 7.2 server with Oracle 11g Express Edition (11.2.0) installed. The installation of Oracle created a file named "oracle-xe" in /etc/init.d This is a bash script that can be used to ...
0
votes
1answer
539 views

how to find the logged in user in linux running oracle session

i like to find out the logged in user to linux and running some session . we cannot use the os_user option as we all use sudo user before login to oracle. so how to find out the super user who logged ...