Questions tagged [oracle-11g-r2]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
2k views

Sequence number shows a lower value after dump file import

I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my ...
0
votes
1answer
86 views

Changes to Oracle EM 11G Database Control “Availability >> Backup Settings” don't stick

Trying to configure Enterprise Manager 11G Database Control for backups for the first time. Whenever I navigate to Availability >> Backup Settings >> Policy tab and try to make a change,...
1
vote
1answer
416 views

Oracle 11.2.0.4: Basic info using RMAN for backups

I'm fairly new to databases. If I plan to use RMAN in archivelog mode to perform full backups each week plus incremental backups (retaining only the last 2 full backups for redundancy), how must I ...
1
vote
1answer
516 views

Oracle 11.2: Backup and recovery strategy based on full cold backup plus expdp

Are there any issues with the following strategy for backup/recovery in Oracle 11.2.0.4? Perform a full database cold backup once a month, moving the file off the server for safekeeping. Write a cron ...
1
vote
1answer
250 views

Create FAST Materialised View in Oracle 10g with ROWID

I want to create FAST refresh the below Materialized view through rowID method. `CREATE MATERIALIZED VIEW XXARG_ACC_ANALYSIS REFRESH FAST ON DEMAND AS SELECT gjb.name "Batch_Name", gjs....
1
vote
1answer
1k views

Configure Oracle 11.2+ ACL to work with mail server having an internal IP address

I configured a new Oracle 11.2.0.4 database on CentOS 7. I verified that I can send email from the database server 192.168.0.1's linux command line, using an 192.168.0.2 mail server (e.g. mail....
3
votes
1answer
127 views

Allow refresh of lower environment from production when using a HSM

We currently use an Oracle Wallet for Transparent Data Encryption of certain critical columns and are migrating to a HSM for compliance reasons. Our issue is how to handle encryption on the ...
2
votes
1answer
33 views

Default new record value from the table

If I had a table called person with the fk country_id. Assuming that we have a table called country, which has a default_country column. And all rows except one (for USA), have default_country set to ...
5
votes
2answers
8k views

How to change the path of temp file,redo log file when restore an rman backup on another machine?

I am trying to migrate my database (11.2.0.4) A to another machine by using rman backup. At present, in the source machine, the redo log file, temp file is stored under the directory foo (/foo). In ...
1
vote
1answer
847 views

Query on SCAN in RAC

I have a two node RAC (Oracle 12c) on linux. I have 5 SCAN listeners configured. Currently, if I do a srvctl config scan I notice that out of the 5 scan listeners, one scan is running in one node ...
0
votes
1answer
645 views

Problems connecting remotely to a RAC DB via sqlplus

When I create a user in an 11204 single instance DB and afterwards grant the sysdba privilege to that user I can connect remotely without any problems using: sqlplus testuser/testuserpwd@testdb as ...
2
votes
1answer
16k views

Oracle - Search a value in all columns of a table

Here is my issue. I have a Oracle table which contains 53 columns. And i would like to do a search for a value for all columns. And i do not want to put all columns in the where conditions. Is ...
0
votes
1answer
338 views

ORACLE RAC Installation : Why there is a need to create a symbolic links for asm disk

By reading the note 1538626.1 from MOS Meta Link, I know that we should use udev to change the ownership of some device for the further installation of oracle real application cluster: I met a lot of ...
1
vote
1answer
32 views

Can a killed application process cause blocking of the server?

We use an application made by HPE which blocks completely from time to time. The application comes with Java 6, uses ojdbc6 and connects to Oracle 11. HPE claims that when one of our 6 application ...
0
votes
1answer
144 views

Find jobs and dependencies run between two timestamps

I would like to know what jobs ran and dependencies (what triggered them) between two timestamps or dates. I have been looking in all the oracle views. I cannot find anything like this in the ...
2
votes
1answer
2k views

Oracle: Not able to create tablespace from stored procedure

I am trying to create tablespace from stored procedure. create or replace procedure testprc is query_string VARCHAR2(4000); tbs_name VARCHAR2(20):='test77'; begin dbms_output.put_line('test..'); ...
1
vote
0answers
395 views

Oracle DB link: Error line missing

We have a DB link between 2 Oracle 11.2 databases. On the production system, we noticed that when an UPDATE statement of a remote table fails in an PL/SQL procedure (started as a scheduled job), the ...
-3
votes
1answer
52 views

While doing client server connection i am geting this error TNS-12535

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-DEC-2016 16:57:44 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: D:\app\jayraj\product\11.2....
4
votes
1answer
3k views

Snapshot too old from materialized view refresh job

This Oracle database has a DBMS_JOB that runs the following materialized view refresh script : dbms_refresh.refresh(ABCD.V_POSTAL_CODES); If I run it by hand, it's finebut if the job executes it a ...
0
votes
1answer
96 views

How can I manage PL/SQL package source at the method level?

In our ERP application suite, we have a very small number of PL/SQL packages that are large and monolithic in nature, containing a wide assortment of functionality. (This is because each package ...
0
votes
0answers
315 views

Issue with RAC connection using service

I have a two node RAC database. I have created a server side service as below: srvctl config service -d test -s testsrv Service name: test Server pool: Cardinality: 2 Disconnect: false Service role: ...
0
votes
1answer
234 views

Why Java Pool is not a required component of Oracle SGA?

Why Java Pool is not a required component of Oracle SGA? As we know SGA has many components, I mean: Java Pool Shared pool Large Pool Data Buffer cache Others... I took an exam and I saw that ...
0
votes
1answer
32 views

Force standby de-synchronisation for script testing

Two databases are configured in a production-standby configuration with Oracle Dataguard. I want to test a script that supposedly detects whether the dataguard observer is in the status SYNCHRONIZED ...
0
votes
1answer
57 views

Failover query in RAC

Say I have the following tnsnames.ora in my two node RAC database, DIVTEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DIVTEST-scan.DIVCORP.com)(PORT = 1721)) (CONNECT_DATA = (SERVER = ...
1
vote
1answer
46 views

Get row value inside a subquery

I need to count days between dates. I have this query, that gets the date when an issue is resolved. The subquery selects the date when a issue is created. The problem is that the subquery the dates ...
0
votes
1answer
1k views

How to delete archive log on just one dest?

I have two archive_log_dest, I need to delete archivelog on dest1 until today. I need to keep on archive_log_dest2 all archive. How can I do that with rman?
0
votes
1answer
6k views

Is Oracle 11g database supported in windows 10?

When I tried to install oracle 11g on Windows 10 Home. I got the below error after the wizard started the installation: ORA-03113: end-of-file on communication channel. I tried in another PC also ...
0
votes
1answer
606 views

History of User privileges held

In Oracle 12c or 11g, is it possible to fetch the history of user privileges held by a schema? Say from last two months, I might have granted different roles and privileges. I can get the current ...
0
votes
1answer
156 views

Oracle Data Guard:When would data rows exist in the view v$archive_gap?

I am trying to learn how to resolve the gap between primary and standby manually, the version of my oracle database is 11gr2. What I did as follow: At the beginning, primary and standby is ...
3
votes
1answer
320 views

Oracle DB Security Issue: Anyone can login using SQL*PLUS, with any username, and any wrong passphrase

I'm using Oracle DB 11g-R2 on CentOS 6.4, and unfortunately there is a terrible issue freaking me out. Anyone can login using SQL*PLUS, with any username, and any wrong passphrase. Consider somebody ...
0
votes
1answer
3k views

Oracle auditing on specific user activity

I want to be able audit user 'SCOTT' on 'SELECT, INSERT, UPDATE, DELETE' dml operations across all objects in the database SCOTT has access to. I'm familiar with dbms_fga but I can't achieve what I'd ...
2
votes
2answers
5k views

How to find number of user connections to an Oracle database between a specific time period?

I want to find how many users established connections to the oracle 11g database in a 10 minute time interval. Please help
0
votes
1answer
99 views

Order by after concatenating columns

After concatenating column how do i order by using one of the columns? Below is select statement i was trying to come up with. SELECT * FROM (with tbl_demo AS (SELECT eod_date, branch_code ...
0
votes
1answer
412 views

PLSQL: Package stored procedure cannot call exe imediate statement

I'm working with oracle 11g R2. Issue: I am unable to preform dynamic SQL in SchemaB package against SchemaA tables. SchemaB is being called by the owner of SchemaB. Background: I have a package/...
1
vote
1answer
1k views

Oracle Data Guard:Can archived redo log files be sent from primary database to physical standby database manually?

As a result of the configuration of firewall,the primary database can`t not send the archived redo log to physical standby database in real time,the network connection between primary and physical ...
0
votes
1answer
325 views

