Questions tagged [oracle]
The oracle tag has no usage guidance.
0
votes
1answer
50 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
21 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
31 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
27 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 .
-3
votes
0answers
31 views
Compare columns and find the difference from a table dynamically [migrated]
I have a table with 3 columns,first column is some parameter and remaining 3 are last 1 week count of those parameter and has content similar like below. first row is table columns from oracle. I have ...
0
votes
0answers
48 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
34 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
0answers
115 views
Oracle Java 8 installation Not Found (404) Error [duplicate]
I wanted to install oracle-java8-installer and after adding the repository, give the command sudo apt-get install oracle-java8-installer. First the screen appears that is about agreement, after ...
0
votes
1answer
109 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
131 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
81 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
123 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
120 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
475 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
0answers
326 views
Oracle bi failed with exit value 3
I've installed Oracle Linux Server 7.5, then installed weblogic, infrastructure, business intelligence 12.2.1.2. I installed products based on this tutorial. Everything goes well until it comes to ...
0
votes
1answer
128 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
270 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
878 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
366 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
237 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
15 views
VBoxGuestAdditions Error 112
How to fix this error that occurs while trying to install VBoxGuestAdditions?
0
votes
1answer
612 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 ...
3
votes
1answer
361 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
556 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
25 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 ...
-1
votes
1answer
1k 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
62 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
1k 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
765 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
348 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
434 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
201 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
295 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
697 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
158 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
744 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
511 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
444 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
765 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 ...
