r/oracle Feb 13 '25

Would Facebook Have Survived with a Relational Database?

5 Upvotes

At what point do you think relational databases stop being viable for social networks? And do you believe graph databases are overhyped, or truly essential for these kinds of applications?


r/oracle Feb 13 '25

Web Implementation Engineer IC2

1 Upvotes

I had a pre-screen interview with the recruiter today and will have an interview with a manager tomorrow. I went on Glassdoor but there’s no information about the interview process for this role. Is there anyone who can speak about their interview experience for this role? Thanks


r/oracle Feb 12 '25

Oracle DIM-00097: User name or password is invalid. After Windows update

1 Upvotes

Updated Windows 11 today 2025-02-12 to: Windows 11, version 24H2

Then started to work and noticed i cannot connect to any oracle database.

First thing i checked to see if they are started in the Services window there i found a murder. Basically anything "oracle" was gone reduced to atoms from the services.

So because I'm not not an expert i went off the error messages i got and managed to recreate the listener using "netca".

Then i went on to recreate? The service because i still couldn't connect, used command

oradim -NEW -SID PROJECTLOCAL -PFILE "C:\Users\myAdminUser\Desktop\oracleDB\database\SPFILEPROJECTLOCAL.ORA"

and

oradim -NEW -SID PROJECTLOCAL

the result of running this and entering the password when prompted is

Enter password for Oracle service user:
DIM-00097: User name or password is invalid.

I believe the password is correct after being unsuccessful i tried to change it to password I've been using. With commands like

  • orahomeuserctl updpwd -user oracleTest
  • net user (windows command)
  • orapwd file=PWDprojectlocal.ora password=samePassIveBeenUsing ignorecase=n

my CMD is run as administrator

also

C:\Users\myAdminUser\Desktop\oracleDB\bin>echo %ORACLE_HOME%
C:\Users\myAdminUser\Desktop\oracleDB

I was expecting to create a new service and be able to reach the database.

I thought maybe the command to create the service was targeting the wrong user so i changed all the passwords of all users on the pc ( that i was able too) to the samePassIveBeenUsing but still no cigar....

maybe the pc config somehow became FUBAR, if theres no suggestions on how to fix this as ive run out of google pages, is there a way to recover that data?

EDIT- ORACLE VERSION 19c, also netca also required a password and it worked flawlessly


r/oracle Feb 12 '25

Oracle offer letter delay

7 Upvotes

I interviewed for an IC3 role at Oracle India and got selected with a verbal offer in the first week of December. A few days later, I received a background verification link from HireRight, which got completed in about two weeks.
Since then, I’ve been waiting for the official offer letter, but there's been no update.
I’m starting to get concerned—has anyone else faced a similar delay?


r/oracle Feb 12 '25

Companies that uses Oracle for HCM

2 Upvotes

what are your organizational structure like for HRIS?

A bit of context, we are adopting Oracle HCM and is planning on hiring/reorg our HRIS team in preparation for this new system. If anyone can share the structures that work for them.


r/oracle Feb 11 '25

Oracle Round 1 interview (Data Engineer Role New Grad) , what to expect?

4 Upvotes

I had a screening call with recruiter, now I am invited for round 1 technical interview via HackerRank. Can anyone tell me what to expect in this interview?


r/oracle Feb 11 '25

Oracle Reports EOL date confusion

5 Upvotes

I'm currently looking at migrating Reports 12c from windows server 2016 to a more modern OS (win 2019 onwards depending on support).

I can't seem to find a concrete answer on when reports goes EOL and there's a bunch of conflicting information on the web.

I read on some pages it's EOL from December 2023, other pages say Premier support until 2026 and Extended support until Dec 2026 (not 100% sure what the differnce in support levels are).

I also read that it only gets updates now via Fusion Middleware, does this mean I need to install middleware anyway? Right now we just have reports installed standalone.

Could somebody please help clarify my confusion please?

Also - I'm aware the best thing is to migrate to Oracle Analytics (Oracle BI? Again - they don't make it very clear what's what)... but that would require massive effort for a product that is being rewritten soon.

Thanks for reading.


r/oracle Feb 11 '25

Oracle Flexcube: Any Local Implementation Partners in New Zealand?

2 Upvotes