Can I create alert on ora-20118 from Enterprise Manager?

Can I create an alert on a user-defined ORA- error? I want EM to notify me when the following error happens: begin raise_application_error(-20118, 'myerror'); end; /
3
votes
1answer
4k views

Oracle Data Pump, pause a job

I currently have a impdp job running for a fairly large schema (2TB) and ran into an error. The source database has one column that is larger then the destination database. This is causing ORA-02374 ...
1
vote
1answer
2k views

alter public database link to private in oracle

I have a database link in my database which is created as public as below. CREATE PUBLIC DATABASE LINK dblink_name CONNECT TO usernane USING 'tag'; I have a requirement to convert it to a PRIVATE ...
1
vote
1answer
362 views

Oracle 11.2.0.4 — “sofar” increasing slowly in V$SESSION_LONGOPS

I am running a long-running query, and it seems to be "stuck" on this operation here: http://i.stack.imgur.com/MPnFB.png From v$session_longops, the value of "SOFAR" seems to be increasing at 2-3 ...
5
votes
1answer
254 views

moving table to another tablespace in primary server oracle 11g

What will be the effect on dataguard configuration when moving one table to another tablespace using the impdp remap_tablespace parameter? In our production environment we have setup dataguard and I ...
2
votes
0answers
2k views

Oracle 11.2.0.4 — sql_id not found in v$sql or v$session

