We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [oracle-11g-r2]

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

224 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
2answers
2k views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
5
votes
2answers
2k views

Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?

Oracle SQL Developer (I'm using v3.2) has a feature called "DB Doc", which generates documentation for database objects. I mostly want to use it to generate documentation for my stored procedures, ...
4
votes
2answers
29k views

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ==============================...
4
votes
1answer
2k views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
3
votes
1answer
96 views

Alert on Table size

I need to create an alert on my application table when it reaches 98% of its threshold. I wrote an SP which checks the rows and logs the information into a log file which was monitored by alert system ...
3
votes
0answers
288 views

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: ...
3
votes
0answers
560 views

plsql procedure gets invalidated

procedure involving dblinks gets invalidated regularly .we need to recompile every time.How to find what is causing the problem in my case procedure p1()--resides in db1 is begin .... select col1 ...
2
votes
0answers
108 views

Upgrading Oracle ODBC driver from 11 to 12 causing code to fail

In the process of replacing our servers which involves updating the Oracle ODBC drivers from 11 to 12. We have a process that executes on these servers that calls a stored procedure. The procedure ...
2
votes
1answer
3k views

Why create a Materialized View Log with Primary Key or RowID, etc?

I have a table with 600million rows. I want to create a materialized view that filters it down to 50 million records but also uses REFRESH FAST ON COMMIT. To use REFRESH FAST I need a MATERIALIZED ...
2
votes
1answer
1k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
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/...
2
votes
1answer
68 views

How should I store a large number of dynamically generated heterogeneous tables?

I'm a developer on a reporting application that runs complex user-defined queries, stores the results, and then sends the result to Excel generation, web-based tables, and graphs, and so on. Currently,...
2
votes
1answer
276 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
0answers
334 views

Oracle in hyper-convergence system

How does Oracle perform in hyperconvergence systems such as nutanix, simplivity? Oracle doesn't certify the underlying storage which nutanix or simplivity offers (file level storage) but in reality ...
2
votes
0answers
340 views

Does oracle workspace manager work with oracle xe 11g

According to this forum it can be using a patch but I need a support identifier to access patches. https://community.oracle.com/thread/340084?start=0&tstart=0 This describes how to install ...
2
votes
0answers
713 views

SELECT stuck giving results from the query result cache, though table has changed

A process that runs every two minutes or so started to misbehave. We noticed it was because the cursor fetched repeatedly 0 rows, even if indeed there were new rows satisfying the conditions in the ...
2
votes
0answers
1k views

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the ...
2
votes
0answers
10k views

TNS-01190: The user is not authorized to execute the requested listener command

Oracle 11g Release 2 Oracle Linux Enterprise 5.10 [oracle@dub-ImrORA3 scripts]$ id oracle uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba),504(oper) context=user_u:system_r:...
2
votes
0answers
289 views

Should an SCN obtained from one RAC node be immediately usable on other RAC nodes?

I'm seeing ORA-08181: specified number is not a valid system change number and don't understand why. The error happens around once a month from a process that runs every few minutes - so very rarely. ...
2
votes
0answers
2k views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
2
votes
0answers
3k views

Oracle Scheduled Job Stays in State RUNNING

I have an Oracle 11.2g on which I use Scheduled Jobs to get some regular work done. There are around 15 jobs running 24/7. The time interval at which those jobs run varies between 1 second for some ...
2
votes
0answers
123 views

Attaching Existing Oracle Home to fresh Windows Install

I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
2
votes
0answers
4k views

'oracle.jdbc.driver.OracleSQLException': ORA-01031: insufficient privileges. (SYS.DBMS_XMLSAVE)

