Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

Filter by
Sorted by
Tagged with
1
vote
2answers
30 views

Running Oracle's sqlldr on VirtualBox VM from my MacBook (client) machine

:) I'm not even CLOSE to a DBA, just an engineer that finds myself learning Oracle. Any help is much appreciated! Here's my question (which is a lot simpler than the sea of words which follow would ...
0
votes
1answer
269 views

How to view databases and tables after 'imp' import using Oracle SQL developer

Maybe that's a wrong form of answer... The problem is: I've got an Oracle database dump file (very old, created with imp utility) At last, I've imported it. The command was imp file=E:\Downloads\...
2
votes
1answer
89 views

Non-standard number data types in Oracle

I'm not sure that this question belongs to this StackExchange. I've asked this question on StackOverflow: Besides the "usual" number data type where precision is greater then scale there ...
0
votes
1answer
19 views

Designing User & its Sub User Database Diagram Problem [duplicate]

There are some business category e.g. Travel Agency, Hotel, Car Rental etc. Roles: Management rolesSuper Admin, Staff Customer side roles are Owner, admin and sales counter May be etc. customer side ...
1
vote
2answers
2k views

Is DBSNMP used only by Oracle EM by default?

I have Oracle database and I need to install agent for Oracle EM. It requires credentials for DBSNMP user, but it was lost. Is it safe to change password via SYS user to provide it to agent? Is there ...
0
votes
1answer
42 views

Changing the grid listener port of an Oracle Database Appliance

I need to add an extra Port: 1522 Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/xxxx/listener/alert/log.xml Listening ...
1
vote
3answers
412 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
-1
votes
1answer
91 views

CREATE VIEW WITH LEFT JOIN - FILTER RIGHT DEPENDING ON LEFT

I am using Oracle 12.1. I have the following tables, simplified for the question : (Note that the XXX for entity ID does represent the same ID being repeated) Events date_event | entity_id | used -----...
0
votes
0answers
19 views

Which blocking session is shown in Oracle 12c in V$SESSION, when wait event is “enq: TX - allocate ITL entry”?

We created a testcase on Oracle 12.1 as consequence of totally stucking application because of endless "enq: TX - allocate ITL entry" in a scenario with about 50 parallel processes. Each of ...
1
vote
2answers
551 views

java.sql.SQLException: ORA-01410: invalid ROWID

I am getting java.sql.SQLException: ORA-01410: invalid ROWID for some of the rows. Here is my query. "select OP.PLU_LONG PROD_ID," + "OP.NEW_PRICE PRICE," + ...
0
votes
1answer
222 views

Oracle 12c create manual script for automatic startup on RHEL7

I need to create a script to start and shut down a 12c database in rhel7 automatically when the operating system starts and shuts down, it turns out that I have tried the common options with dbstart ...
0
votes
1answer
265 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
2
votes
1answer
28k views

Oracle 11g Rman restore with another database name from backup in windows platform

Can anyone share the proper method of RMAN restore to another server with another database name in oracle 11g(Windows platform). I'm totally confused with all the RMAN restore methods which I've found....
1
vote
0answers
10 views

ODI remove auto lock when object / datastore is opened

I was being stupid and enabled automatically lock object during edit / opened when I was asked the first time. Now I want to remove the automatically lock from GUI but I couldn't seem to find it. I ...
0
votes
0answers
20 views

Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time

I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)). There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
2
votes
1answer
11k views

Removing locks in Oracle without being admin

