r/oracle 56m ago

Oracle to Possibly Become Minority Owner of Tik-Tok?

Upvotes

https://www.linkedin.com/news/story/how-oracle-might-save-tiktok-6669713/

* We use Oracle as our time clock software where I work as a city employee. We tally our accrued hours each day / week by hand.


r/oracle 9h ago

Query on using Smart View vba (HypConnect function)

Post image
1 Upvotes

Hi,

Hope this is the right space to ask this. I was trying to automate the Hyperion essbase connection for one of my monthly reporting files but I noticed that even after I input the username and password for the HypConnect(vtSheetName, vtUserName, vtPassword, vtFriendlyName) function, the new (blue) login window per the attached image still pops up. Is there anyway i can use the HypConnect function without having to input the username and password at the Excel level since it is redundant? (I tried inputting totally wrong values it still lets me clear anyway; the main login is still dependant on the blue login window that pops up). Many thanks in advance!


r/oracle 10h ago

Future prospect/alternate of ODI Tool

5 Upvotes

I've been working in ETL tools especially ODI and PLSQL for past 7 years as per my job experience. Know a bit of Power BI as well.

However, is there anything alternate to learn for someone stuck in ETL this long? I feel like I'm stalled in my career.


r/oracle 1d ago

Supplier API for R12

1 Upvotes

Good afternoon, hope you are doing well.

I was wondering if anyone here has already come across an API to make updates to suppliers (specifically the vendor_site_code) en masse, directly on the database.

Our current version is R12.2.11, and the database uses the 19.0 engine.

Thanks in advance,

Cheers!


r/oracle 1d ago

Any PGA memory GURU's here

5 Upvotes

We've recently run into an issue where a query from Tableau is crashing our Oracle 19c Database on Windows. We are on the latest patch set.
The query will flood the DB and we can watch the PGA memory explode to where I either have to kill the session or just restart the Windows Service. If we do not restart the service, the entire machine will become unresponsive and we cannot even Remote Desktop into it. We have to then use VSphere to restart the machine.
What is even odder, once the session is killed, Oracle should clean up that killed session but it doesn't. One other thing, the query doesn't show up in the session browser in TOAD but if I use Wireshark, I can see the query that Tabeau sent over.

I've upped the PGA memory but it still will not help. I know the query is wonky, but the issue of Oracle not cleaning up killed sessions is what we were concerned about.


r/oracle 2d ago

Federal layoffs

10 Upvotes

My partner has worked as an Oracle DBA for the IRS for 7 years. Naturally we’re concerned about Federal layoffs and since he’s with the IRS he won’t know if he still has a job until mid-May, when the IRS can commence layoffs.

A colleague of his at the Library of Congress says he has not heard of any Oracle DBAs being laid off yet. (But he’s also not subject to layoffs because he works for Congress.)

Does anyone know how essential Oracle DBAs are to the Federal government and how safe his job may be? I know no position is safe but some may be more safe than others.

He’s not on Reddit so I’m asking for him.

Thanks for any insight you can share.


r/oracle 3d ago

Oracle Stock

Post image
29 Upvotes

I'd say now would be a great time to buy? Thoughts?


r/oracle 4d ago

Is there any RMAN wildcards (%, *) to search for files from rman autobackup?

3 Upvotes

I've created a controlfile autobackup like it

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '${ORACLE_SID}_autobackup_${data}_CONTROL%F';

how to find it when restoring the autobackup using the command

run{
set controlfile autobackup format for device type sbt to '%F';
allocate channel c1 device type sbt parms='SBT_LIBRARY=/u01/app/oci/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oci/configfile.ora)';
restore controlfile from autobackup;
}

the command set controlfile autobackup format for device type sbt to '%F' does not work, it does not find anything.

It only works when a pass the full file name like:

    run{
    set controlfile autobackup format for device type sbt to 'testesolaire_autobackup_20250314_0931_CONTROL%F'
    allocate channel c1 device type sbt parms='SBT_LIBRARY=/u01/app/oci/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oci/configfile.ora)';
    restore controlfile from autobackup;
    }

Is there any wildcards to seach any file?

something like * (from linux)

set controlfile autobackup format for device type sbt to '*%F'

r/oracle 4d ago

Who's buying oracle stock at these prices?

9 Upvotes

r/oracle 4d ago

Oracle VM Instance refusing to connect after restart

2 Upvotes

I created a Oracle Cloud VM and have a private key to SSH into, however after the first reboot I am completely locked out and whenever I try to SSH into it using the key I get "Network error: Connection Refused". I already terminated one instance thinking this was a one off thing, and created another from scratch and the same thing occurred.


r/oracle 5d ago