I have this function (written here by someone), placed in the package ENVER.ENCODING_VERIFIER: FUNCTION loadxml_table (p_owner IN VARCHAR2, p_tablename IN VARCHAR2, p_format IN VARCHAR2, p_tmpClob IN ...
2
votes
0answers
2k views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. *********************************...
2
votes
1answer
227 views

Listener is not starting in my Standby database

I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below: C:\Windows\system32>lsnrctl start LSNRCTL for ...
1
vote
0answers
26 views

Oracle Still Auditing after NOAUDIT

We're redoing what is and isn't being auditing in a database my team has been put in charge of. Old audit settings were producing ~2M audit entries a day. Audit_trail parameter is set to DB. So we ...
1
vote
0answers
14 views

Problems with Standalone grid : Cannot start database with srvctl, Enterprise manager cannot find listener

First of all, thanks for your time and effort on this, I've been looking into this problem for about two weeks but still haven't figured it out yet. I know it might be due to different root causes, ...
1
vote
1answer
36 views

Give me suggestion about backup of schema and full backup in oracle

I need your help about backup in oracle database. Currently I am using Export Utility of Schema Backup but taking more time to complete and size is 40GB. For full database backup using Image Copy and ...
1
vote
0answers
617 views

Oracle listener give “Message 850 not found; No message file for product=network, facility=NL”

I'have just completed oracle 11g database software installation on Linux. I launched netca and configured a listener. As soon as I try to run lsnrctl I get the following error. [oracle@lnx-db ~]$ ...
1
vote
0answers
50 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 ...
1
vote
1answer
44 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
2answers
175 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
vote
0answers
52 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 ...
1
vote
1answer
750 views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
1
vote
0answers
593 views

SAP Oracle Full Online Backup Failing

we have a SAP instance that runs on Oracle 11.2.0.4.0 DB. Since a while full online backups are failing every time. Full online backups are scheduled in SAP tcode DB13 (or DBACOCKPIT) and use BR*Tools ...
1
vote
0answers
65 views

How to keep only those archivelogs that are created after a latest db backup in oracle 11g?

I am little confused with oracle db backup. I have configured my Oracle 11G DB with ARCHIVELOG in Fast Recovery Area (NFS mount). I only need latest backup to restore in case of failure, but no point-...
1
vote
0answers
122 views

Error creating aggregate materialized view

Trying to create an aggregate materialized view: CREATE MATERIALIZED VIEW MV_LLATTRDATA_MAX_VERSIONS NOLOGGING BUILD IMMEDIATE REFRESH FAST ON COMMIT ENABLE QUERY REWRITE AS ...
1
vote
0answers
67 views

How to set processes parameter in oracle 11g Windows in accordance with RAM in the server

Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this. Right now I have set the processes to 4000 and I ...
1
vote
0answers
30 views

How to handle large sized oracle databases in a windows server

My Production database is having 188 GB size. The server handling the db is having C Drive with a space of 250 GB. My database is growing rapidly.I don't think this database is having much size ...
1
vote
1answer
810 views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
1
vote
0answers
446 views

When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property “”

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
1
vote
1answer
37 views

Oracle Upgrade - Attach External Tables

We have just completed an 11g to 12c migration to a new server. There is a schema that didn't seem to come over that consists fully of external .dat files. I can't seem to find a way to simple '...
1
vote
0answers
206 views

Can Oracle Database run on Microsoft Nano Server?

Microsoft Nano Server is attractive alternative to a heavier installation of Microsoft Windows Server 2016. Can Oracle Database be prepared to run this way?
1
vote
1answer
802 views

Oracle data pump import parallel configuration

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences. At times I ...
1
vote
0answers
2k views

ORA-17627:invalid username/password;logon denied error message when trying to duplicate database in data broker

I'm trying to duplicate the database for the purpose of Data broker in windows platform. When I'm trying to duplicate using below command DUPLICATE TARGET DATABASE TO LOCALDEV FROM ACTIVE DATABASE; ...
1
vote
0answers
913 views

How to know when did a blocking session start and end?

I created one application where requests in XML format come to my application, my application runs some select and update SQLs and then responds to the other system. Total TAT for this whole process ...
1
vote
0answers
1k views

How to audit database user password changes in oracle 11g?

I want to record how many times or which user accounts passwords were changed using Oracle database auditing techniques. I also want to record any password changes done to system user account.
1
vote
0answers
15k views

ORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 100.00% used, and has 2340864 remaining bytes available

I'm using Oracle 11g database in archivelog mode. I'm getting the following error in my database logs for the last two days. *** 2017-05-19 22:01:04.164 4515 kcrr.c ORA-19815: WARNING: ...
1
vote
0answers
431 views

Oracle - can't drop an editioning view

I have an Oracle 11gr2 DB, and I have created an editioning view called TEST which I'd now like to drop. I run DROP VIEW TEST; as DBA, and get the following error: ORA-04045: errors during ...
1
vote
0answers
216 views

Oracle 11.2 index on VARCHAR vs index on DATE

I have a table with 15,339,375 records and it has an index on a date field that's converted to a VARCHAR(5) and stored as "MMYDD". It has an index on the field. The records in the table are all from ...