Questions tagged [oracle]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
24 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
74 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
42 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
1k 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
33 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
125 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
65 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 ...
0
votes
0answers
26 views

Oracle VirtualBox can't boot Oracle ODI VM

I'm facing a strange issue. I've downloaded VM from Oracle for Oracle Data Integrator (https://www.oracle.com/technetwork/middleware/data-integrator/odi-demo-2032565.html), and it works like a charm ...
1
vote
0answers
25 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
643 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
66 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
58 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
2k 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
0answers
248 views

Fatal Error DISPLAY variable set incorrectly: :0

I want to install oracle weblogic server. I already downloaded it and it's fmw_12.1.3.0.0_wls.jar. In order to install it I'm instructed to run java -jar fmw_12.1.3.0.0_wls.jar. But when I run it I ...
0
votes
0answers
226 views

Linux UDEV not reload configuration automatically after system reboot

I have a problem with my single host, where I'm using Oracle ASM on raw disks (UDEV). In file /etc/udev/rules.d/30-oracle_asm.rules I defined UDEV rules KERNEL=="sd?", PROGRAM=="/root/SCRIPTS/asm....
0
votes
1answer
255 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
310 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
169 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
241 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
232 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
932 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
193 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
375 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
483 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
295 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
18 views

VBoxGuestAdditions Error 112

How to fix this error that occurs while trying to install VBoxGuestAdditions?
0
votes
1answer
1k 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
442 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
672 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
73 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
488 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 ...
1
vote
0answers
491 views

display unix variable with dbms_output.put_line

I have a loop with while that is reading a file and then makes a query of these values. But when I'm trying to show a message with dbms_output.put_line it says : dbms_output.put_line(henry); ...
0
votes
0answers
217 views

How do you install Oracle on Linux when you get the error “ORA-27101: shared memory realm does not exist”?

I am installing Oracle 11 on CentOS 7.2. I have installed it before on servers with less RAM. I get this error: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ...
2
votes
1answer
373 views

Install Oracle Java from a mirror in terminal

I can't access Oracle servers for some reason. Is there any way to install Java from a mirror? I'm using Fedora 24 and I need to install Oracle Java on it.
1
vote
1answer
765 views

Install Oracle Java 8

I'm trying to install Java 8 on a GitLab Runner like this: apt-get --quiet update --yes apt-get --quiet upgrade --yes apt-get --quiet install --yes software-properties-common python-software-...
0
votes
1answer
186 views

parsing oswiostat

I am looking for a way to parse an iostat file and grab the time and iowait. My files look like this: Linux OSWbb v7.3.3 zzz ***Wed Jul 20 19:00:08 EDT 2016 avg-cpu: %user %nice %system %iowait %...
0
votes
3answers
865 views

What is Solaris IPS / How does it work?

I have read the docs and PDF's from Oracle on the matter but they were too broad and too much analytic for me to understand. Could someone provide me an overview (as he/she understands it) of the ...
0
votes
1answer
639 views

How to extract db version from oratab

I have a requirement to extract the database version in order to fulfill a script requirement. I need to fetch the db details from oratab and its version. Suppose my entry in oratab as below : ...
1
vote
2answers
2k views

JDK 1.4.2 - where can I download the source?

I want to install Java JRE 1.4.2 or JDK 1.4.2 on a recent Amazon Linux server. The best option so far seems to install from source. However - where can I download this? I believe 1.4 is still from the ...
0
votes
1answer
520 views

Oracle XE silent config ignores response file…?

I'm trying to configure Oracle XE 11.2 (on Oracle Enterprise Linux 6.6) in "silent mode" via a response file. I'm using the response file provided in the package (Disk1/response/xe.rsp), replacing ...
1
vote
2answers
865 views

ssh tunnel and oracle

On oracle server i can connect clear sqlplus user/pass@hostremote/SID If i make a tunnel ssh -L 1521:localhost:1521 -F -n hostremote -vvv give me debug1: Connection to port 1521 forwarding to ...