Hey reddit. Can I copy lag times between relationships/activities in P6? There are multiple relationships that all have the same lag time and I can’t figure out how to edit them in bulk!

Any help is sincerely appreciated and I will even tip! This will save me countless hours.

What questions were asked?

​

What was the difficulty/how much time did you have?

Question… and I’m prepared to be bullied because I honestly don’t know the answer to a question asked by my interviewer yesterday. I was interviewing for a Project Manager - ERP implementation role. Where I would be implementing Oracle ERP 12.2 at a CNC and Plasma Cutting manufacturing site. The facility is older and required the jump to Oracle from an older system and also would require change management strategy (this latter piece is where my degree comes in, but not so much work with Oracle ERP in the past).

They interviewer asked, “who did you use to implement the new or updated Oracle ERP system across your organization?”

I said, “the PM team including Senior PM, product owner, Scrum master and scrum team”.

Am I wrong? What should have been my answer? Were they asking about the vendor who sold us the ERP system? The engineers working on the project? The consulting team who trained us on the use? WHO?!

Please help me with the correct answer!

Hello everyone,

Is it possible, and if so, how to create a synonym table that is on another database?

for example I have two databases, DB1 and DB2. DB2 database has table TABLE1

is it possible to create a synonym based on DB1 so that I can use the query "select * from REMOTE_TABLE1". I would also like DB1 to have only select rights over TABLE1 in DB2

Hi,

Company wide issue, those who are required to periodically Authenticate have all been prompted to pass Authentication today and all Authentication fails.

Some of us use the Microsoft Authentication App, some of us have Backup Codes. All failing.

Only roles that don't have 2FA are getting in.

Anyone else having this problem?

Hi guys, I have 2 questions. Please let me know if I can restart the sshd in the server without impacting the DB and grid . I need to enable X11 , so need to make changes in sshd_config file, later restart the same once changes are done. Will this impact the DB or the connections ? 2nd question, we're using 2 node rac 19c, I need to restart ASM instance in only node 1 , using srvctl stop asm -n <hostname> -f . Just wanted to make sure this won't impact availability of the DB right ? Also what does -f do? Thanks in advance .

Anyone knows how much it costs to implement in a company? I'm just curious cuz my company uses the same

joining oracle as an employee in usa. after offer acceptance, background check, when do they usually dispatch computer? thanks.

I have set up a vps with Ubuntu.

But this machine lost internet connection out of nowhere and I can't install packages or configure anything.

The network configurations in the Oracle console are correct and active.

Does anyone know a possible cause and/or solution?

Hi, I am having trouble with an issue I didn't have before which is that I am now unable to save SQL scripts in Apex SQL Workshop. I am using it for a class in Database Management so I have an account through my course. I have uploaded the SQL schema and running SQL scripts returns the correct data and previously I was able to save scripts without any difficulty but now when I hit “Save” nothing happens no matter how long wait and the script is not saved. This is a problem since my professor checks our work through our accounts saved SQL scripts.

I have tried this on different computers, tried restarting the computer, signing out and logging back in. I'm using it in Chrome, I tried using a different browser but it wouldn't even let me log in even though my username and password were right. My teacher doesn't seem to know why this is happening and I don't really know what could be causing it. Would love any advice thanks in advance!

My company is going to start using Oracle for inventory control. They want to use scanner when removing inventory. We use iPhones, can't we use those as scanners?

Encountering a snag while attempting to connect my .NET 8 application to an Oracle database using Dapper and Oracle.ManagedDataAccess 21.13.0. The error message reads: "System.IO.FileNotFoundException: Could not load file or assembly 'System.Configuration.ConfigurationManager, version=0.0.0.0, Culture=neutral. The system cannot find the file specified."

Any insights into why it's attempting to load the ConfigurationManager v0.0.0.0 assembly? Any solutions or workarounds would be greatly appreciated! Thanks in advance.

Long story short:

Veeam has introduced support for Oracle Linux KVM, more info from the recent forum post:

https://forums.veeam.com/ovirt-kvm-f62/kvm-backup-recovery-t77062.html

I wish to take oracle Responsys certification. To view the course recording in mylearn oracle website, oracle is asking to pay for it. If I purchase “Oracle Cloud Infrastructure (OCI) Self-Paced Labs Subscription - 1 month” will I able to watch the recording session and prepare for “Certified Responsys Implementation Specialist” ?

Heya! First time posting. I had a few questions regarding OCI associate certification.

At this stage of life at 40 I want to attain certs that will show my experience as a technical support person. Grant it I am above average when it comes to the standard user, but I want to capitalize and expand on what I know.

Pretty much long story short once I get this cert, what doors does that open for me?

Would I need to specialize in another sub-cert in OCI to really bring out the certification?

If that's the case what sub-certs are there that I can chase?

Is OCI AI something I should really consider as that is the latest technology out in play?

