Tag Info

New answers tagged

0

You have to specify the format string twice, once for database backupsets, and once for the archivelog backups, for example: backup as compressed backupset database format '/path/%U' plus archivelog format '/path/%U';


1

The session(s) using the temporary table can be queried as: select sid from v$lock where type = 'TO' and id1 = (select object_id from dba_objects where object_name = '&temp_table_name'); Then you can kill these sessions or have them release the locks gracefully.


0

Here's what happens: When you create a global temporary table with the clause "on commit preserve rows", table will be locked until you restart the database. I had this issue recently and was able to reproduce it. I created a simple article describing it (in portuguese but the commands are in english): ...


1

You should not install more than one Oracle Client (per architecture) on one machine. For sure they do not work in parallel. By heart I know several issues: You would have to change PATH settings in order to determine which Client you want to use. TNS_ADMIN environment variable is used by both versions and must be set accordingly. Oracle OleDB provider ...


1

Are you using Enterprise Edition? It looks like this is a EE feature: http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm CTRL + F the docs and search for result cache and supported editions.


1

The procedure is described in the Remote Startup of a Database Instance part of admin guide for BS2000/OSD (I can't find this part in the Linux docs...). Essentially what you do is: Create an Oracle password file for your database if you haven't already done so Add a static registration for your instance in its listener Set the instance parameter ...


0

The alert log should tell you if a data block is corrupt, no need to validate index structure. That will lock your table until completed. If no backups you might try to exporting the data using expdp. Then drop the table and re-create it and import using impdp. You will need to create the indexes, constraints and grants as well. Could also use CTAS.


0

What is the output of: select * from v$database_block_corruption? Unlike regular indexes, LOB indexes can't be dropped/ recreated, because you would have to drop the column instead. So, assuming your backups are valid, you can attempt to perform block media recovery (BMR): http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmblock.htm


0

1 - Make sure Recovery Catalog DB is created either on a different server or a different disk (because in case of failure of target DB and lost of access to its files, if your recovery catalog db stills up and running, you'll have access to control file and probably be able to restore and recover failed instances, given all backups/ archivelogs are ...


0

Split above current maximum value, drop the empty MAXVALUE partition, then convert to interval partitioning: alter table parttest4 split partition p_max at (2030) into (partition p_2030, partition p_max) update global indexes; alter table parttest4 drop partition p_max; alter table parttest4 set interval (10);


1

I don't think that tkprof is the problem. It is a tool that summarizes information from trace file. Tracing is the problem. If you enable tracing of a process, this may slow down the process considerable. Besides that the trace files may fill up your disks. Finally you should be aware that security relevant information is written to trace files.


0

I know it is too late for the OP but here some advice to tackle such a problem: The error message says that the clients sends but does not get a response. Most of the time it is a firewall problem. The windows getaddrinfo function is described here. Error number 11001 is WSAHOST_NOT_FOUND and is described here: Host not found. No such host is ...


1

Disclaimer: As @JustinCave wrote, you should contact Oracle support. I give the following information without any warranty. Source of Information: I found the following metalink notes that analyze this problem: ORA-08102: Rebuilding Index does not correct ORA-8102 (Doc ID 96118.1) ORA-8102 CORRUPT INDEX, ORA-1499 EVEN AFTER DROPPING AND RECREATING ...


0

RAC requires a clustered file system: 1. ASM comes with the database 2. ASM provides a clustered file system 3. ASM was built specifically to do this Anything else would be an additional cost 3rd party product that you would have to integrate and get working with RAC.


0

I know someone who wrote a Perl program that woke up every few minutes to read the new lines of the alert log and send an email if there are errors. If you have grid you can probably configure that to notify if there are deadlocks.


0

Here is an article from dba-oracle which talk about this same problem. This might solve the issue you are having.


0

Short version: install the 12c software, create an empty database, and transfer the data with Data Pump. This way you can skip 11.2.0.1+ versions. Long version: OTN Developer License Terms In this, there is the following: No Technical Support Unless Oracle support for the Programs, if any, is expressly included in a separate, current support ...


1

A possible solution based on set operations. From my understanding you have to display all rows that contain a 'ticket' in the status fields and all rows with an 'import' in the status field where there is not a similar row with a 'ticket' in the status field. select id,name,testfield,status from mytable where status='ticket' union select ...


2

Oracle 11g R2 Database Release 2 only support Windows, Linux, and Solaris. So if you want to using Oracle 11g R2 on a Mac OS you will need to using something like Virtual Box or VMware Fusion. You can read more about installing Oracle 11g R2 on these operating system here.


2

No. This is not possible. There are various options that might help you recover from this situation or even prevent it from happening in the first place though. Think about it like this: how do you determine when the "data gets corrupted"? Imagine that you could decode and scan through the archived redo logs, before they get shipped to the standby. How ...


3

Choose Install database software only, then later you can upgrade your databases one by one with DBUA (Database Upgrade Assistant) from the new Oracle Home, or by performing a manual upgrade.


0

At least 14 GB. Maybe more if the dump file is compressed. Maybe less if the tables are compressed. A bit more or lot more if there are indexes. Even Data Pump will miscalculate the required space in case of compressed tables. Index data is not stored in the dump file, only index definitions. You can have a 14 GB dump file with 14 GB table data and 0 ...


0

Using a combination of MASTER_ONLY and KEEP_MASTER switches, it's possible to get Data Pump import to do the dependency tracking, calculations, and estimations of sizes that it does at the beginning, create the master table that it uses to track everything, and then stop. You can then examine the master table to see how big the various tables are estimated ...



Top 50 recent answers are included