All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
31 views

RMAN log file with date and name in Oracle 11gR2 in Linux

I have a script and I want to create my log file with datetime and with unique name. It's my script: ....... ....... rman target/ LOG='/u01/backup/logs/rman.log' <<EOF ....... ....... ....... ...
0
votes
1answer
29 views

Using of delete obsolete in Oracle 11gR2 RMAN on Linux

I'm using crontab for automatic backup (full backup). It works 2 times in a day (8 AM and 23 PM). In my script I use delete obsolete but I have a question. I want to delete old backups without last 2 ...
-3
votes
2answers
61 views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
0
votes
0answers
32 views

ORACLE timed Datapump on Linux? (No crontab)

what is the best way to create a timed Datapump Dump of a PDB on a Linux System? No Crontab. And how do I implement it?
0
votes
0answers
13 views

IO scheduler for Oracle RAC on Linux

All the documentation I have seen says that Oracle recommends the deadline scheduler. This seems very counter-intuitive when using a mini-SAN (with persistent write caching) - in such a scenario, and ...
1
vote
2answers
41 views

Virtual Environment for learning [closed]

I am a new DBA and my friend told me the best way to learn about becoming a DBA is to setup your own server (virtually or physically). I don't have a spare machine laying around so I will need to set ...
1
vote
1answer
68 views

ORA-00904: “GET_JAVA_PROPERTY”: invalid identifier - 11gR2

In Oracle DB 11.2.0.4, linux 6.7 single instance select get_java_property('java.version') from dual; SQL> show user USER is "SYS" SQL> select get_java_property('java.version') from dual; ...
0
votes
1answer
27 views

Using AMMM or Huge Pages for Oracle 11g R2 Database

I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM. Now, I have a memory increase up to 32Gb. I'm planning to increase ...
0
votes
1answer
32 views

Would installing 32 bit packages on the existing 64-bit VM be an option to run Oracle 9.2?

I inherited an old old 9i DB that now needs recovery. It is unstable (disk corruption and performance problems). I have a backup. In the interest of time - I have 64-bit VMs all over the place, but ...
0
votes
2answers
845 views

Special Character in password

I'm Trying to connect to a remote DB using Sqlplus, but the password contains a special character (!). The SID is working fine, but Sqlplus is complaining about it when I use the ! in the password /...
1
vote
1answer
188 views

Unlock user shell script for Oracle

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 ...
1
vote
0answers
81 views

Impdp (Oracle 12c) on Ubuntu 16.04

I am trying to import a dump into Oracle 12c by using the below command: impdp SROUSER/<password> directory=dump_dir dumpfile=SROUSER.dmp logfile=dp.log full=yes Which is resulting in the ...
1
vote
3answers
1k views

How to set listener.ora and tnsnames.ora for oracle instances

I set listener.ora and tnsnames.ora, but I do not know if it is well set up. When I call the lsnrctl status command, I get instances rcadb and proddb unknown. I'm a beginner in Oracle, I installed ...
0
votes
1answer
37 views

Help understanding the password file

I have one database and password file Now I'm creating a new database, do I need to create another password file or not? I'm a beginner in Oracle, maybe a bit stupid question. Thanks in advance
1
vote
2answers
396 views

What happens when sga and pga reach limits?

I have the following doubt, I have a server with Oracle 9i and another with Oracle 12c, in both cases I have the doubt that happens when Oracle reaches the limit imposed by the defined memory ...
0
votes
1answer
58 views

Problem with pdb Oracle 12c

I use pre-built Oracle 12c r2 when I tried to sign up as sqlplus / as sysdba I got a ORA-01017 which I solved with unset TWO_TASK Since then, I can not sign in to the user I created Because I'm in ...
0
votes
1answer
94 views

I have an error before I connect to the user Oracle 12c [closed]

After that, I log in normally. I tried it sqlplus as sysdba error is the same Why this error occurs I'm a beginner [oracle@localhost ~]$ sqlplus "/as sysdba" SQL*Plus: Release 12.2.0.1.0 ...
0
votes
1answer
67 views

