Questions tagged [oracle-database]
The oracle-database tag has no usage guidance.
0
votes
0answers
14 views
Migrate Oracle database from Windows 11g r2 to Linux 12c r1 [on hold]
I have a Windows server with 11g Oracle database, and CentOS 7 server with 12c r1.
I need to migrate the databases from Windows to Linux, but I need some guidance on how to achieve this. For example, ...
1
vote
1answer
45 views
CentOS rpm package not available when using yum
I wanted to install Oracle 11.2 on my centOS7. I did all but one prerequisite steps. Oracle requires me to have a lot of rpm packages preinstalled. Do I need to find all of them and then download ...
-2
votes
0answers
17 views
Instance do not run automatically after turning on computer [closed]
i need to manually turn on my instance on ORACLE on my simulator,
is it normal that the instance does not turn on automatically ?
0
votes
0answers
14 views
Unlock user shell script for Oracle [closed]
We have so many user ID locks from the front-end users. We need to provide a shell script to the user which they can run on OS level and unlock the ID themselves when the DBA is not present.
The sys ...
2
votes
0answers
61 views
How to Resolve Yum Dependencies for Oracle DB Installation
I have a Ubuntu 18 VM and am trying to install an Oracle XE 12c database locally. I have downloaded the related .rpm file and try to install it as instructed via:
yum -y localinstall oracle-database-...
0
votes
1answer
66 views
What is the difference between su - oracle and pbrun /bin/su - oracle [duplicate]
Could anyone explain the difference between the below commands:
su - oracle
and
pbrun /bin/su - oracle
0
votes
1answer
66 views
ssh sqlplus command has $ symbol and it gets substituted
I'm Running some SQLPLUS code over ssh.
ssh -q node1 'export ORACLE_SID=DB11D_1;ORAENV_ASK=NO;. oraenv >/dev/null 2>&1;sqlplus -s / as sysdba << ENDSQL
whenever sqlerror exit 1
alter ...
-1
votes
3answers
97 views
Grep content for multiple files
My OS is Sun Solaris. SunOS sintscdldmu001 5.11 11.3 sun4v sparc sun4v
I gave the command alter database backup controlfile to trace; and happened to forget it.
When i needed the contents of the ...
-2
votes
1answer
41 views
Delete remotely oracle schema using shell script [closed]
I have a remote instance like database-ora12 with existing user tester / password and SID=orac
How I can delete remotely database or schema from this system for this user using shell script without ...
0
votes
0answers
18 views
Selected between the Range in Oracle Sql Query
I have a table naming Product containing below value :
ID NAME PRICE START_DATE END_DATE
1 LG 1,000 01-04-2014 31-03-2015
1 LG 1,300 01-04-2015 31-03-2016
1 LG 1,700 ...
0
votes
1answer
53 views
Extract Dump Files Files Names
I'm trying to automate a database refresh but, now I'm stuck at a part trying to extract the dump files filename to use it with the IMPDP command.
The thing is that we use this parameter doing the ...
0
votes
1answer
265 views
Swap memory high Usage
I need to know what is the actual effect of Swap memory full ?. I have already enough ram but it is still using swap memory? I am using Server With Oracle 11g Database. So if because of swap memory ...
0
votes
3answers
151 views
How To Find All Locations Where $PATH is Set [duplicate]
I would like to know if there is a way to determine where a specific part of my $PATH variable is being set.
About a year and and a half ago I went through the tedious process of setting up a Oracle ...
1
vote
0answers
72 views
How to install php7 on solaris 10 with Oracle Instant client
I am trying to install php7 with oracle on Solaris 10.
The oracle instant-client-basic and instant-client sdk was downloaded from oracle
The instant client-basic was unzipped and this creates the ...
0
votes
1answer
754 views
IF| ELSE condition to check if Oracle database query output shows any result or NULL
I am finding it hard to write an if|else statement for the below condition.
What I am doing is I have an Oracle database where I am running the below query and it returns output in rows (it can show ...
1
vote
1answer
81 views
Exporting and importing a mysqldump from within a mysql CLI heredocument
The following code drops a DB user and a DB instance by the name of test, if both exists, then creates an authorized, all privileged DB user and a DB instance with the same name (also test).
mysql -u ...
1
vote
0answers
589 views
Kernel Panic Not syncing : Fatal Exception
We have DB-DR on Remote Datacenter, And RHEL got hang twice in last two days, Yesterday it was showing just Black screen , And in today morning when i arrived at office again saw notification that DB-...
0
votes
1answer
776 views
Oracle 11gR2 failed on CentOS 7
I am installing Oracle 11gR2 on CentOS 7. I have the packages installed, I have the kernel parameter set but still its not working. Here are the images.
[Installation Image
1
vote
0answers
182 views
Can not install Oracle database in Linux 7
I am trying to install Oracle database to Linux machine.I am getting error down below
Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is ...
0
votes
1answer
270 views
Help in checking the execution of the previous command
Hie team,
I have to perform an operation in a script by connecting to oracle database.I am trying to use expdp command in my shell script to dump the data .
Vi ban.sh
expdp hr/oracle@oracle ...
2
votes
0answers
291 views
error installing oracle 11g on Ubuntu 17.04 Mate
I am trying to install Oracle 11g on my Ubuntu Mate 17.04 machine. In one of the installation steps, I am required to key in the proxy details/credentials.
In our college, there is a wifi as well as ...
0
votes
1answer
438 views
Need to pass arguments in adcfgclone.pl script
I just wanted to know is there any way to pass the arguments in perl script (adcfgclone.pl) during compilation time (i.e., the values should not be asked during script run time)
Below is an example ...
0
votes
1answer
254 views
How to increase temp space in fedora 20
I need to install oracle 11g in my PC. So I have installed fedora 20 in VMware virtual machine and now I need to install oracle. I tried it several times, and every time I'm getting the same error.
...
0
votes
1answer
135 views
Why all oracle processes are reading /proc/<pid>/cmdline of multiple system processes?
I am exploring oracle processes and it's lsof output. I am wondering what is /proc/<pid>/cmdline. 145 same cmdline openfiles displayed for each process of oracle.
So what exactly is this?
Eg: ...
0
votes
1answer
118 views
How to execute a script based on a file
I am trying to write a script that will connect to Oracle from a jump server (i.e) I will execute my script from a jump server, In my script I will have a config file as below
#USERNAME PASSWORD ...
1
vote
0answers
20 views
Installer Oracle Server not allows to enter a value in the field
I set up a server for home testing on Virtual Box. I can't enter the letters in the field "email", only numbers, how do I fix it? Thanks for any help.
0
votes
1answer
132 views
Unable to start database in glassfish in CentOS7
Environment: VPS, CentOS7, glassfish3, server is running.
Tried: both in root and glassfish user. a comamnd: "startNetworkServer"
and sudo netstat -lntp | grep 1527 nothing happened so it seems port ...
0
votes
1answer
3k views
Oracle Linux 7: Autostart Oracle with init.d
I try to make Oracle 12.1.0.2.0 start with the system via init.d on my Oracle Linux 7.3 machine.
I followed this example: https://oracle-base.com/articles/linux/automating-database-startup-and-...
1
vote
0answers
582 views
Running SQLPlus Oracle Command as Root returns incorrect answer
I am trying to create a script that checks the usage of each disk in an ASMDISK group. I have my script setup on one node in each RAC cluster. It works on several of the servers without issue, but ...
0
votes
1answer
5k views
Shell Script: Login to Oracle DB and fetch data to variable
I have this shell script, which login to oracle database, select from a table and put the result on other variable
Username=User1
Password=Pass1
eval DatabaseName=db_tst
var1 = 1
Result=`sqlplus -...
1
vote
1answer
122 views
What network settings need to be changed in order to access my guest oracle linux pre-built VM from my host?
I just downloaded and successfully installed this oracle linux/database pre-built virtual machine.
I was successfully able to login as oracle/oracle user and view the desktop with the red-colored ...
-1
votes
1answer
36 views
Pick Values From A Oracle Select Query
I have executed the below command (Part of a 2 step procedure required for password reset when we face the error ORA-28007).
SQL> select USER#,NAME,PASSWORD FROM user$ where name='TESTUSER';
...
0
votes
0answers
438 views
ORA-12560: TNS: protocol adapter error
I have tried to install Oracle 11g R2 on Solaris 10 in Virtual Box. While installing it get completed 95% but while it try to install "Database Configuration Assistant" it shows "ORA-12560: TNS: ...
1
vote
0answers
1k views
How to Install Oracle 12 on Debian Jessie server?
I want to install Oracle version 12 on a server Debian Jessie, but I can't find any tutorial or commands to follow.
How can I install it?
0
votes
0answers
925 views
Shell script to check the ASM diskgroup space in Oracle and send a mail
I am trying to write a shell script to monitor ASM instance in Oracle and mail the respective people in mail list. I have written the following script.
#/bin/sh
#set -x
USER=xxx
PASS=yyy
...
0
votes
1answer
3k views
how to set static ip for guest OS on VirtualBox [duplicate]
My host is Ubuntu 12.04 and I have installed Virtual Box on it. Network setting of Virtual Box is NAT.
Then I have Oracle Enterprise Linux as guest.
Now I want to set a static IP for my guest, ...
1
vote
1answer
1k views
What is the best way to install Oracle 11g R2 and SQL Developer on CentOS 7 / RHEL 7?
I read this article suggesting use of Oracle's yum repository in conjunction with CentOS 6.x.
I also read this other article, which seems to suggest manually downloading zip files and taking many ...
0
votes
1answer
2k views
Finding the Oracle JDBC version using the command line
I want to check out the Version of my Oracle JDBC driver.
In this case, I know the driver is 12.1.0.2:
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle
But without that I am searching for a ...
2
votes
3answers
13k views
how to uninstall oracle 11g xe from centos 7?
I installed oracle 11g xe to test a software and have not been using it for a while. How to cleanly uninstall?
0
votes
1answer
17k views
xhost + is not working with Oracle installation
I am trying to install Oracle on Ubuntu 14.04. I have followed instructions and now I am trying to start the installation. However, I am facing problems.
If I run ./runInstaller command with oracle ...
0
votes
1answer
416 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 ...
0
votes
0answers
1k views
Doctrine OCI8 charset behavior between php-cli and php-fpm
My Oracle database is in ISO8859-1 (not by choice).
I'm struggling with segfault from php-fpm for a couple of days now. To dig out the source of it I've set two parallel environnements with the ...
0
votes
2answers
121 views
Assigning output of a Dynamic Performance View (v$asm_diskgroup) to a variable in Shell Script
I am trying to assign the output of
select name from v$asm_diskgroup;
to a variable in Shell . The script is failing because of special character '$' in the table name .
Note : While i tried ...
3
votes
2answers
949 views
How to install oracle11gr2 on ubuntu 15.04?
I am working with this tutorial.
But i got this error on step 5:
Package libtiff4 is not available, but is referred to by another package.
This may mean that the package is missing, has been ...
4
votes
2answers
2k views
SQLplus and Oracle, bad UTF-8 display
I have set
export NLS_LANG=Italian_ITALY.UTF8
db is on UTF-8
SELECT * FROM NLS_DATABASE_PARAMETERS
NLS_CHARACTERSET |AL32UTF8
But sqlplus ...
0
votes
1answer
4k views
Find out home directory of running Oracle instance
There are two oracle directories on our system:
oracle
oraclex
How can I find out which of them is used by the running Oracle instance?
0
votes
0answers
331 views
Edit Oracle Path on Ubuntu Virtual Machine
I have two virtual machines ubuntu 14.04 LTS, one is a server when I installed oracle 11g express, and the other is a simple client. My goal is to run an sql query remotely from the client machine. So ...
-1
votes
1answer
34k views
Sqlplus: Command not found
I have two virtual machines ubuntu, one is a server when I installed oracle 11g express, and the other is a simple client.
My goal is to run an sql query remotely from the client machine.
So I ...
2
votes
1answer
4k views
Error When trying to install a package using dpkg
I am trying to install Oracle SQL Developer onto a Debian Linux server.
I started off by downloading a package from the Oracle website;
sqldeveloper-4.0.3.16.84-1.noarch.rpm
I then called the ...
6
votes
2answers
2k views
VirtualBox Time Sync
I use Oracle Virtualbox 4.2.18 as a guest Linux environment on my Mac OSX, so I can use it to host an Oracle DB (11G R2).
The problem I have is that every day at various points the system time of the ...