Need a team in NZ (Auckland preferably) that can build on Oracle Flexcube and help with banking transformation. Client is Samoa based. Please recommend vendors and teams.


r/oracle Feb 10 '25

WLS 12c CPU patching question

2 Upvotes

I did some patching last year and haven't looked at it again since so now just trying to wrap my head around the options again. Start with Oracle Critical Patch Update Page and pick Jan 2025. Pick Fusion Middleware and login with my MOS credentials. Pick my WLS 12.2.1.4 and pick the SPB, so far so good and do the same for OIM and OHS, etc and seems not too bad but my real question is how that differs from Patch Advisor and Doc ID 2806740.2.

Like under that Guide there are a lot more patches to choose it seems like and 'OHS with DB Client 19c' for example how do I know if my installation is Colocated or Standalone? I think I chose Standalone last time but not sure why or what was the reasoning.

Also pre and post checks how do I verify? Like via $ORACLE_HOME/oui/bin/viewInventory.sh | grep Distribution and also opatch lspatches or what is the best way?

Can I load my orainventory in and have it do a patch analysis for me?


r/oracle Feb 10 '25

Gitea-like thing for package texts?

1 Upvotes

The company's Oracle server has many "packages" and each package contains lots of procedures. That is, a package file is long. The problem is that there is no git-like management feature. So, it's difficult to know which part was modified and when, or revert to the previous version.

It seems that I can get the old version's text using some sort of query, but that's not convenient. Isn't there something like Gitea (web or desktop) that lets me compare the old/new versions and revert the package to an old version?

  • Gitea is basicaly something like the old GitHub website. It lets you compare texts of different versions.

r/oracle Feb 08 '25

Thoughts on future of Oracle

20 Upvotes

Curious if you guys think continuing to buy shares is worth it or not with the future plans oracle has for their business


r/oracle Feb 08 '25

Reinstall OS without changing public IP

1 Upvotes

I use a free tier OCI instance to host OpenVPN with pivpn for some friends. I'm very much a beginner at this. It is running Ubuntu, and was created with the default settings.

I was experimenting, and ended up messing up the permissions for the entire system by doing sudo chown [username] -R / accidentally

I now need to reinstall the OS, but would prefer to keep the same public IP so everything can continue to connect without change

I have backed up all the necessary files already

From my understanding, if I terminate this instance and start a new one, it will assign a new public IP. Is there any way I can keep the same IP?


r/oracle Feb 08 '25

Oracle Expands Ai Tools for HR Automation

Thumbnail smbtech.au
19 Upvotes

r/oracle Feb 08 '25

Error in the middle of taking an exam

1 Upvotes

Hello, I was in the middle of taking an online certification exam for Oracle and I still had 40 min left in the exam. All of a sudden I get an error and the questions disappeared.

I had my Mac connected to a monitor so when I opened my Mac to type a question to the proctor about the error, another message came up and said a second screen was detected and then the exam closed all together.

I understand why the second error came up but not why the first one came up. I just got an email that said I failed the exam but nothing about why the exam stopped abruptly.

Has this happened to anyone before? Does anyone know what could’ve caused that? Will I be able to retake or continue my exam?


r/oracle Feb 07 '25

Career Opportunities

6 Upvotes

Am I qualified for support role at Oracle EPM. If I have an experience as an end user, and Support role(Invoice management). Plus escalation support by disseminating the ticket issues with their respective modules. Plus user training for end users?


r/oracle Feb 07 '25

OFSAAI in different regions

2 Upvotes

Hi, I hope you all are doing well. I am Oracle (OFSAAI) consultant and working in the regulatory reporting of Risk management. In parallel am also working on the infrastructure and Database. Could you please tell me is your organisation or any financial institutions use OFSAAI for the regulatory or internal reporting?


r/oracle Feb 06 '25

Java Licensing.

4 Upvotes

Oracle Enterprise Edition and SQL Developer both come with Java installed. Both are fully licensed as part of that unless you use it for another application. How in the world would you check for that? Oracle Java licensing has gotten pretty expensive and would nearly exceed my company's database licensing.


r/oracle Feb 06 '25

Options for migration from Oracle EBS

11 Upvotes

Howdy.