Moving Oracle / Oracle datafiles to different file system on Linux

We have Oracle installed on /root, which is now running out of space due to increasing data in Oracle database. On the same machine we have another file system with free space. I want to know the ...
0
votes
1answer
2k views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
0
votes
1answer
229 views

Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM [closed]

if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
1
vote
1answer
1k views

Oracle - Archivelog files , can we delete them?

We have RHEL 7.2 machine where Oracle is installed. Recently this machine ran out of space and we figured out that most of the space is going into "/home/oracle/ORA12C/fast_recovery_area//archivelog" ...
1
vote
2answers
5k views

Swap utilization is high on Oracle server

How do I reduce swap utilisation on a Linux server which is running as an Oracle 11gR2 Server? Currently it shows above 80% in Enterprise Manager. How do I identify which processes use swap memory ...
0
votes
1answer
2k views

Can not install oracle apex on GNU/Linux (db 12c)

I have to install oracle apex on oracle database 12.2.0.1.0, database is on GNU/Linux server. I followed instructions from this pages: https://oracle-base.com/articles/misc/oracle-application-express-...
1
vote
2answers
2k views

Error when executing “create pfile from spfile”

I just installed Oracle database 12cR2 and am trying to startup a database. I am trying to create a pfile from spfile using following query. create pfile from spfile; Then I get the following ...
1
vote
0answers
63 views

How to detect if insert transactions in oracle db are slow?

At work, I have an Oracle DB (11g) in which I want to detect if there's slow performance while inserting data. Here's the situation: Some production devices send data results from tests to Server A, ...
0
votes
1answer
8k views

Listener Status Blocked

I'm deploying a 12C dataguard on oracle. When performing all procedures, start the instance in the standby, as nomount. I noticed that the standby listener is as BLOCKED status, making it impossible ...
0
votes
2answers
60 views

Does the Oracle database username exist for each Linux account?

Does the Oracle database username exist for each Linux account? The former employee left the company and can not find the details at this time. I can log in to the Linux root account and run a DB ...
-2
votes
1answer
94 views

/oracle is 91% what to delete? [closed]

/dev/xvdf 109G 93G 11G 91% /oracle My /Oracle diskspace is now 91% full. I have deleted some temp files already. Whatelse can I delete here in this directory? Thanks for helping. /...
0
votes
1answer
294 views

Hostname configuration for oracle12c on OL7 VM

I am trying to install Oracle 12c (for learning/studying purposes)on a VirtualBox VM. i have set up a VM with Oracle Linux 7.4 and when I setup the wireless/networking aspects during installation I ...
1
vote
1answer
239 views

AWS ORACLE Linux 7.4 - Connection issue

I tried to install oracle 12c in Oracle Linux 7.4 instance upon AWS ORACLE Linux 64 EC2 instance, I could make the installation and connect to the database from the ec2 server without any issue ...
0
votes
1answer
5k views

ps-ef|grep pmon (Instance Name Only)

When i issue a "ps -ef|grep pmon", I get the below output. oracle 230330 1 0 Jan08 ? 00:01:14 asm_pmon_+ASM1 oracle 244018 1 0 Jan08 ? 00:00:59 ora_pmon_vbsenopd ...
1
vote
2answers
769 views

Change Oracle user home directory at OS level after Oracle Databse/Client Software Installation

Can we change oracle user's home directory at OS level after Oracle Database/Client Software-Only installation? No database has been created yet. We want to change the home directory to /Oracle/...
1
vote
1answer
2k views

Installation of Oracle 11gR2 in Oracle Linux 7

Installation of Oracle 11gR2 is failed with below error, on Oracle Linux 7 OS. > INFO: Building Client Shared Libraries INFO: Building Client Shared > Libraries INFO: The output of this make ...
1
vote
1answer
221 views

Unable to start MongoDB with NUMA interleave