I was looking in v$session_longops and found an operation currently being run and its corresponding SQL_ID SELECT sql_id, sid, to_char(start_time,'hh24:mi:ss') stime, time_remaining, message,( sofar/...
1
vote
0answers
292 views

No Tablespace found during dump import

Original Question: Oracle dump imported with zero rows I have exported the oracle dump from source by using exp username/password file=filepath/filname.dump I tried to import the exported dump ...
0
votes
1answer
56 views

Database sessions

When I am executing the query: select count(*),type from v$session group by type; then I get the following output: count(*) type ---------------- 1 User 22 Background What does ...
3
votes
1answer
8k views

How to find user who Drop any thing without auditing applied on database

In my scenario, I have a database with no flashback on, Only Archivelogs are active. No Auditing applied on database. 3 days ago some one drop all triggers, views, sequence from a specific user. Now ...
1
vote
1answer
1k views

Oracle 11GR2 - When will datafile autoextend?

Let's say I have a single datafile, DF1. After DF1 becomes 50% full, I add a new datafile DF2 of equal size. Both datafiles have autoextend set to ON. When file DF1 becomes full (and therefore, DF2 ...
1
vote
1answer
817 views

EXPDP snapshot too old live monitoring

The likely errors that raises "snapshot too old"s during datapump export are well documented all over the internet such as : undo_retention parameter being too short redo logs groups are too small or ...
2
votes
2answers
3k views

Oracle restrict user to use USERS tablespace

I have a schema 'TEST' that schema has own tablespace 'TEST'. But when I create index on USERS tablespace, it created. How can I restrict to use USERS tablespace in ORACLE database? CREATE UNIQUE ...
0
votes
1answer
466 views

What is meant by Account is disabled in dba_users password column for account status as locked?

When querying dba_views, for some of the users the password column shows account disabled. These users are locked accounts as account_status column says. I want to understand what is meant by account ...
3
votes
1answer
237 views

What is a secure strategy for managing login/passwords used in a powershell script

I have several Powershell scripts that need to write data to an Oracle database. I do not want to hard-code the login credentials. When connecting to SQL Server I rely on windows authentication ...
1
vote
1answer
8k views

How to identify all queries in a pending transaction in Oracle?

Let's say I have a pending transaction that shows in select * from v$transaction. Is there a way to identify all queries executed so far in the pending transaction?