Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-11g-r2]

Oracle Database 11g Release 2. Please also tag oracle for search purposes.

-2
votes
1answer
26 views

SUM HOURS BY PAY CODES

I am trying to total pay hours based from what is in a PAY_SUM_GRP. I have a query that will create a new line for each PAY_SUM_GRP for an employee, but I want just one record per employee with ...
0
votes
1answer
25 views

Why can i not call COUNT on a varray column in a select statement using oracle

I have a simple array type definition like this CREATE OR REPLACE TYPE "LIST_OF_NAMES_T" IS VARRAY(10) OF VARCHAR2 (100); Now I have a column items of type LIST_OF_NAMES_T in my table TABLE1 ...
0
votes
1answer
48 views

Oracle uses a lot of memory

OS: Windows Server 2012 DB: Oracle11g-r2 When you restart or turn on the server, everything works perfectly, the memory is normal, the number of sessions, too. But after 2-3 days of continuous ...
0
votes
0answers
14 views

os kernel parameter semmni failed: expected 128 found 0

I am trying to install Oracle 11gR2 on oracle linux 7. As per the documentation given in https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 there i think i have ...
-1
votes
1answer
49 views

Get the average of unique city to city distances

I tried to obtain the desired result with the following query: Select city1, city2, Avg(distance) from table group by city1, city2; ...but this SQL statement is resulting ...
0
votes
2answers
55 views

Select the oldest records in a table in Oracle [closed]

please, how can I select the oldest records in a table in oracle? and if it is possible to show them by date. Thank you
1
vote
2answers
40 views

How to copy database schema in the same database for testing purposes?

I need to copy... by any means, a schema of my database in that same database, let's say, I have SC1 and I have to duplicate it as SC2 without the data contained in SC1 (in the same database). How ...
0
votes
1answer
42 views

utlrp.sql fails to execute

I just created a docker image of Oracle 11g ee following this tutorial https://vitalflux.com/how-to-install-oracle-11g-ee-on-docker/ and loaded some tables inside. The process worked fine and no ...
1
vote
1answer
57 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 ...
0
votes
1answer
17 views

$X Tables Do Not Exist?

In troubleshooting why a database application is working infinitely better on test than production, I ran across this phenomenon: I cannot query the X$ tables in production. SQL> desc x$ksppi ...
0
votes
0answers
37 views

Silent install of Oracle XE 11g fails with error -3

I'm trying to install silently Oracle 11g XE in the default location (C:\oraclexe). PS D:\Profiles\xxx\Downloads\x.x\oraclexe\oraclexe-11.2.0> .\setup.exe /S /v/qn However, the command generates ...
0
votes
1answer
22 views

Where does Attunity's CDC services write error data?

We use Attunity's CDC services to move data from Oracle to SQL Server. Using the Oracle CDC Designer snap-in tool, I can see the current status of the service and an error message if a problem has ...
1
vote
1answer
30 views

How to Convert List of values datatype in oracle to equivalent or valid datatype in sql server?

I want to recreate the table below in SQL server I have tried using SSIS but it does not know how to handle the lOV Data type how can I recreate this table in SQL server and migrate the data to it. ...
1
vote
1answer
45 views

How to implement optional query parameters

I have a relatively big (10^7 rows and growing) table and I want to query some rows from it. Since table is this big - I want to use every perfomance boost that I can. My query has optional parameter ...
0
votes
1answer
15 views

External Table: VARCHAR in Create but CHAR in Access Parameters

Consider this SO Question UTF-8 And External Tables. A proposed solution contains VARCHAR2 columns in the CREATE section but those same columns get CHAR attributes in the ACCESS PARAMETERS section. ...
0
votes
2answers
42 views

Long query causes problems

