Questions tagged [oracle-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
37 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
14 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 ...
0
votes
1answer
12 views

How do I write SQL to fetch strings that begin with % in Oracle?

Could someone please assist on how to fetch the data in SQL for all the strings starting with %%string? I tried below to escape %% but it didn't work SELECT * FROM Tablename WHERE host LIKE ‘[%][%]%’...
1
vote
1answer
102 views

Convert 2 HTML file 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). Shell script as -> #/bin/ksh ab=$(SQLPLUS -s <username>/<password>@...
0
votes
1answer
44 views

How to get result of SQL query in shell script with same format that when we run on Oracle SQL developer/Toad/PLSQL developer

In shell script I am using SQL query. #/bin/ksh var=$(sqlplus -s <user>/<password>@DB <<EOF set heading on set trimspool off set linesize 200 set feedback ...
0
votes
1answer
102 views

Shell script that starts sqlplus utility and executes a query, gathers output

I'm trying to do this: In sample.sh: #!/bin/bash sqlplus / as sysdba select * from dual; And just when I run this shell script, it opens sqlplus utility, but it cannot execute the next line that I ...
0
votes
0answers
870 views

Tunnel fails with “channel 3: open failed: connect failed: Connection refused” and ORA-12537 or ORA-12514

Here is what I did: 1/ Establish connection from my client PC to jump with tunnel in putty with: L2234 ('Source port') localhost:2235 ('Destination') 2/ Once logged onto this jump server, in ...
0
votes
0answers
282 views

How to connect to Oracle DB from client using oracle JDBC connection in shell script

I am trying to connect to oracle DB from my client machine using shell script. I am using the below to connect to DB. Property file: driverClassName=oracle.jdbc.driver.OracleDriver url='(...
0
votes
0answers
24 views

Query Oracle database through python

Background: New to python. I have a high security client. Anything on the O/S must go through a lengthy (nearly impossible in some cases) process to be approved by the IA department. I want to ...
0
votes
0answers
9 views

Autostart listener and database when linux machine get reboot is not working

I have created dbora script and when I manually run dbora script using command - /etc/init.d/dbora start , it start listener and database. I have created symbolic link to dbora. But when I reboot the ...
1
vote
3answers
1k views

How to assign select statement from Oracle to shell variable

I have a script which is working fine in TOAD: SELECT max (ID)+1 from apps_details; When I'm trying to run it in the shell script, I'm getting an error: DB_CONNECT="XXXXX/XXXXX@XXXXXX" echo "...
0
votes
1answer
118 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....
1
vote
3answers
57 views

Prevent Script from Inserting Space in File Name

I have an Oracle database table that is storing the full path and name of a file in a table column. In a SQL client I can run: select file_name from table where request_id=12345 and I will get this ...
0
votes
1answer
106 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
0answers
123 views

ORA-09925 when login to Oracle in Manjaro

I have installed Oracle 12c in my Manjaro PC, and i can't login because i got this error: ORA-09925: Message 9925 not found; No message file for product=RDBMS, facility=ORA Linux-x86_64 Error: 2: No ...
1
vote
1answer
496 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 ...
1
vote
0answers
451 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
815 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
535 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
1k 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
115 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
1answer
465 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
1k 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
1k 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
171 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
3k 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
120 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
995 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-...
1
vote
1answer
1k 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
437 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
634 views

Checking the execution of the previous command

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 table=man ...
2
votes
0answers
326 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
729 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
294 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
202 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
137 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
192 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
5k 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-...
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 ...
1
vote
0answers
998 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
8k 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
329 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
38 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'; ...
2
votes
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
1k 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
4k 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
4k 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
17k 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?