I need to showcase the different security measures of oracle databases like TDE etc etc, but I don't know which version I need to get. Also how much do I have to pay ?, I just need it for educational purposes.

Hi everyone!

I’m 21 years old and currently in my 1st year of B.Tech. I’m interested in becoming an Oracle Database Administrator (DBA) and want to know how to get certified. I have a few questions:

1. Am I eligible to take the Oracle DBA certification exams?
2. Is there any oral test, or are all exams written/computer-based?
3. How much does the certification exam cost?
4. Does the certification have an expiry date?
5. What’s the general process to prepare for and pass the certification (OCA/OCP)?

thanks for reading

3 months before I was given a offer and later oracle posted hire freeze and my offer also is frozen . Can anyone please have any update on this ?

Same as the title but the interview is tomorrow so any insight will be helpful.

I attempted to prevent unauthorized access to wp-admin by restricting it to a specific IP address using WPCode. However, I accidentally entered the wrong IP, which has now locked me out. I tried using PuTTY to locate where WPCode stores its snippets but couldn’t find the file.

As the title suggests, I’m currently locked out of my WordPress admin area. I need help connecting FileZilla to Oracle Cloud. The issue is that Oracle Cloud uses SSH keys, while FileZilla requires a username and password. How can I set up this connection?

Hello there! Right now just a little clueless about how to link a Large Language Model in a Google Colab Notebook (python notebook) to Oracle Apex. I wanted to create a chatbot in Oracle Apex that uses the LLM capabilities in my Google Colab. I thought of using REST API to somehow push the model path file into Oracle Apex but not sure the exact process and application of it. If anyone thought of something applicable, it would be of much help! Thanks!

Hi, through my employer I'm looking to acquire Oracle Certified Professional: Java SE 17 Developer certification (exam 1Z0-829). I would like to find out if by purchasing the one time exam subscription ($245 one) do I also get access to associated e-learning path? If not, what other resources would you recommend?

Hi

some context: after a lot of pondering I decided to came here and ask you about my possible upcoming journey into being an Oracle DBA (or similar figure). I've been working in IT for just a year as a consultant in a banking help desk / data analyst position, but I've fiddled with IT for most of my life.

I've recently been offered a junior position as Oracle DBA at the same company, since I already know lot of the guys that do that and studied some SQL (I know it's not necessarily the core of what a DBA does), or a less-IT oriented position with some middle-management responsibilities (but not higher pay).

I feel I might need some HARD IT skills going into the future and being a DBA was one of the things I was looking for, however, here's the catch. I hate depending ONLY on others, and I prefer learning by myself, but the material about going and taking Oracle Certs or understanding how to get into this world seem really really really scarce and awfully presented.

Even official documentation seem to work AGAINST you. I already did the combo "foreigner with bad accent that speaks bad english on udemy (english is not my main language btw) + local VM + hyphotethical free cloud account" to understand basic concepts but the whole process sucked and I quit.

So I'm asking you, do you have reliable resources a part from the 5000$ official course and asktom that I could use to "accelerate" the process and understand Oracle better? Also does this roll give you some skill that can be somehow be expanded or transfered in the future or will lock you in a hyper specific operational position?

Thank you very much

Title. I'm running Ubuntu Server and want to install the Oracle Hardware Management Pack so I can manage my storage from the ILOM. I can't for the life of me figure out where to obtain said pack. Can someone point me in the right direction?

I've logged into my oracle support and gone through the product search. It says Firmware on the Access column which is no use to me. Downloading isn't an option when I click on a given row.

When I run my application only 9 of my 16 entries are displayed in the navigation screen. Whoever is claims I have 16 entries. All 16 entries open and work when I click on the page and run it from there but won’t appear when I run app.

Anyone know why this is?

Hi,

I'm new to OCI. I'm used to having a "SQL Database Project" containing all my DDL and stored procedures, then deploying this package to my database using a CI/CD pipeline. What is the best practice for doing this with ADB? Is there an opinionated tool or framework? Or would I just write some bash scripts to execute my SQL scripts?

Hello,

On my MacBook OSX laptop I keep getting an SSL certificate error on www.oracle.com. I don't experience this on my Windows machine.

I'm getting this issue only under www.oracle.com, other sub-domains such as docs.oracle.com don't cause any problems.

1. am I the only one?
2. any idea why is this happening?
3. would it be safe to import the certificate manually?

https://preview.redd.it/dwoe9wdome3e1.png?width=840&format=png&auto=webp&s=83ca2f6643e295485af562cdb0620a39f50b3e12

https://preview.redd.it/v9bz0z0qme3e1.png?width=794&format=png&auto=webp&s=43d36c7f372705e203bbd899739e975f41df3849

I received an email today from a TA asking for 45 minutes to interview for this role. I feel that I am a good fit and my career interests align well with the role based on its description. I am very excited! So, in order to succeed in getting this position, how may I prepare for it? I haven't interviewed in a while so I don't know what to expect.