Tbh like most I'm looking to make sure I have the skills necessary for this career path... It was rough being laid off when my position was "no longer necessary". Luckily I found a job in Oracle, but unfortunately the pay can't cover the bills (looking for a second job). Financially I want me and my kids to be stable. That way they don't have to worry about their ol man 😆 and I can come off this blood pressure medicine and anti-depressants. 😫

Any advice would be great and if y'all can be my mentors that would be even better 😁

I know it's a lot of questions but Google isn't providing me great information. Also please let me know if there is a better channel for questions such as this.

I'll stop babbling now, and thanks for the future replies!

Hi guys, facing a weird issue. DB is up and running fine , wanted to add more space to one of the data disks. Started ASMCA , diskgroups and instances are showing up but it's empty under volumes and acfs file systems . Nothing comes up after refresh . Just empty page. How can I fix this without bringing the DB down . It's a 2 node prod env , with dataguard . ASMCA shows all volumes and FS in DR env though.

Been tasked with upgrading all WebLogic domains, one domain in question is OER, with it's last published version of 12.1.3. I understand we can use MDS for most things WSDL and XML used for XSD to be able to reuse SOA resources, but the aspect of being able to access WSDLs externally (by third parties needing to know the API spec) is an unanswered question. Is there any current replacement product Oracle offers instead of OER?

I tried to create a free tier Oracle Cloud account yesterday but it kept crashing in the last step where all the verifications were done and just a click of the button should complete my application.

EVERYTIME I complete my sign up, it said that they can’t complete the sign up because of some common errors. Okay, let’s look into that.

1. Entering incomplete or inaccurate information.

Hey I’m using my real proton mail account without using aliases. I’m copying the billing address on my credit card statement. I’m using my primary mobile phone number. I used the bank issued card and completed the verification. What do you mean incomplete or inaccurate information?

2. Intentionally or unintentionally masking your location or identity.

As I mentioned above, all information is true and verified. In addition, I’m using my true IP address.

3. Attempting to create multiple accounts.

This is my FIRST time creating this account. Before yesterday, I only know this service exists but never attempted to create an account.

Alright, it might be my mistake. So I reached out to the 24/7 online support. That person told me that it could possibly a glitch where it attempted to send the form multiple times. So that person suggested me to resubmit the form again 20 minutes later using incognito mode and this should not affect my application validity.

Okay I tried FIVE TIMES in total. I used my desktop computer and I also used my phone. All attempts ended up with the same error. So I tried to contact the customer service by filling out the form this time. I also found that there are some people encountered the same issue before and got a disappointing response years ago. This is their response this time.

Hello,

Unfortunately, we are unable to resolve this or process the transaction. This is all the information we can provide.

Regards, Customer Service Agent

Hey, what? This response is clearly a template. Isn’t it a very simple sign up form? It’s a glitch that even Oracle cannot resolve? What a joke.

Support doesn’t exist, and I’ve spent the better part of two weeks trying to download this god forsaken application. I’ve even tried on an entirely new computer and same problems abound. I’m honestly not sure how anyone has ever downloaded this.

Hi guys. Im having some problems understanding the role that the listener plays locally.

As i understood it, every connection attempt to the database has to go through the listener. However, when i stop the listener (i have only one listener) using lsnrctl, i can connect to the db locally through sqlplus just fine.

Is my understanding on the role of the listener wrong or does something else come into play that i'm not aware of?

I’m a recent T30 MBA grad with a background in FP&A and Accounting. Was hoping to connect and learn more about your career and potential entry points.

I have been using SQLDeveloper for years but feel like there are so many features I've never even tried using.

Can anyone recommend a book or video that gives a tour of some of the cool-but-non-essential features that basic users may never find out?

Can anyone either explain how to add a welcome/consent banner to an existing weblogic site, or point me to a guide or documentation? I want the user to see the banner prior to gaining access to the site.

I have an Oracle table with 400,000 records, and the DATA_NAME and SEQU_ID fields has index. We have also rebuilt the index on that table today. However, executing the following query takes 2 to 3 minutes. Can anyone suggest a solution?

Select distinct SEQU_ID,DATA_VALUE from DATA_MYSUBMISSION_DETAILS where DATA_NAME ='PLAN_ID';  Initializing connection... Connection ready. Took 2.405 seconds.  Statement completed successfully. (21832 results). 2 minutes, 12 seconds. (Line 1).  Finished. Total time: 2 minutes, 15 seconds. 

Table structure => DESC DATA_MYSUBMISSION_DETAILS

       Name              Null?       Type                    
-----------------      --------     --------------          
RECORD_ID               NOT NULL    VARCHAR2(34)            
SEQU_ID                 NOT NULL    VARCHAR2(34)           
DATA_NAME               NOT NULL    VARCHAR2(100)           
DATA_VALUE                          NVARCHAR2(512)          
DATA_INDEX              NOT NULL    NUMBER(18)              
RELATED_RECORD_ID                   VARCHAR2(34)            
CREATED_BY                          VARCHAR2(34)            
CREATED_TS                          TIMESTAMP(6)            
MODIFIED_BY                         VARCHAR2(34)            
MODIFIED_TS                         TIMESTAMP(6)   

