159. May 0614:23:54 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon... 160. May 0614:23:55 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon. 161. May 0614:23:55 localhost.localdomain firewalld[750]: WARNING: AllowZoneDrifting is enabled. This is considered an insecure configuration option. It will be removed in a future release. Please consider disabling it now. 162. May 0615:04:02 s18c systemd[1]: Stopping firewalld - dynamic firewall daemon... 163. May 0615:04:03 s18c systemd[1]: Stopped firewalld - dynamic firewall daemon.
302.# /etc/security/limits.conf 303.# 304.#This file sets the resource limits for the users logged in via PAM. 305.#It does not affect resource limits of the system services. 306.# 307.#Also note that configuration files in /etc/security/limits.d directory, 308.#which are read in alphabetical order, override the settings in this 309.#file in case the domain is the same or more specific. 310.#That means for example that setting a limit for wildcard domain here 311.#can be overriden with a wildcard setting in a config file in the 312.#subdirectory, but a user specific setting here can be overriden only 313.#with a user specific setting in the subdirectory. 314.# 315.#Each line describes a limit for a user in the form: 316.# 317.#<domain> <type> <item> <value> 318.# 319.#Where: 320.#<domain> can be: 321.# - a user name 322.# - a group name, with @group syntax 323.# - the wildcard *, for default entry 324.# - the wildcard %, can be also used with %group syntax, 325.# for maxlogin limit 326.# 327.#<type> can have the two values: 328.# - "soft" for enforcing the soft limits 329.# - "hard" for enforcing hard limits 330.# 331.#<item> can be one of the following: 332.# - core - limits the core file size (KB) 333.# - data - max data size (KB) 334.# - fsize - maximum filesize (KB) 335.# - memlock - max locked-in-memory address space (KB) 336.# - nofile - max number of open file descriptors 337.# - rss - max resident set size (KB) 338.# - stack - max stack size (KB) 339.# - cpu - max CPU time (MIN) 340.# - nproc - max number of processes 341.# - as - address space limit (KB) 342.# - maxlogins - max number of logins for this user 343.# - maxsyslogins - max number of logins on the system 344.# - priority - the priority to run user process with 345.# - locks - max number of file locks the user can hold 346.# - sigpending - max number of pending signals 347.# - msgqueue - max memory used by POSIX message queues (bytes) 348.# - nice - max nice priority allowed to raise to values: [-20, 19] 349.# - rtprio - max realtime priority 350.# 351.#<domain> <type> <item> <value> 352.#
354.#* soft core 0 355.#* hard rss 10000 356.#@student hard nproc 20 357.#@faculty soft nproc 20 358.#@faculty hard nproc 50 359.#ftp hard nproc 0 360.#@student - maxlogins 4
362.# End of file 363.#OracleBegin 364. oracle soft nofile 1024 365. oracle hard nofile 65536 366. oracle soft stack 10240 367. oracle hard stack 32768 368. oracle soft nproc 2047 369. oracle hard nproc 16384 370. oracle hard memlock 134217728 371. oracle soft memlock 134217728 372.#OracleEnd
382.#%PAM-1.0 383. auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so 384. auth substack system-auth 385. auth include postlogin 386. account required pam_nologin.so 387. account include system-auth 388. password include system-auth 389.# pam_selinux.so close should be the first session rule 390. session required pam_selinux.so close 391. session required pam_loginuid.so 392. session optional pam_console.so 393.# pam_selinux.so open should only be followed by sessions to be executed in the user context 394. session required pam_selinux.so open 395. session required pam_namespace.so 396. session optional pam_keyinit.so force revoke 397. session include system-auth 398. session include postlogin 399. -session optional pam_ck_connector.so 400.#OracleBegin 401. session required pam_limits.so 402. session required /lib64/security/pam_limits.so 403.#OracleEnd
610. LSNRCTL for Linux: Version 18.0.0.0.0 - Production on06-MAY-202115:23:07
612. Copyright (c) 1991, 2020, Oracle. All rights reserved.
614. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s18c)(PORT=1521))) 615. STATUS of the LISTENER 616. ------------------------ 617. Alias LISTENER 618. Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production 619. Start Date06-MAY-202115:09:51 620. Uptime 0 days 0 hr. 13 min. 15 sec 621. Trace Level off 622. Security ON: Local OS Authentication 623. SNMP OFF 624. Listener Parameter File /u01/app/oracle/product/18.0.0/db/network/admin/listener.ora 625. Listener Log File /u01/app/oracle/diag/tnslsnr/s18c/listener/alert/log.xml 626. Listening Endpoints Summary... 627. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s18c)(PORT=1521))) 628. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) 629. Services Summary... 630. Service "64a52f53a7683286e053cda9e80aed76" has 1 instance(s). 631. Instance "s18c", status READY, has 1 handler(s) for this service... 632. Service "s18c" has 1 instance(s). 633. Instance "s18c", status READY, has 1 handler(s) for this service... 634. Service "s18cXDB" has 1 instance(s). 635. Instance "s18c", status READY, has 1 handler(s) for this service... 636. The command completed successfully
647. SQL*Plus: Release 18.0.0.0.0 - Production on Thu May 615:23:172021 648. Version 18.14.0.0.0
650. Copyright (c) 1982, 2018, Oracle. All rights reserved.
653. Connected to: 654. Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production 655. Version 18.14.0.0.0
658. NAME TYPE VALUE 659. ------------------------------------ ----------- ------------------------------ 660. audit_trail string DB
662. NAME TYPE VALUE 663. ------------------------------------ ----------- ------------------------------ 664. deferred_segment_creation boolean FALSE
666. NAME TYPE VALUE 667. ------------------------------------ ----------- ------------------------------ 668. result_cache_max_size big integer 0
670. NAME VALUE DESCRIB 671. ---------------------------------------- ---------- ------------------------------------------------------------ 672. _use_single_log_writer ADAPTIVE Use a single process for redo log writing 673. _use_adaptive_log_file_sync TRUE Adaptively switch between post/wait and polling 674. _optimizer_cartesian_enabled FALSE optimizer cartesian join enabled
676. Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production 677. Version 18.14.0.0.0