3 wild sessions each got a row exclusive lock in the same table: SELECT * FROM DBA_DML_LOCKS; How can I remove the lock without being admin? If I was admin I would list (SID, SERIAL#) of the ...
1
vote
2answers
43 views

Ramifications of Full SYSAUX - Oracle

What are the ramifications of having a full or almost nearly full SYSAUX tablespace (Oracle 19c)? There are plenty of sites discussing how to view the SYSAUX occupants, to reduce the size of SYSAUX ...
2
votes
1answer
557 views

Oracle sys SYSDBA audit information to a report

I am trying to produce a monthly report on Audit. I am able to query the DBA_AUDIT_TRAIL, for all other users and no issue in that. I wanted to include the SYS/SYSDBA activities in this report and ...
3
votes
3answers
9k views

Oracle.exe (SHAD) process keeps increasing

I have an Oracle Server 11g that we use for integration tests. For some reason, the processes count [select count(*) from v$process;] keeps increasing up to the limit, causing ORA-12514: TNS:listener ...
0
votes
1answer
455 views

“ORA-03146: invalid buffer length for TTC field” after upgrade from Oracle 12 to 19c

We are experiencing problems with updating a table record BLOB column. We get the "ORA-03146: invalid buffer length for TTC field" error. We basically are saving e.g. PDF attachments to the ...
0
votes
2answers
273 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question is ...
0
votes
0answers
179 views

Restricted session in rac environment

Is there some way to issue a restricted session command in all RAC instances? something like this: Alter system enable restricted session sid = '*'
0
votes
1answer
190 views

Insert data into oracle table with loop?

How to use sql to insert line detail data into header with the output like below. line detail MO_ID SEQ_NO QTY LEVEL 121M 2 3 121M 3 9 125M 2 6 125M 3 7 125M ...
1
vote
1answer
2k views

Oracle 12c Database swapping after set up huge pages

I need to setup a Oracle Database 12c with 64GB RAM on Linux RedHet. I decided to use huge pages. Something must have went wrong. Altertlog: WARNING: Heavy swapping observed on system in last 5 ...
0
votes
0answers
38 views

Oracle 19c with SAP System - ORA-12154: TNS:could not resolve the connect identifier specified For Physical Standby

Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side. Outputs from primary side: SQL> select status, error from v$archive_dest where dest_id=2; ...
1
vote
1answer
253 views

Is it possible to show DML that is locking some table?

I already saw here how I can list my locked objects. Suppose I, using PL/SQL Developer(pink cylinder logo one), run select * from someTable for update and didn't commit nor rollback. Now using the ...
0
votes
1answer
566 views

Oracle JDBC TLS connection fails (handshake_failure) after OS upgrade

I have an Oracle Database 12.1 server running on Oracle Linux 6. Secure (TLS) connections were working fine until I decided to update the underlying operating system (yum update) and reboot the ...
1
vote
1answer
25 views

Select all rows that have all of the following column values

I have the following tables Genres, Films, Directors. They have the following schema: CREATE TABLE GENRES( GID INTEGER PRIMARY KEY, GENRE VARCHAR(20) UNIQUE NOT NULL ); CREATE TABLE Films( ...
1
vote
1answer
357 views

Cloning a PDB from one CDB into another CDB with TDE enabled at source and target

What are the possible ways to Clone a PDB from one CDB into another CDB (in a different host) with TDE enabled at both source and target. At present i am able to think of the following two a) Data ...
0
votes
1answer
1k views

Create User, Tablespace Replication in Oracle GoldenGate

How to replicate - Create User, Procedure and Tablespace using Oracle GoldenGate. I am able to replicate DDL under schema, however above is not getting replicated i.e. when I create an user, ...
0
votes
1answer
317 views

How to exceute view without DBLink in oracle server

I have 2 views, example V1 from Database DB1 , V2 from database DB2, these 2 database server are remotely configured, I can able to execute these views separately without database link in the ...
1
vote
1answer
696 views

ORA-02270: Error report: no matching unique or primary key for this column list

I have created two tables: CREATE TABLE team ( teamname VARCHAR2(30) NOT NULL, carndate DATE NOT NULL, teamnomembers NUMBER(2) NOT NULL, charname VARCHAR2(30), ...
0
votes
1answer
21 views

How to check if a client can use windows authentication

My ORACLE (10g) sqlnet.ora has SQLNET.AUTHENTICATION_SERVICES=(NTS). I need to validate that no client is using Windows authentication to connect. What can I check next to make sure they don't ?
0
votes
1answer
23 views

drop datafile in RECOVER status

I have a datafile in a recover state: SQL> select status from v$datafile where file#=201; STATUS --------------------- RECOVER I'm not really sure how it was damaged, looks like something went ...
0
votes
1answer
91 views

Oracle - Delete dmp files from ASM diskgroup

I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it. ASMCMD> ls exp1.dmp exp2.dmp exp3.dmp exp4.dmp ASMCMD> pwd +DATA/EXP How ...
3
votes
1answer
363 views

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the ...
2
votes
2answers
7k views

Can you have multiple Oracle ACL files?

I have an application which needs to send emails through Oracle triggers. I understand that in Oracle 11g you must have an ACL file to grant certain schemas access to the network. My plan was to ...
0
votes
2answers
175 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ....
0
votes
1answer
670 views

Insert Into queries take too much time in Apache spark

I am using Oracle Database with Apache spark 2.3.0 In my code I am writing final output (after all the processing) in three tables using below spark command. billableChargeKDF.write().mode("append")....
1
vote
1answer
31 views

Getting the latest timestamp in Oracle

I am trying to create a report that has the latest member id in the first column and the old member id in the second column based on the timestamp in audits table below. Member ids are stored in ...
0
votes
1answer
18 views

SQL - Get the values of another column for values in a given column

I am working with a large data table. I want to check the individual items with their destination and the count of destinations if there are more than 1 destination for a given item. So in the below ...
4
votes
1answer
4k views

Oracle Database Server TNS Listener Remote Registration Vulnerability (CVE-2012-1675)

Some of our Internal DBs Oracle installed in Linux and Windows servers have been highlighted with the issue Oracle TNS Listener Remote Poisoning (CVE-2012-1675). This security alert addresses the ...
0
votes
1answer
35 views

Error when using DBCA to create database Oracle XE 18c

I am trying to create a new database using dbca. Windows 10. Please help me to find solution. Here is the log
0
votes
1answer
23 views

Restart ORACLE OHAS without restarting databases

looks like ohasd is getting to much memory (memory leak or something) that cause heavy swapping, is it possible to restart OHAS (till patch is applied) without bouncing databases? "crsctl stop ...
0
votes
2answers
82 views

Report based on MV: Deliberately make the report fail if MV is out of date?

I have a query that is used in a BIRT report (in IBM's Maximo Asset Management platform). I'm considering storing the query in a materialized view in order to improve performance and reduce the load ...
0
votes
1answer
25 views

User Permisssions White List vs Black List

I have Applications, Roles, Users, Permissions, Application_Permissions, User_Permissions, Role_Permissions, Application_Roles and Role_Permissions tables. So, permission can be defined at application ...
1
vote
0answers
46 views

How to improve Oracle Standard Edition's performance for testing? [closed]

There's a great post on StackOverflow about improving Postgres performance for testing. https://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940 However, ...
1
vote
1answer
293 views

Can't create a Database on Oracle 11g

I'm new on Oracle and I'm trying to create a new database. I followed tutorials online but the problem seems to be in Windows and not in Oracle. I'm using the Oracle assistant to build my Database ...
1
vote
1answer
774 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
1
vote
1answer
153 views

Are there security-issues with a read-only-account on Oracle-DBs?

I am currently working as IT-maintenance-guy for a classic MVC-system(oracle-db/jboss) at public sector. The newest feature should be the shutdown of my oracle-db-readOnly-Account cause of "security ...

1
2 3 4 5
142