I have a huge sql query which causes problems: select distinct subjectnr from proces where (produkttypenr = 1 or produkttypenr = 3 or produkttypenr = 4 or produkttypenr = 5 or produkttypenr = 9 or ...
4
votes
3answers
58 views

How can I pass on a value in the hierarchy based on the value of the parent using an hierarchial query?

I have a table with categories and another table with a discount for categories per user: create table category ( id NUMBER NOT NULL, parent_id NUMBER, name nvarchar2(255), PRIMARY KEY( id) )...
2
votes
2answers
43 views

Goldengate warning on table with primary key

Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below GGSCI (server01.localdomain as gguser@UPGR) 3> ...
0
votes
1answer
8 views

how to create an explain plan for the below query? I'm getting ORA-00900: invalid SQL statement error

I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain. Query: create or replace view TaskView as select T1.PersonID,T2.ID ,T2.Task from ...
0
votes
0answers
33 views

RAC DB Slowness - AWR Report

While going through the AWR report found that the row lock waits on indexes and buffer busy waits are more (rest of the stats look normal). Could someone tell me if we can interpret by the below if ...
0
votes
0answers
77 views

TNS-12560: TNS:protocol adapter error

I cannot access oracle from remote due to my listener error. I checked all configuration files which are listener.ora, tnsanmes.ora and sqlnet but I didn't find any missing config. Below is my ...
0
votes
1answer
48 views

Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck

oracle not install on centos7 while installation it is stuck at 84% no error msg showing
0
votes
0answers
48 views

Recommended ratios for SGA and PGA size in oracle 11g

I want to change the size of my SGA parameters SGA_MAX_SIZE and SGA_TARGET. And PGA _AGGREGATE_TARGET, what will be the ratio I should adopt to set these parameters in 11g. My current database ...
0
votes
1answer
58 views

Diakrites land wrong in Oracle database

Every time we are rolling out a new release same tables are trancated and filled with fresh data. This process is done on a Windows pc with scripts that are run in SqlPlus. When we do this on our ...
-1
votes
1answer
52 views

Composite index and Normal index,redundant/duplicate index - Incurred Performance penalty [closed]

Need suggestion on below indexes, whether our composite index is enough and can the normal index be removed. Scenario - We have ix4 and ix6 indexes as below, please review and advise if ix4 is ...
0
votes
1answer
47 views

Oracle Internal Error [closed]

Getting oracle Internal error in oracle database 11gr2: ORA 600 [kkpogppi1] It shows everyday in incidents but whenever i check oracle logs it shows nothing and when i open problem details it ...
1
vote
1answer
128 views

I need help creating an encrypted listener for my 11gR2 database using a wallet and SHA1 encryption

We are using 11.2.0.4. Since Oracle connections are not encrypted by default and access personally identifiable ( PII ) data in our application we are required to go to an encrypted listener. I am ...
1
vote
1answer
64 views

Whats the term in Oracle, when I'm speaking about SCHEMAS on SQL Server

Here, we have our applications developed both for oracle and SQL Server. Devs are trying to fix their own way to be organized, using VW on views, PR on procedures and etc. they told me that they're ...
1
vote
1answer
164 views

Error while installing Oracle 11g in Ubuntu 18.04

Also getting a runfixup.sh script which is also giving error root@szh-server:/tmp/CVU_11.2.0.1.0_zuman# ./runfixup.sh Response file being used is :./fixup.response Enable file being used is :./fixup....
0
votes
3answers
49 views

Database Migration [closed]

We are migrating our one of testing servers. My questions are: What is a best way to migrate database from one server to another? If I do data migration through export/import utility (Full database ...
0
votes
2answers
192 views

Safe to use SQLNET.ALLOWED_LOGON_VERSION_SERVER in 11g sqlnet.ora file?

I have a mixed environment running both 11g and 12c databases on the same server. One of our databases was recently upgraded to 12c, and the older Oracle clients have started throwing ORA-28040 ...
0
votes
1answer
35 views

Always start Oracle DB in Idle State

Is there a way to setup your Oracle db to always be brought up in an idle state so that you can then 'startup' when you want to use it. I'm running Oracle 11g R2 on Windows with lean resources.
2
votes
1answer
46 views

How to copy a tablespace to another database without using Data Pump in Oracle 11G

I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
1
vote
2answers
61 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
2answers
92 views

Creating Dictionary Management Tablespace Oracle [closed]

i am stuck at creating a dictionary management tablespace in 11g Release 2 Oracle 32 bit , I can't create a normal tablespace with dictionary management because my System tablespace is locally ...
0
votes
1answer
43 views

In a database trigger on event create - How do I reference the created object?

Given the following trigger: CREATE OR REPLACE TRIGGER TRG_CREATE_TABLE_INITRANS AFTER CREATE ON SCHEMA BEGIN IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN exec 'alter table '||<table_owner&...
3
votes
1answer
142 views

How do I restore an Oracle file system backup onto a new developer machine?

A server (not mine) has died due motherboard temperature problems and disk controller problems. Given that the company's IT support should have known better, and so on, the company does have a file ...
1
vote
0answers
32 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
2
votes
2answers
102 views

How can to make a new user see table in existing schema [closed]

I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this ...
1
vote
2answers
41 views

How to configure Oracle11g to send out Password Expiry Notifications vide SMS or e-mail?

Please guide me in configuring Oracle11g to send out Password Expiry Notifications vide SMS or e-mail before password expiry of one week or upon user's profile entering into grace period or any other ...
0
votes
1answer
129 views

Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?

I understand that we can use '' to escape a single quote in Oracle queries. However, I want to know if it is feasible to escape a single quote in the ESCAPE clause. set up: create table test_t ( x ...
1
vote
1answer
32 views

Oracle 11g - DROP database command on ACFS

In Oracle 11g and higher (on RHEL 6) issuing the 'drop database' command in mount restrict mode will delete all the DB's ASM datafiles. Can somebody tell me if this command also drops all ACFS ...
0
votes
1answer
268 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 -...
-1
votes
1answer
67 views

How to export response file from already installed Oracle database?

I know that I can follow the steps of Oracle Universal Installer (OUI) and choose to save a response file at the end (summary step) to use it in further silent installation, but is there a way to ...
1
vote
1answer
133 views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
0
votes
1answer
46 views

How to run EM of Oracle 11g, if i haven't emctl, netmgr, dbca, OracleDBConsole<SID>?

I don't know what is wrong with my Oracle 11g, but it is missing a lot of things. After reinstallation it stays the same. My overall path is like C:\oraclexe\app\oracle and after it there are folders ...
0
votes
1answer
64 views

How to delete a datafile if the father-tablespace does not exists? [closed]

I just know Oracle basic and I would like to know about the datafiles. I have some files ".dbf" associated with Tablespace that already were deleted. I don't know how I can drop that datafiles and ...
0
votes
2answers
580 views

How to export dump of some schemas exclude some tables

I need to find the way make an quick and light weight dump export. It is the reason why I want to export only specific scheme and to exclude large tables. I use Enterprise Manager for it. Data ...
1
vote
1answer
81 views

SELECT all the children of a row and concat

I have this requirement that I need to attach a new column in select statement. It holds a string series of the disp_order of its children. I currently have the SQL statement only for the immediate ...
0
votes
1answer
65 views

Unable to connect to oracle database. Getting ORA12505 error

I am newbie to ORCALE I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help An error was encountered ...