INDEXS => SELECT index_name FROM all_indexes WHERE table_name = 'DATA_MYSUBMISSION_DETAILS';

"INDEX_NAME"     
"IDXDATADETSEQID"     
"IDXDATADETPROPVAL"     
"INDXDATADETPROPNAME"     
"DATA_MYSUBMISSION_DETAILS_PK" 

---edited----
Added image of output of SET AUTOTRACE TRACEONLY

https://preview.redd.it/377erm5sr3rc1.png?width=568&format=png&auto=webp&s=e26a9c251fb05cf9081ccfaa858566dcc1336807

https://preview.redd.it/oh8rujusr3rc1.png?width=642&format=png&auto=webp&s=b74ee5287cd2160c130c66558b9c1983e344614f

Tried multiple times to create a free account, I verify payment and identity and it accepts but when I press create account it says error and then various reasons like I try to make more than one account, or that I lied in identity. Support not really helping, what should I do?

Hi everyone, I’ve been trying to install and learn Oracle 19c on my Windows 11 Pro laptop.

I originally thought that 21c was a good choice because it was free. Then I read that 19c was better because it’s still widely used. But after my uninstall of 21c, I’ve had nothing but issues with 19c. I followed a video on YouTube and everything was fine at the start. However, I probably made a big mistake in uninstalling 19c, and then trying to reinstall it. I did this to learn about its installation process, and I wanted to do a few things differently.

The issues have mainly involved the listeners. Oracle says port 1521 is in use by another program, but as far as I can tell it’s not. I tried different ports to work around it (1523, 1600 for example), but got the same errors. I was eventually able to find a port, but then the listener wouldn’t even start.

I followed directions about uninstalling 19c, deleting registry files where needed. I ran the deinstall. But, still issues. I have the registry backed up in case I need those keys again.

Any ideas of what I can do to fix this issue? And should I just skip 19c and go straight to 23c (in docker for example)? Appreciate the help.

When trying to reverse receipts using the receipt form, an error message popups that says "AR_APP_ACCT_MANDATORY". I cannot find anything about this error aside from a post on the oracle support site which I cannot access.

So far we only encounter this issue for one customer, so we are thinking this might be related to an accounting setup.
We are using R12 Oracle EBS.

Thank you and I hope this community allows questions like this.

Hey. I am trying to understand the Oracle Java license terms, but are uncertain when it comes to their licensing when running on OCI compute instance.

Their cloud license agreement mentions:

For (a) all IaaS Cloud Services and (b) PaaS Cloud Services that permit direct user access to the operating system, You will receive a free license for each of the products listed on the following web page: https://oss.oracle.com/licenses/oci-included-apps/index.html, in each case under the terms linked for each product on that page. Oracle does not provide technical support for any of the products listed there.

​

For (a) all IaaS Cloud Services and (b) PaaS Cloud Services that permit direct user access to the operating system, you will receive a free Oracle Java SE license for Your instances in the Oracle Public Cloud or in the Oracle Compute Cloud@Customer that will be provided in accordance with the Oracle Technology Network License Agreement for Oracle Java SE found here: https://java.com/otnlicense.

The Oracle Technology Network License Agreement mentions

"You" and "Your" refers to (a) a company or organization (“Entity”) accessing the Programs, if use of the Programs will be on behalf of such Entity; or (b) an individual accessing the Programs (“Individual”), if use of the Programs will not be on behalf of an Entity

...

“Oracle Cloud Infrastructure Use (“OCI Use”)” refers to Your use of the Programs on Oracle's Cloud Infrastructure with the Oracle Cloud Infrastructure products identified in the Oracle PaaS and IaaS Universal Credits Service Descriptions available at http://oracle.com/contracts during the period in which You maintain a subscription for such Oracle Cloud Infrastructure products.

License Rights and Restrictions Oracle grants You a nonexclusive, nontransferable, limited license to use the Programs, subject to the restrictions stated in this Agreement and Program Documentation, only for:

(i)     Personal Use,

(ii)    Development Use,
(iii)   Oracle Approved Product Use, and/or
(iv)   Oracle Cloud Infrastructure Use.

All clear so far.
But I can't help looking for the caveats in this agreement, which I expect to be there but cannot find.

​

Am I right in assuming:

1. This means a company can avoid having to buy an Oracle Java licenses for all their employees (despite only a handful actually need Java SE to be installed) by running the workload on OCI compute services
2. Multiple users can login to that compute instance and use Java apps without violating the license
3. There are no license restriction when joining the host to an Active Directory domain controller via a site-to-site VPN to the office. Effectively making the compute instance a domain-joined server.

Did I overlook some important definitions/restrictions? Are there any restrictions when it comes to using Oracle Java on OCI other than those mentioned in the agreements above?
Thanks