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.

1
vote
0answers
9 views

How to change permissions of Oracle generated logs?

The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions ...
0
votes
0answers
24 views

Physical memory usage of Oracle 11g

We are setting up a new server with Oracle database (Oracle 11g r2) for our ERP application. The new server is on VMWare, 256 GB RAM, 48 vCPUs, and SSD SAN storage (RAID 10) connected directly to the ...
0
votes
1answer
12 views

Getting TNS Name from connection string

I normally connect to my Oracle database at work using a connection string. Other then the obvious answer of asking the DBA what it is, using SQL Developer or some other tool can I find out what the ...
0
votes
0answers
22 views

When establishing access to data on a remote database, are views or synonyms preferred?

Consider a scenario where you have two databases: On database A you need to access data on database B. You could create a view on database A that selects from the table on database B. CREATE OR ...
0
votes
1answer
57 views

Not all variables bound ORA-01008: not all variables bound error

I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, ...
3
votes
1answer
38 views

Using MVIEWS to take in time data snapshot of tables

I have a requirement where I have to Load data periodically from more than 100 tables of an OLTP oracle database into MS SQL database. In my solution I want to use MVIEWs of these tables with Fast ...
0
votes
0answers
31 views

CPU usage high after os oracle password change

Oracle 11.2.0.4 Exadata (we're relatively new to exadata still) I had something strange happen this morning and the OS user oracle password expired. This meant that cronjobs wouldn't run was the ...
0
votes
1answer
22 views

Oracle 11g RAC - PSU

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough? Thank you in advance
1
vote
1answer
20 views

Oracle SQL 11gR2 => find out all dates where “impdp” was performed

Hello my team performed several database Data Pump Import "impdp" over the last two years. The workflow was always to import all "application" schemas ( The schemas that are used from our ...
0
votes
1answer
14 views

During table migration of tables from one tablespace to another, does it needs free space to do the alter table move?

During migration of tables from one tablespace to another (all datafiles in the same disk/partition/mount), does it needs free space to do the alter table move? exemple:. I have 30gb of free space on ...
0
votes
2answers
37 views

Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)

I've been trying to search for this info on oracle documents but they just don't talk about it. I need to move about 2TB of different tables from 3 different tablespaces to a new tablespace (...
0
votes
1answer
20 views

Using JOINS in QUERY clause in EXPDP

I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table....
1
vote
2answers
53 views

Run shell script on Oracle 11g

I have an oracle database: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for Linux: Version 11.2.0.1.0 - ...
0
votes
1answer
47 views

Optimizer choosing a bad index

I have a pretty simple select statement, select column 4 from table_x where column1=:1 and column2=:2 and column3=:3 Columns 1,2 and 3 make up the primary key on the table. For some reason, ...
0
votes
0answers
48 views

How to manage Oracle diagnostics logs not managed by adrci?

How can I identify Oracle log files that are not managed by adrci? I wish to manage disk space usage, in a similar scenario to this article: "How to free up disk space? which logs/directories to ...
0
votes
0answers
15 views

Exporting Multiple, Multi Level BOMs using Bind Variables

I am trying to create a master export of all of our active Manufacturing BOM's. What I am hoping someone can help we with is how to combine these two queries so it will perform, loop? through the each ...
0
votes
0answers
50 views

Rman, Create two Incrementally Updating Backups

I am using the following rman (Oracle11gR2) commands to create an Incrementally Updating Backup Copy RUN { RECOVER COPY OF DATABASE WITH TAG 'incr_update; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER ...
0
votes
3answers
75 views

How to grant user to dbms_crypto ?? Oracle (User which created inside SYSTEM)

Couldn't find user I tried this grant execute on sys.dbms_crypto to "DB_Project"; But error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" Also tried this:...
0
votes
0answers
13 views

How many keys does wallet keystore have?

I my scenario I have configure transparent data encryption with password based software keystore only for example 'ewallet.p12' and create a master key for software keystore. I want to know can we ...
0
votes
1answer
19 views

Oracle Loop through values from one table and join with another table

I have a table (table1) with fields package_id and contract_id. Data in table 1 is like that 1 package_id can have 1 or more contract_id associated with it. I have another table (table2) with ...
0
votes
2answers
70 views

Welcome message for oracle schema

I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only
0
votes
1answer
18 views

Does tables under schema uses multiple tablespaces other than default tablespace

I have schema 'A' in a database and assigned a default tablespace as "myspace". There are 20 tables resides under single schema and all tables are using different tablespaces.Here my doubt is "Why ...
0
votes
0answers
30 views

Restrict Oracle database schema to login using Toad/PLSQL [duplicate]

I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
0
votes
1answer
28 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
50 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
70 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
52 views

Get the average of unique city to city distances [closed]

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
124 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
45 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
86 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
70 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
49 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
53 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
39 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
33 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
29 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
46 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
63 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
83 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
11 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
36 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
160 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
128 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
139 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
60 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
59 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
56 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
162 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
66 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 ...