We have multiple (4) Oracle databases that are all copies of each other using data pump. The DMP file is about 200 GB and the size of the drive where the Oracle files are located range between 350GB and 800GB.

Some of the drives are low on space, do we just give more space or is there a better way of reclaiming space? I'm advised to just keep increasing space as needed but that seems wrong since the dispartiy between databases file sizes are so high.

I’m currently an ERP Project Manager for an accounting firm. I’m about to transfer laterally to an ERP Process Analyst. After some research, I’d like to join the company Oracle as a PM or analyst, what are the steps that you would recommend to give me an edge to get into Oracle for someone with ERP implementation experience but no Oracle experience?

Side question: How difficult is it to get a different position internally after joining?

Did a phone screen two weeks ago. Reached out to recruiter via email two days ago asking for status update. Never got a response except today I got the generic rejection letter.

I expect ghosting from random recruiters on LinkedIn but this is rather ridiculous IMO.

Anyone have any experience with this and care to share what you’ve implemented?

Been in the interview process for a role in the Oracle Health division that is an IC3, salary range shown on the req is $76,600-$158,200. I’m in northern Indiana USA… what is the likelihood of falling in the mid range on that scale if I get an offer? Or should I just be expecting the bottom of that range off the bat?

Hey guys!

I'm currently studying a DBA course in college, and a part of my exam would be to calculate the licensing costs given a scenario.

A possibility to come in the exam would be options for the Oracle Database Enterprise Edition, for example Multitenant or Active Data Guard.

What I couldn't find in the documentation while studying (or anywhere else, really) is that are the Options licenses per processor, or is it a purchase to be applied for the entire database?

Thank you!

Hi Folks! Just wanted to check how much I can expect from Oracle Financial Services India for a ETL developer profile. I’m having 3.5 years of Data Analytics experience.

Hey !! I have been invited for an onsite interview at California, Oracle. Any suggestions on how the interview will be and what to prepare. I got past the Hiring Manager round. Any tips or previous experience would be appreciated.

I had the 1Z0-811 exam scheduled for 8 pm, with the check in at half an hour before it. I checked in as soon as it became 7:30, had the proctorio extension already installed and took the required pictures of myself and the personal document. It wasn't already 8 pm but I could already start the exam. I was at about quesion 10 of 60 and the screen freezed for, I don't know, 30-60 seconds. It happened again after a few minutes, the page became blank with a "404 not found" error message on it. My exam was considered as "no show" and "not checked in in time".

What has happened? What could have I done wrong to be kicked out?

I didn't open a new tab, app or window during the whole thing, until the 404 error showed up.

Anyone who could clarify to me what happened would be really appreciated, thanks.

I am just wondering if anyone has any experience setting up OAUTH in apex so that APEX can fire off emails.

I am struggling a little, and would love help .. or an article.. or a video...

THANK YOU!!!

Can I link a purchase order to a contract ID and have the dates on the contract be updated through generating the PO?

A recruiter from Oracle reached out to me for a Pre-Screen for the role of ‘Adoption Consultant l.’ We spoke this morning very briefly and he set me up for a ‘Loop Interview’, to interview with three separate managers in a row, on three separate days.

My question is: Has anyone ever had this happen before and what usually takes place during and after?

All answers are appreciated!

We just transitioned to Oracle Fusion, from Salesforce, when searching a TTN in Salesforce you can see all related Purchase Requests, is there a way to do that in Oracle Fusion?

So, I'm on the r/cernercorporation subreddit since I feel like that's the sub that offers the most information about that team. I've been interviewing for a role there and am supposed to hear back later this week.
I posed a question about pay scales on the listed job rec, and was met with some not so positive comments about avoiding Oracle Health.

I have a few coworkers who left Oracle Health/Cerner after the acquisition who say the same, and from what I've read/heard the acquisition was rough for most Cerner folks. Talk of no raises/bonuses since 2022, mass layoffs and stuff like that.... and just an overall negative vibe from them...

Not enough to turn me off from joining/accepting the role if I get an offer....

My question here is... is the negativity mostly because of the acquisition not going well, or because of the changes that came about, or what is it that makes that subreddit and team so negative. I have a few friends who've been at Oracle a long time who have always loved it.

I got selected in oracle and after a month after bgv is over they said they are going on hiring freeze and they can't take me in now . Has anyone got the offer after the hiring freeze is lifted . Should I trust this. Also another team from oracle called me and they said I can't take an interview because I'm already on hold by another team.

Hello,

there is application what needs to be deployed and will be used only for 5 to 10 users. Windows Server OS will be used for DB install.

What would be best way to licence Oracle DB in this scenario.

Enviroment:
- 2 vmhosts with 2 CPU each
- 1 storage device (netapp)
- fc connectivity between Vmware hosts and Netapp.