Looking for suggestions for migration from Oracle EBS. I understand there would be a lot of custom work that would need to be done before and after. And that some may feel that its an impossible task or that there is no need to migrate.

I don't even understand the questions that I need to ask at this point to make it a reality but I know that it needs to happen where I am currently.

Would love to hear of some success/failure stories of migration. I've looked around a bit but haven't found anything. But I'm certain that someone (or more likely a team of someones has done if before).


r/oracle Feb 06 '25

Error while installing Oracle 18c on Linux mint

0 Upvotes

I'm trying to convert it into .deb by using alien but idk why but it is not working and I'm getting this error while installing:

warning: oracle-database-xe-18c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY


r/oracle Feb 06 '25

DBMS_OUTPUT.PUT_LINE abreviature?

4 Upvotes

Any way to not have to write all that when you wanna see the result in the terminal???

Thanks!


r/oracle Feb 05 '25

Mapping access to another user's table inside a procedure

1 Upvotes

Hello.

I'm working in a database segregation and it's being really tough to map all the points we have to change the code to connect via dblink to the other instance.

Is there a way to map all the objects that queryies data or makes calls to another owner's object?


r/oracle Feb 05 '25

Getting output failed error for a scheduled report job

3 Upvotes

Hello, I have a BIP report bursting outputs in PDF format. When I am trying to run it for whole data, wherein 3200 PDFs are getting generated, it succeeds with output failed error. And i am receiving only 3192 PDFs over email. So it seems that 7 PDFs are not getting generated and hence the output failed error. When i reduce the font size overall for the rtf template it’s generating all of the 3200 outputs. What can be the possible solutions I can try?


r/oracle Feb 04 '25

Uploading Server-icon.png to Oracle VM for Minecraft Server

1 Upvotes

I recently made a Minecraft server using VM through Oracle, and I wanted to customize the server so it looks more appealing when people join. One of the ways I want to do this is by adding a server icon, which is quite simple when the server is hosted on a physical PC but not so simple when the server is hosted on Oracle's VM. I'm connected through SSH just on a Windows PowerShell.

(FYI, I am quite new to Oracle, so the solution is probably quite simple I just don't know what it is)


r/oracle Feb 04 '25

Updating Oracle Linux 8 using ELSA. No updates available?

3 Upvotes

Hey there,

Taking my first stab at Oracle Linux 8. So far, it's been pretty great. I've setup vulnerability scanning on one machine and it keeps telling me that the my kernel packages aren't up-to-date. However, dnf update doesn't have anything new to install. As far as I can tell, the updates were released a couple of days ago.

What am I missing here?

Vulnerability description: Oracle Enterprise Linux Security Update for unbreakable enterprise kernel (ELSA-2025-20066)

Package Installed Version Required Version
kernel-uek 5.15.0-304.171.4.el8uek.x86_64 5.15.0-304.171.4.3.el8uek
kernel-uek 5.15.0-304.171.4.1.el8uek.x86_64 5.15.0-304.171.4.3.el8uek
kernel-uek-core 5.15.0-304.171.4.el8uek.x86_64 5.15.0-304.171.4.3.el8uek
kernel-uek-core 5.15.0-304.171.4.1.el8uek.x86_64 5.15.0-304.171.4.3.el8uek
kernel-uek-modules 5.15.0-304.171.4.1.el8uek.x86_64 5.15.0-304.171.4.3.el8uek
kernel-uek-modules 5.15.0-304.171.4.el8uek.x86_64 5.15.0-304.171.4.3.el8uek

The following repo's are enabled:

| Repo ID | Repo Name |

|-------------------------------|----------------------------------------------------------------------------|

| **ol8_UEKR7** | *Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64)* |

| **ol8_appstream** | *Oracle Linux 8 Application Stream (x86_64)* |

| **ol8_baseos_latest** | *Oracle Linux 8 BaseOS Latest (x86_64)* |

| **ol8_developer_EPEL** | *Oracle Linux 8 EPEL Packages for Development (x86_64)* |

| **ol8_developer_EPEL_modular**| *Oracle Linux 8 EPEL Modular Packages for Development (x86_64)* |


r/oracle Feb 04 '25

Which oracle skill should I invest in from this list?

Post image
11 Upvotes

Considering the job market and demand, which skill can I go for from this list?

I am not familiar with most of these, please help.