When I login to Mongo Shell in my production server, running Oracle Linux v7, I see the message: WARNING: You are running on a NUMA machine. To address this, I have used the init script as ...
-1
votes
2answers
698 views

Setting up Oracle XE on Linux

I'm trying to set up oracle-xe on my Linux machine. I just need an environment to play with Oracle SQL; this is not for production. When I try to start SQLPLUS I keep getting one of the following ...
0
votes
1answer
54 views

Completeness of Patch Population

I'm performing an audit on Oracle database changes and the database is on a Linux OS. After using the command opatch lsinventory, we learned that this command has not been pulling the complete ...
1
vote
1answer
607 views

Under what user does my process run on Oracle Linux?

We experience problems with directory access on some Oracle databases running on Linux. We have two kinds of processes that need to read/write files from a directory: 1 started in a user session, 2 ...
1
vote
0answers
310 views

popup windows doesnt showed on oracle OUI [duplicate]

I have a fresh vm station with the recent centos 7 with GUI (everything is standard). This problem happens on every popup window that appears on the oracle OUI, DBCA, ASMCA etc.. I'm using X to ...
2
votes
1answer
2k views

Environmental Variables for OracleDB 12 in Oracle Linux are Overriding Each Other with SQLPlus Variables

I want to set the environmental variables for OracleDB and SqlPlus properly. However, they are overriding each other. I'm doing something wrong, and I would like to get a hand finding where I went ...
2
votes
1answer
1k views

Import all csv files into a table oracle

Trying to import all the files into a table but I receive the following error. #!/bin/bash . ~/.bash_profile export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1 sqlldr USERID=user/pass@mydb ...
1
vote
2answers
110 views

Facing warning message while creating tar.gz file

I am creating a tar.gz of database hot backup files. During execution of tar command, I am getting this warning for only this file every time I run tar: /u01/app/oracle/oradata/db5/sysaux01.dbf: ...
0
votes
1answer
519 views

create additional oracle 11g database in linux

I have already created a database XE on my linux desktop.Please find the below information about the database. ORACLE_SID=XE ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/...
1
vote
5answers
3k views

Duplicate Oracle Database from Windows to Linux

I have a regular Oracle 12c database already created, named ECLS. I've been given a pile of .BKP files, not from this database, and have been told to replace everything in ECLS with the contents of ...
0
votes
1answer
2k views

How can I recover a dropped table which is not in the recycle bin?

I dropped a table yesterday and I want to restore it. I know that it's done with flashback but the table is not present in the recycle bin (yes it is set as ON). So how can I restore a table that is ...
7
votes
2answers
5k views

Oracle SQL Developer Textcursor disappearing [closed]

In the Oracle SQL Developer on my manjaro Linux, the blinking cursor in the editor area won't show anymore. I deleted everything of local config files (~/.sqldeveloper/) and reloads the program. At ...
0
votes
1answer
3k views

How can I free space in oracle mount point (/u01/app/oracle/)? [closed]

My question is what can I delete or how can I free space so that I can log onto oracle via sqlplus as sysdba. When I execute the command df -k to see the free space in the current directory it appears ...
-1
votes
2answers
64 views

How to add oracle license after installation

I have installed Oracle 11.2 Standard Edition on RHEL 7.0 with some other license. I have CSI number printed on License paper. Please guide me how to add that license.
0
votes
1answer
46k views

SP2-0667: Message file sp1<lang>.msb not found sqlplus oracle

I've a linux RedHat which contains oracle database. I setted all environnement variables, but when I running sqlplus command I've this error : SP2-0667: Message file sp1<lang>.msb not found ...
-1
votes
1answer
711 views

Import Oracle dump from Amazon RDS

I have successfully transferred my dump files to my RDS database instance based on http://d0.awsstatic.com/whitepapers/strategies-for-migrating-oracle-database-to-aws.pdf Now, I want to reverse ...
2
votes
4answers
44k views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux

I have configured oracle 12c on Rhel 7. When I try to connect database using following command it gets connected with no issues: sqlplus system/Forest123@orcl I'm facing problem when I try to put ...