Thank you,

p.s. got some info from difference Oracle guys, different Oracle partners. They are all different. That's reason why I came here. Wisdom :-)

Hi guys, I've been working with Oracle database for more than a year now. And I want to take some certification. However, I can't seem to find a way to take the exam.

I have accessed to this link.

https://education.oracle.com/catalogue-de-produits-ouexam-pexam_1z0-071/pexam_1Z0-071

And clicked on Buy Exam.

However after that, the site redirect me to Training page.

https://www.oracle.com/id/education/training/buy/

I have no other option besides click on [Contact Oracle University Sales]. And haven't heard from them for days. I'm in Vietnam by the way.

Anyone know the process? please share with me.

I have reason to believe that there have been recent changes to dramatically cut the support period for Oracle APEX releases (even retroactively). Could someone please clarify or confirm?

December 6th 2023

https://preview.redd.it/5a9epp6cfrxd1.png?width=1324&format=png&auto=webp&s=bd7e7f56858cfec7aed747dd55b2d68032257775

October 29th 2024

https://preview.redd.it/8152g65hfrxd1.png?width=1036&format=png&auto=webp&s=c1aa91c9f55cf5734a04cbca8a39fbc641de9b38

There were 50 of us who were interviewed for the final round and I was wondering how many people are usually in a class? Did anyone actually hear back yet? Wishing whoever reads this the best of luck!

As the title suggested, I've been thinking about pursuing the path of an Oracle DBA. I was laid off last month due to reduction in force but I recently received a job offer for another full stack developer position. I honestly don't like working as a full stack developer because I hate JavaScript/typescript or anything front end. Backend development jobs are rare and hard to land. I only accepted the offer because I already have 6 years of full stack development experience which lands me interviews. I have not started the new job yet but they use oracle for their databases and I will try to slip my way into doing more tasks with databases. I've been thinking about doing some self studying to understand linux, improve sql skills, and learn oracle database administration. Does this learning path/strategy seem like a good way to go about getting my foot in the door as an Oracle DBA?

A recruiter reached out to me regarding netsuite ACS Technical Consultant at Oracle.I do not have any technical (IT) background.Can someone let me know if I stand a chance at getting hired without a technical background? Also, how's the day to day like for a Netsuite ACS Technical Consultant? I have an interview scheduled next week.

I've been interviewing for a role with the Oracle Health division, and the recruiter told me the role required a public trust clearance, which ok, not super worried about it, but I was curious what that process looks like, and if that process has to be complete before I can actually have an official start date?
Anyone else experience the process and can shed some light?
Thanks!

Hello, I don't see any end users of Oracle here, but I can also not find a sub for this. Soooo just posting here, please help if you can.

Intro: I am in Finance. I have recently switched jobs, and these guys here have recently upgraded to Oracle Fusion from Oracle EBS. So it's all new for them and me as well (I have been an SAP user in my previous jobs).

Issue: When I extract a GL report, it does not show up in one table. It will show a header Account 162536, then a table for that account. Then, another header below it for Account 262783 and then a table for this account.

So, if I am extracting a report for 50 accounts, I have to deal with 50 tables SEPARATELY!!

How do I extract this info as 1 table with may be a column in the side stating the respective account number?

(Attached a screenshot for reference)

Also, WHY IS ORACLE MERGING COLUMNS & ROWS IN AN EXCEL EXTRACT, THIS IS NOT A PDF REPORT!!?? It is bringing down the excel functionality but that's not even on my priority list right now.

https://preview.redd.it/tmnh1ez3ggxd1.png?width=1574&format=png&auto=webp&s=456e33ddc4957050f342bcded7c2eea833314b27

Hello, I don't see any end users of Oracle here, but I can also not find a sub for this. Soooo just posting here, please help if you can.

Intro: I am in Finance. I have recently switched jobs, and these guys here have recently upgraded to Oracle Fusion from Oracle EBS. So it's all new for them and me as well (I have been an SAP user in my previous jobs).

Issue: When I extract a GL report, it does not show up in one table. It will show a header Account 162536, then a table for that account. Then, another header below it for Account 262783 and then a table for this account.

So, if I am extracting a report for 50 accounts, I have to deal with 50 tables SEPARATELY!!

How do I extract this info as 1 table with may be a column in the side stating the respective account number?

Here's an SS for reference:

FIXED

I crested a ticketing system

It's a simple form you fill out to create the ticket

The system then uses the comment section function to allow users to update and talk to each other about issues

I have a teams user created that has a chat I'd of every user so that I can send a web hook over to the user saying the ticket has been updated and what the update is...

The workflow is Open existing ticket Input comment into comment textra box Submit

