Exadata CPU allocation question: I am running 4 CDB instances each of them contain same PDB. Instance 1 at peak uses 12 cores, 2 - 5, 3 - 8, 4 - 10. The host has 96 cores. How many cores can be returned? 84 or 96 - (12+5+8+4)= 67. In other words, provided all instances are running simultaneously, how many cores would I need to have on the Host?

We have all of our DBs on Exadata's in Oracle 19. For some reason one of the other DBAs installed an Oracle 18 home and it never gets used or patched. Our security office keeps flagging it since it is out of date. Being that it is not being used and is just a bunch of binaries is there a security risk involved here by just leaving it? It seems to be the discussion we are having and no one has a technical answer as to whether is or not. If it is a security risk how is it one?

My employer has six Exadatas: three in a RAC in one data center, and the other three in a RAC in another data center. One is primary, and the other is a DataGuard standby. On the standby RAC, we also have a couple stand-alone instances (one for training and another for testing). Yes, this is not at all ideal. It was done well before I started working at this place, and we’re working on undoing these sins of the past. To make it more fun, we’re planning on adding a few more stand-alone instances on the standby Exadatas. This brings me to my question: the / and /u01 volumes are embarrassingly small (for example, each / is 30GB). We get occasional alerts about space approaching warning limits so I have to clear old log files out. I’ve got a job for this that’s been running for a year, but lately we’re getting alerts more frequently. I know this will get worse once we add more instances. I don’t think we have much more than 2 or 3 GB on each Exadata to expand the LVM volume for / so I was thinking of moving some of the log files (like Exawatcher) to an NFS export on our Oracle ZFS appliance. When I say “move some of the log files” I mean where they’re written to now would actually become a mount point on the ZFS box so the log files are completely off the Exadata’s file systems. Ultimately, I’d do the same for listener and ASM trace files as well. If this is not advisable/best practice, recommendations are appreciated! Also of note is while I have experience as a Linux sysadmin, I and my coworkers together have probably the equivalent of 6 months’ worth of full-time experience with Oracle database administration.

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 see that result. cellcli> list griddisk     DATA_DM01_00_mycelldisk01 proactive failure We dropped celldisk, we can't recreated griddisk and celldisk, it has error. we can't replace it because we can't get any disk from anywhere. I need to open that exadata and i plan to open database without that celldisk. should i drop physicaldisk? cellcli> list physicaldisk     20:0 KERMXM warning - proactive failure, poor performance when I give command srvctl start database -d mydb it gives error. ORA-15040: diskgroup is incomplete ORA-15066: offlining disk "0" in group DATA_DM01 may result in a data loss ORA-15042: ASM disk "0" is missing from group number "1" Could i delete disk "0" which is proactive failure and continue my system? Thanks

this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1.example.com)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=example2.example.com)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=EXAMPLE.EXAMPLE.DBS) ) ) I use this SQLcl command: sql -nohistory -noupdates -S $username/$password@$hostname:$port/$servicename @$filename How to specifiy multiple hostnames? Not only one? It's some kind of active passive cluster (Exadata). *Edit after first answer:* I added in shell script (in this dir tnsnames.ora): TNS_ADMIN=/example/example I call $sqlcl -nohistory -noupdates -S $username/$password@"MY-DB" @$filename and get back the error: ./script.sh USER = MY_USER URL = jdbc:oracle:thin:@MY-DB Error Message = IO Error: Unknown host specified USER = MY_USER URL = jdbc:oracle:thin:@MY-DB:1521/MY-DB Error Message = IO Error: Invalid connection string format, a valid format is: "host:port:sid"

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 following errors. (replaced the actual schema names with 1 and 2 for clarity) > ORA-04052: error occurred when looking up remote object > SCHEMA2.PKG_NAMEHERE@SCHEMA2.LINKNAME.INT@SCHEMA1 > > ORA-04020: deadlock detected while trying to lock object > SCHEMA2.PKG_NAMEHERE@SCHEMA2.LINKNAME.INT@SCHEMA1 What we have tried 1. Killed all user sessions 2. Recompiled the package in SCHEMA2 even so SCHEMA1 that calls it over the DBLINK failes with "ORA-04020: deadlock detected" We have 4 Database regions, and this is only happening in two of the regions. **Notes:** SCHEMA1: Oracle 11g SCHEMA2: Oracle 12c (on ExaData)

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?

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 my laptop?

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.myhost.com;MgmtIPAddr:10.92.43.23" Target "da13cel04.myhost.com:oracle_exadata" added successfully But now i want to add this cell node under existing exadata storage grid target in em and i tried below,but it didn't helped ./emcli modify_target -type=’oracle_exadata_grid’ -name=’Exadata Grid da13.myhost.com’ -properties=’Members:da13cel01.nyhost.com,da13cel02.myhost.com,da13cel03.myhost.com,da13cel04.myhost.com’ Need help Thanks in advance

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 the output of /opt/oracle.Support.Tools/onecommand/cell_group file or the cellip.ora files or ibnetdiscover cmd ,since in some customer environment those files outputs are not giving the exact no of cell node details. So is there any other command or file to fetch the exact no of cell nodes as part of the rack on the first db node ,even in the case like customer added additional storage nodes as part of that rack?

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, clonezilla but maybe I have old version , because they are not able to backup the system. Please, give me any advice.

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. This trigger was working fine for a long time. Few weeks back the server is upgraded to Exadata from 11g and now are experiencing some issues. The column inserted by SYSDATE is expected to update GMT time. But only in some cases it does insert central time and this behavior is intermittent. We also tried updating the table from same machine and experienced the same issue. So now we suspect it may be Exadata upgrade, but we are not sure. So does anyone has experienced similar issue or have any idea why this is happening.

**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 experiences when non-Exadata RMAN and Exadata RMAN existed as separate architectures? Do you anticipate any behavioral change from a RMAN perspective going forward from now between the standard and Exadata infrastructures ?

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 automate this and I am looking for ways of doing this. Do I really need to modify the exachk.sh script? The problem with this is that this script is fairly often updated on metalink. Suggestions?