Do they focus more on the technical details like leet code sort of timed tests / take home / live coding or do they focus on behavioural assessments?

Any guidance would be appreciated. Thank you in advance!

Hi all,

Oracle OCI reached out to me regarding an OCI account engineering manager role. TC not clear yet.

What are your thoughts on OCI future relevance?

With AWS, Azure and GCP as key players, what sets OCI apart? What are relevant workloads that enterprises would move to OCI?

What are your thoughts / experiences?

Any insights highly appreciated.

Found this in one of the Oracle blogs:

> In PL/SQL, the maximum size for CLOB is 128 terabytes, while in SQL the maximum is just (4 GB - 1) * DB_BLOCK_SIZE.

128TB seems like an overkill, is this accurate lads?

For people who are working remote, I know they give you the option of which laptop when you are doing your new hire journey. My question is, other than laptop and docking station, are any other equipment pieces like monitors or keyboard/mouse also part of that, or just the laptop/docking station?
Trying to plan my desk layout when my laptop arrives.
Thanks!

I'm using a specified folder for log archive.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /arc2
Oldest online log sequence     122
Next log sequence to archive   124
Current log sequence           124
SQL>

Now I want to change it back to use FRA. Is this correct?

alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST';

It seems this change is valid:

select dest_name,
       destination,
       status,
       binding
  from v$archive_dest;

DEST_NAME                                DESTINATION                              STATUS    BINDING
---------------------------------------- ---------------------------------------- --------- ---------
LOG_ARCHIVE_DEST_1                       USE_DB_RECOVERY_FILE_DEST                VALID     OPTIONAL
LOG_ARCHIVE_DEST_2                                                                INACTIVE  OPTIONAL
LOG_ARCHIVE_DEST_3                                                                INACTIVE  OPTIONAL
...

But the problem is that, if I intentionally make some errors like:

SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DESTaaaaaaa';

System altered.

SQL>

It still shows as valid:

select dest_name,
       destination,
       status,
       binding
  from v$archive_dest;

DEST_NAME                                DESTINATION                              STATUS    BINDING
---------------------------------------- ---------------------------------------- --------- ---------
LOG_ARCHIVE_DEST_1                       USE_DB_RECOVERY_FILE_DESTaaaaaaa         VALID     OPTIONAL
LOG_ARCHIVE_DEST_2                                                                INACTIVE  OPTIONAL
LOG_ARCHIVE_DEST_3                                                                INACTIVE  OPTIONAL
...

Could anyone tell me what's the correct way to switch archive log destination from specific directory to FRA? I'm using Oracle 12c and 19c. Thanks.

A family member of mine works at Oracle and has an old ThinkPad T490 which works perfectly fine but has to be retired back to the company, I was wondering if there is any way you could ask the company for the laptop for personal use as it would be discarded as electronic waste anyways and it would be better if it was given another chance at life.

My code is correct and I can make tables but for some reason it won’t allow me to insert into them. I think it’s an issue with my permissions. How to fix?

Cleared 1st tech round it was 45 minutes coding ( relatively easy one ) , now I got loop interview for 4 hours ( 2 tech , 1 behavioral, 1 system design ) if any one attended loop interview in oracle , please highlight your experience and questions ??. Also it would be helpful if you can highlight the resources you have used to prepare?? Thanks

I just cleared the first tech round, which was a 45-minute coding challenge (nothing too challenging). Now, I’ve got a loop interview coming up for 4 hours! It’ll be a mix of two technical interviews (one for each of the two tech roles) and one behavioral interview. If anyone has attended a loop interview at Oracle, please share your experience and any questions you had. It would also be great if you could mention the resources you used to prepare for the interview. Thanks a bunch!

Is there a way to run a detailed GL report showing payable and receivables in details. Right now it only shows them as a bulk journal entry.

Hi, I've applied fir Incentive Compensation Analyst in Bucharest and i have an excel test tomorrow. Does anybody have any details, is it easy stuff or intermediate/advanced like VLOOKUP, pivot tables etc?

I have 2 windows machines with Oracle 19c installed. Using RMAN from source backup the database then transfer the files to the target and then trying to restore them in the target machine. But it not possible getting errors.

RMAN

I search for different ways and not got any solutions specific to windows Oracle19c(mostly Linux environments are available). Give me any suggestions/ideas to resolve this.

The $5k OracleU is asking for their subscription is just a bit too much for me right now. Anyone have a good syllabus that I can follow along and learn on my own to prepare for the certification exam?

I have some DB experience from many years ago; so, I need quite a bit of refresh.

Hi! is there a way to use excel and extract data from the Aconex database? My company uses aconex to manage the review and storage of technical documentation. Atm I just use the embedded aconex function to extract the database to an excel file and manipulate it in excel. However every time I have to extract the whole database to an excel file to have the most updated version of it. It would be easier if i could just "interrogate" the online database from the excel file directly. Is that possible and if yes how?