The Java script to send the api is.then kicked off in a dynamic action The page is then submitted to commit data to fatabae and then close the dialogue box ....thw close I'd the dialogue box refreshes the users ticket window to show the latest dates.of ticket actions.

Now the issue... that Java script will NOT kick off foe the first time when you log in

You have to comment in one ticket, and after thwt..the.java script works no fail

Any ideas whst.this may be?? Or why???

FIX::::: I made the button that submits the data do a few things

1. Dynamic Action: It send a FAILED webhook to MS TEAMS to kind of knock on the door(dont think this is needed)
2. Dynamic Action (500ms delay): I inserted a delay of 500ms before the button then sends a SUCCESSFUL webhook to MS TEAMS
3. Dynamic Action (1000ms delay): THe last step with a full second is comitting the data to my database, and then closing the page --

This allows for the webhook/api to get a header and not be fored to quit early so that it can fully submit the Webhook payload and get a repsonse

I went through multiple rounds for the Federal Senior Staff Test Consultant-Healthcare role for oracle health I met all the requirements and made a good impression according to the recruiter then yesterday I was told I wasn’t getting an offer it honestly pissed me off because I was hoping to get an offer since I’ve been on the job hunt for 2 months after getting laid off and it’s frustrating how I went through a multi stage interview process just to not get the offer then had the nerve to tell me I’ll be considered for the next hiring batch I really don’t trust what comes out of Oracles mouth because from the beginning of the interview process I had to take the initiative to get the interviews set up since they were running super slow I’m tired of the tech market and honestly want to give up at this point

As a DBA never had to work in a Oracle shop before. Trying 23ai Free at home. Using DBCA, just trying to create a new Global database name. Continue to receive config errors. The default Global database name is: FREE. If I attempt to create a new Global database name and include a name for a new PDB, the configuration assistant just throws errors at me.

[DBT-10334] Oracle SID name for Oracel Database Free is invalid
Action: SID name for Oracle Database Free should be FREE

It's not lost to me that I am using the Free version of Oracle 23ai on Oracle Linux 9, but does that actually mean I cannot create new CDB's?

I would appreciate it if someone could verify that truly is the case. Oracle documentation is great, but have yet to find any specific gotchas regarding this.

Thank you.

We have multiple cases where the same message id has a different status in AQ table and AQ view.

Like, AQ table for some msgid shows status '0' and empty dequeue_time while AQ$<table name> view for the same msg_id shows status 'PROCESSED' and some populated dequeue time.
Why??

Aren't them to be identical?

Oracle 19C. port_string Linux 2.4.xx

I managed to find the same complaint from long time ago:
https://forums.oracle.com/ords/apexds/post/difference-between-aq-tablename-and-queue-tablename-2877

The "answer" given for this post is a complete nonsense, just saying 'don't query queue table, use the view'.

Obviously, the problem persists since at least 2010; we have _permanent and consistent_ count difference in Pre-PROD environment and a complete absence of this effect in PROD, although PrePROD is an exact copy of PROD.

As the title suggests, I'm an Oracle user with ~ 15yrs experience using both EBS and Cloud with a primary focus on the Procurement module as a business user in the Life Sciences/Biotech space. I also have a good amount of day-to-day use of SCM as it relates to inventory items, transactions and BOMs.

In my mid-level management role, I've also been deeply involved in a couple of ground-up Oracle implementations as a functional user/primary stakeholder and tester from start to finish, including any ongoing quarterly patch evaluation and testing. The first implementation was from small-market ERP to EBS during the acquisition of a small startup I was with. The second was implementing Cloud from EBS as part of the mid-size public company that had acquired the aforementioned startup.

I also have plenty of "client-facing" experience during the implementations, including data prep and training new users and smaller groups of staff as part of a couple of subsequent acquisitions in recent years. This would include those at all levels of the company as well as plenty of outside domestic (Big 4) and offshore consultants.

I think I have a pretty good grasp of the functionality, limitations, quirks, OTBI reporting, FBDI loads, and other random stuff, at least as it pertains to my area of expertise. If I don't know the answer to an issue, then I know how to Google or use Cloud Customer Connect and the Oracle customer support resources. If all else fails, I know how to talk to the consulting side intelligently about the problem.

So now, what I don't know is the technical back-end side, coding, how to configure the actual settings, although I've got some exposure and access to Setup & Maintenance for certain tasks. Not afraid of it, just haven't learned it yet. I also don't have a business or CS degree, but do have a bachelors from a very well-respected state uni.

Long story short, what are my prospects on jumping into consulting as-is, or maybe with a course or two? Especially on a part-time basis. This is key. Lastly, what sort of hourly rate would I reasonably and conservatively be looking at to start?

Thx!

Is there anyway to get access to an oracle cloud erp environment just to understand the screens and navigation?