Best Of
Re: How to set up Privilege Delegation to sudo to oracle with shell set to /sbin/nologin
Hi,
Find the steps provided below:
1) On the target host configure sudo with no password for the user in question e.g.
visudo
<username> ALL=(ALL) NOPASSWD: ALL
2) Configure the public a private keys as per usual using "ssh-keygen".
3) On the target server
agent_inst/sysman/config/emd.properties
# EMPDP_PASSWORD_PROMPT_SUDO=MAYBE
EMPDP_PASSWORD_PROMPT_SUDO=FALSE # Add this line
(This is the key step here).
4) Restart the agent
5) Configure a global set of named credentials in the UI as per normal, but this time using the "Run Privilege" sudo and the user as oracle/root
6) Create a test file:
[oracle@apem16 ~]$ ls -l test
-rw------- 1 oracle oracle 33 Sep 10 00:58 test
[oracle@apem16 ~]$ cat test
This is an oracle read only file
6) Create a simple job using the named ssh key credentials to confirm your steps are correct.
Display the read only test file would be a good test:
cat /home/oracle/test (Assumes your runas in step 5 was oracle).
Best Regards,
Venkat
Re: Sorry - Simple SIP-Manip question
Cheers Antonio.
I must have tried every combination I could think of.
KISS always works.
Paul.
Re: Sorry - Simple SIP-Manip question
Hello Paul
give it a try to the following ER :
element-rule
name mod_from_ER
parameter-nametype uri-user-only
action replace
match-val-type any
comparison-type pattern-rule
match-value ^\+697\d{2}(.+)
new-value "+"+$1
Cheers
Antonio
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
@Mr. C Your opinion is just that, your opinion. While you may raise some "valid" points for optional ways of doing things - which may be better suited to those more versed in Linux/Unix - many (most) are not.
The instructions were written for those with no experience in mind, and ensuring that one is in the expected locations prior to actions being taken.
Your suggested improvements have been reviewed and rejected.
I'll maintain the written instructions as they are, for the benefit of that absolute Unix/Linux Novice. A more advanced user can see the instructions and is welcome implement in a manner that best suits himself/herself.
Re: How can I get all 9 digits of precision in systimestamp?
I'm not sure which version of java oracle 19 is using but I think the java version is too old to support nano-seconds. For what I have read nano seconds are available at Java 17 and above.
***Update
I find it out, it's too old.
SQL> SELECT dbms_java.get_jdk_version JDK_Version FROM dual;
JDK_VERSION
1.8.0_201
Re: How can I get all 9 digits of precision in systimestamp?
I guess that was done with the idea of "sub order by some arbitrary value", but then you may just sub order on some other column value instead as well.
Mr. C
Re: How can I get all 9 digits of precision in systimestamp?
Never order by rowid. ROWID will change by doing an export/import of data. Or by creating a second table which is a copy of the first one.
Re: How can I get all 9 digits of precision in systimestamp?
It's actually one billion, as 6 digits = 999999 and 9 digits is 999999999 … :)
But I guess that it's not that there are 2 inserts for every millionth of a second ( or even billion, doesn't matter as both are huge), I think the case may be that "it can happen" that there are 2 records in the same millionth/billionth of a second. That is something else. Maybe there aren't even a lot of records, but "something" is making them collide for the records that do exist. You never know, maybe this is coding to go to Mars, you don't know.
Mr. C
Re: How can I get all 9 digits of precision in systimestamp?
Hello Lisa,
if you have several rows inserted during the same millionth or a second, is the « real order » so important ? Does it even have a sense?(maybe yes, for example if you work in a nuclear experiments center)
If yes you have to fix the « issue » but if no, no need for a sequence that might impose too much extra work if order must be guaranteed; I would order by the timestamp(6)+rowid.
BTW, more than 1 million inserts in 1 second? I hope that it doesn’t happen too often, or our beloved Oracle is maybe not what you need…
Best regards,
Bruno Vroman
Re: How can I get all 9 digits of precision in systimestamp?
Didn't know Linux could go that deep, but then indeed it may be an Oracle issue getting that info from the OS.
Mr. C