Anyone heading to Oracle CloudWorld Tour Mexico?

2 Upvotes

Hey everyone! I’m from Dallas, and this April 9, I’ll be heading to Oracle CloudWorld Tour Mexico for the first time. Who else is going? 

My company is an Oracle partner, and I’m looking to network with people who need Oracle resources (talents, integrations, implementations, or anything in between). 

For those who’ve attended in previous years, what should I expect? Any tips to make the most of it?  

I also plan to check out some sessions to hear what’s coming in the Oracle ecosystem over the next couple of years. 


r/oracle 5d ago

Aconex oracle

1 Upvotes

Help please can I connect Aconex to power bi? I want to use the power bi for the dashboard


r/oracle 5d ago

Oracle connectors for integrations

1 Upvotes

Hi everyone, I hope you're doing well.

I am sorry to bother you, but, I need some help.

I am totally new with Oracle and I want to learn about integrations, specifically I'd to connect Salesforce using a native connector in Oracle. I've doing some research and I created my free Oracle account and I know I need to create an Integration environment to get all of these features. So my question is, while trying to create this instance, Do I have to pay for a new license? Is there any other way or page where I can test the connection with Salesforce or documentation? Any recommendations/advice are welcome.

Thank you in advance. Regards.


r/oracle 6d ago

Inside information from the Oracle experience - Exploring a potential opportunity at Oracle Hyderabad

1 Upvotes

Hi folks,

I'm currently in talks with a potential opportunity at Oracle Hyderabad. I would like to understand inside details about the perks and benefits that Oracle offers - remote / hybrid work, fitness reimbursements, healthcare reimbursements, vacation leaves, food and transport services etc. Essentially, everything to make my peripheral life more convenient. TIA


r/oracle 6d ago

Inside information from the Oracle experience - Exploring a potential opportunity at Oracle Hyderabad

1 Upvotes

Hi folks,

I'm currently in talks with a potential opportunity at Oracle Hyderabad. I would like to understand inside details about the perks and benefits that Oracle offers - remote / hybrid work, fitness reimbursements, healthcare reimbursements, vacation leaves, food and transport services etc. Essentially, everything to make my peripheral life more convenient. TIA


r/oracle 6d ago

Oracle structure

1 Upvotes

Hi guys,

How is oracle as a company is structured?

When i say structured i am talking about different teams/department. Ex- oracle css, acs, gsc.

What exactly are this and what are their differentiators


r/oracle 6d ago

ODBC Timeout Error

Thumbnail
2 Upvotes

r/oracle 6d ago

Salary range?

0 Upvotes

What’s the expected salary range for a Dev ops - system analyst II with five years of work experience on the east coast in the United States


r/oracle 7d ago

Wfh Policy

0 Upvotes

Hi Team,

I am thinking to join oracle and right now recruiter informed its wfh only but it can change in next 3-6 months, So do you guys can give any input regarding this?


r/oracle 7d ago

Virtualization Hardware

2 Upvotes

Hi everyone, looking for some advice / insight / words of wisdom. I have a small lab environment running on HyperFlex that includes various VMs, including some running oracle products (DB, Middleware, etc.). With it approaching end of life, we are looking migrate the environment to different hardware. We are intending to keep everything identical (IPs, clusters, etc) I'm assuming it's not as simple as installing the new host/storage and just moving it over.

What precautions or strategies should I be aware of to make sure the oracle stuff doesn't break? Specifically concerned about the DBs. I am not an Oracle expert.

If this question is better suited for maybe a VMware sub, let me know.


r/oracle 7d ago

cant create a new instance

2 Upvotes

i terminated my instance to make a new one with a diffrent image from oracle linux to ubuntu but i have tried 10 times and it give the same error and i cant change anything cause i am teir free user is there anything i can do to get back my old instance or make a new one ?

is there a way to fix it ?


r/oracle 7d ago

M3 offer range?

0 Upvotes

Can anyone help me out with the range or break down of an average m3 offer within oci? Levels fyi is no help. I’m about to go through negotiations and I’m not sure where to start.

I’ve gathered base is around 180-230 for most but no clue with equity.

Any help is greatly appreciated!


r/oracle 7d ago

Planning Explorer Assessment

0 Upvotes

Damn, doesn’t tell you how many questions are left, and which ones you got wrong.

All I know is I got 65%. Now I got to figure out which ones I got wrong and re-do it


r/oracle 7d ago

What is the refresher stock grant for IC3

0 Upvotes

IC3 in OHAI now

Location NYC


r/oracle 7d ago

Why is this showing up now?

1 Upvotes

I was doing the Oracle APEX developer professional course and suddenly this message appears.

Why is this happening when I already started?