Questions tagged [exadata]

ExaData : Oracle's Database Appliance hardware

Filter by
Sorted by
Tagged with
0
votes
1answer
106 views

use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)

this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1....
1
vote
1answer
987 views

ORA-04020: deadlock detected while trying to lock object - Oracle Package [closed]

I have an Oracle Package (Schema1) that is calling another Oracle Package (Schema2) over a DB link. There are no recent code changes. When I try to compile the package in (Schema1) it throws the ...
0
votes
1answer
139 views

How could we start Oracle database in Oracle Exadata which's celldisk has proactive failure?

I am trying to open exadata machine but it has error. That EXADATA  Oracle Sun Fire X4720 M3 SAS, Oracle 11gr2 RAC database installed. I was examining celldisks. When i gave command list griddisk I ...
0
votes
1answer
2k views

What is exadata database?

I need to know Is oracle exadata database is same as the oracle database which is installed in my laptop. What is the main difference. Can I simply take backup from exadata database and restore it in ...
0
votes
1answer
366 views

How to add newly discovered cell node as member of exadata storage server grid in oem12c?

I have successfully discovered a new storage node in oem using emcli ./emcli add_target -type=oracle_exadata -name="da13cel04.myhost.com" -host="da13db01.myhost.com" -properties="CellName:da13cel04....
0
votes
1answer
1k views

How to find out the total no of cell nodes configured as part of a rack in exadata?

I want to know the exact total no cell nodes configured as part of the rack by login into the first db node of Exadata machine and run some commands or check some files. We are not able to believe ...
1
vote
1answer
547 views

Exadata: how to backup system before upgrade rpm packages?

My PCI scanned found some vulnerabilities on my Exadata. I must upgrade glibc package. Before that I want to backup the system not to ruin something. By which tool can I backup OS? I used acronis, ...
0
votes
2answers
291 views

Oracle Exadata datafile distribution

I'm new to Oracle and curious of how Oracle Exadata handles database files. Do we have to assign the disk to a database file as we do with Microsoft or is this handled by Exadata?
1
vote
0answers
129 views

Unexpected SYSDATE behavior

I have a SQL trigger which adds the old value ,new value and time of update for column based on update, insert, update or delete. To update the time we used SYSDATEand inserted record from trigger. ...
0
votes
0answers
351 views

RMAN Performance Problems following Platinum Patching on Exadata DB

I backup my dev,tst and prod databases (9 in all) to ZFS on two RAC servers on an Exadata 1/8 rack machine. Prior to quarterly patching, our backups were set up in 30 minute intervals and each ...
1
vote
1answer
430 views

Exadata RMAN vs. Non-Exadata RMAN - any differences?

Can you please let me know the differences, if any, in the architecture of the non-Exadata RMAN vs. that of the Exadata-RMAN from an SBT plugin perspective? Have you observed from your vast ...
1
vote
1answer
1k views

Exadata exachk.sh

I would like to run exachk.sh on regular basis. Now I have to interact with the script and answer all kinds of password questions before the script starts to extract Exadata information. I want to ...