Skip to Main Content

Core Infrastructure

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

NFS How to configure on Oralce Linux 9.5?

ASGR71Jan 29 2025

Hello All!

I'm trying to configure NFS on my OL9.5 server machine so that I can log-in and edit

server SQL scripts, set-up, config files etc…

However, I'm getting the following when I try to log in to NFS:

mount.nfs: Connection timed out for…

I've tried installing NFS as per Oracle docs which seemed too basic and I also tried other

Oracle sites but they started to refer to /etc files that don't exist!

I was under the impression that I only needed to open services for:

111 rpc-bind, 2049 nfs, 20048 mountd…

but it now seems that several other ports need to be opened as static as well for firewall purposes.

I checked with nmap from my dev machine and the open ports are getting through the firewalls:

PORT STATE SERVICE
111/tcp open rpcbind
2049/tcp open nfs
9090/tcp open zeus-admin
20048/tcp open mountd

I believe I'm having issues with these additional ports for: nlockmgr and status. Output from rpcinfo…

program vers proto port service
100000 4 tcp 111 portmapper
100000 3 tcp 111 portmapper
100000 2 tcp 111 portmapper
100000 4 udp 111 portmapper
100000 3 udp 111 portmapper
100000 2 udp 111 portmapper
100024 1 udp 42250 status
100024 1 tcp 33069 status
100005 1 udp 20048 mountd
100005 1 tcp 20048 mountd
100005 2 udp 20048 mountd
100005 2 tcp 20048 mountd
100005 3 udp 20048 mountd
100005 3 tcp 20048 mountd
100003 3 tcp 2049 nfs
100003 4 tcp 2049 nfs
100227 3 tcp 2049 nfs_acl
100021 1 udp 48495 nlockmgr
100021 3 udp 48495 nlockmgr
100021 4 udp 48495 nlockmgr
100021 1 tcp 44795 nlockmgr
100021 3 tcp 44795 nlockmgr
100021 4 tcp 44795 nlockmgr

I've looked at the /etc/nfs.conf file and it looks like I should be able to define the additional ports in this file.

Guidance how to set the correct static port number would be appreciated. Thanks.

SYSTEM:

Oracle Linux 9.5

Oracle Database 19.3

Comments

MartinBach-Oracle Jan 8 2025

Hi Salomon,

please have a look at this blog post written by @ulrike-schwinn-oracle :

https://blogs.oracle.com/coretec/post/easy-sql-statement-tracking-in23c

I hope this answers your question, if not, please shout!

- Martin

Solomon Yakobson Jan 8 2025

@martinbach-oracle - No, it doesn't answer my question. Article you pointed to shows uses:

SQL> alter system set sql_history_enabled=true scope=both;

And in my post I said “Works fine when enabled on system level”. My question was about

SQL> ALTER SESSION SET SQL_HISTORY_ENABLED = TRUE;

where I showed SQL history was NOT captured even though it should be based on SQL_HISTORY_ENABLED:

Modifiable **ALTER SESSION**, ALTER SYSTEM

SY.

MartinBach-Oracle Jan 8 2025

As per the article I shared the situation is as follows at the moment

  • You must enable SQL history PDB-wide (only a DBA can do that) so there's a certain level of control over the feature
  • Your session has access to the SQL history
  • If you don't want to record anything, set sql_history_enabled to false.

I'm currently assessing if that's intended behaviour (in which case the documentation should be amended) or a feature not working as it should (in which case it needs fixing). The parameter is indeed session-modifyable, but not in the sense you expected.

We'll keep you posted.

- Martin

Solomon Yakobson Jan 8 2025

Do you mean it must be enabled on system level and not on session level and all session can do is disabe it for the session?

SY.

MartinBach-Oracle Jan 14 2025

Yes,

that's correct as of Oracle Database Free 23.6.

- Martin

Solomon Yakobson Jan 14 2025

Thanks Martin, I hope this will be added to 23AI docs soon.

SY.

1 - 6

Post Details

Added on Jan 29 2025
0 comments
56 views