Hello All,

I am in a situation to push database audit XML logs to syslog server. Audit logs are getting generated when Audit_Trail is set to OS. The same is not happening when Audit_Trail is set to XML,EXTENDED. Please advice on this.

SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production


SQL> show parameter audit
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/appldrch/DRCH_DB_audit_lo
                                                 g
audit_sys_operations                 boolean     TRUE
audit_syslog_level                   string      LOCAL1
audit_trail                          string      XML, EXTENDED

[root@appsdr ~]# cat /etc/syslog.conf
local1.warning /var/log/audit.log


Thank You.

regards,
John Marshal.A

I have xlc compiler version 8 and perl 5.10 running on AIX 7.1. I have been able to install DBI.pm module successfully, but now am in need to install DBD::ORACLE module. The oracle version is 12 (64bit)

perl Makefile.PL runs fine for the DBD::ORACLE module, however the "make" command is throwing below error:
I attempted to fix the issue by changing the object mode value, but that end up giving a different type of error.
Can you advise on the solution ?

#make
        rm -f blib/arch/auto/DBD/Oracle/Oracle.so
        LD_RUN_PATH="/u01/app/oracle/product/12.1.0/client_1/lib:/u01/app/oracle/product/12.1.0/client_1/rdbms/lib" ld  -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.10.1
            /aix-thread-multi/CORE/perl.exp -bE:Oracle.exp -bnoentry -lpthreads -lc -lm -L/usr/local/lib Oracle.o  dbdimp.o  oci8.o /lib/crt0_64.o -bI:/usr/lib/iocp.
            exp  -o blib/arch/auto/DBD/Oracle/Oracle.so     -L/u01/app/oracle/product/12.1.0/client_1/lib/ -lclntsh -lclntshcore -lld -lm -ldl -lc -lm -lpthreads -
            lodm
            -lbsd_r -lld -lperfstat -lm -lpthreads
ld: 0711-736 ERROR: Input file /lib/crt0_64.o:
        XCOFF64 object files are not allowed in 32-bit mode.
make: The error code from the last command is 8.

#bootinfo -K
64

#ORACCENV='cc=xlc_r'; export ORACCENV

#export OBJECT_MODE=64
#make
        rm -f blib/arch/auto/DBD/Oracle/Oracle.so
        LD_RUN_PATH="/u01/app/oracle/product/12.1.0/client_1/lib:/u01/app/oracle/product/12.1.0/client_1/rdbms/lib" ld  -bhalt:4 -G …

I want to send all my TSM events like backup failure, backup missed, scheduler stopped, and all other TSM warning and critical errors to be sent to HP monitoring solution. So that HP can get the TSM error or warning and raise ticket aromatically.

Please send me step by step procedure to configure n enable the same.

Since I m very new to Unix. Please send me easy/details to configure n enable TSM app alert.

Thanku very much
In advance

Good Morning!

What does the following two options actually do for DHCPd and does it work with failover?

allow booting;
allow bootp;


Im trying to configure DHCPd Failover and from what Im reading Im not quite sure if DHCP scopes that need PXE boot will work with DHCPd Failover. I believe the two options listed above would be needed but I dont know.  If so, should they be added in the primary and secondary dhcpd.conf files or the dhcpd.master?

Also the two options below -- are they also needed and should they be added in the primary and secondary dhcpd.conf files or the dhcpd.master too?

next-server x.x.x.x;
filename "xxx";

Thanks in advance!

Primary dhcpd.conf file

#authoritative;
ddns-update-style none;
ignore client-updates;
one-lease-per-client true;
omapi-port 7911;

#Failover peer section
failover peer "dhcp-partner" {
  primary;
  address server1.paychex.com;
  port 647;
  peer address server2.paychex.com;
  peer port 647;
  max-response-delay 60;
  max-unacked-updates 10;
  mclt 3600;
  split 153;
  load balance max seconds 3;
}
include "/etc/dhcp/dhcpd.master";

Select all Open in new window

Secondary dhcpd.conf file

#authoritative;
ddns-update-style none;
ignore client-updates;
one-lease-per-client true;
omapi-port 7911;

#Failover peer section
failover peer "dhcp-partner" {
  secondary;
  address server2.paychex.com;
  port 647;
  peer address server1.paychex.com;
  peer port 647;
  max-response-delay 60;
  max-unacked-updates 10;
  load balance max seconds 3;
}
include "/etc/dhcp/dhcpd.master";

Select all Open in new window

dhcpd.master file

option domain-name "example.com";
allow booting;
allow bootp;
next-server x.x.x.x;
filename "xxx";
option option-242 code 242 = string;

#dhcpd wants to listen on its own networks
subnet 17.8.4.0 netmask 255.255.252.0 {
  ignore unknown-clients;
}

#dhcpd wants to listen on its own network
subnet 19.4.8.0 netmask 255.255.252.0 {
  ignore unknown-clients;
}

#Scope [12.4.4.0] TEST PXE Boot
subnet 12.4.4.0 netmask 255.255.252.0 {
  option subnet-mask 255.255.252.0;
  option routers 12.4.4.1;
  option domain-name-servers 12.2.2.198;
  pool {
    failover peer "dhcp-partner";
    default-lease-time 300;
    max-lease-time 360;
    range 12.4.5.0 12.4.5.255;
  }
}

Select all Open in new window

in Unix

what is the meaning of below command



zgrep 'RPT|O|GetProducts' xyz.gz meaning
why we need RPT|o|
in the beginning what is the meaining of pipe here?
please advise

when it displays "Global Group memberships", it it is long, then it is only partially seen. is there a way you break it down to many single line step output?

Dear All,

I wanted to create a User in AIX system but having only access rights only to specific folder.
As a first step i have created a group FTP and a User i wanted to use in ftp.
Also i have created an ftp access file in /etc in order to give access to user.
When i log in from web browser with the specific user i cannot see the folder user was configured for.
When i change folder to  /  it gives me access to all folders.

Because i tried to find some manuals and tips but in web all information is not concentrated in a manual.
Can someone help me with all steps needed in order to make user work....???

Best Regards.

Having a bit of a discussion with a software vendor about this. Can anyone confirm my understanding?

/etc/sudoers file example:-

user1 server1 = NOPASSWD:/usr/bin/ls -l
user1 server1 = NOPASSWD:/usr/bin/file

Select all Open in new window

But then the following command fails (logged in on server 1 as user1) because its not in sudoers file.

sudo java abc.jar

Select all Open in new window

Surely this is correct? You can't sudo a command unless you have appropriate permissions in /etc/sudoers? Am I right?

I'm trying to chroot jail SFTP service on AIX 7.2 system. What I mean is to allow users from 'sftpgrp' group to ONLY SFTP access. Authentication is through SSH KEys (no passwd). Also, no SSH login is allowed for users inside 'sftpgrp' group.

Until now SFTP chrooted is working properly, I mean, users in sftpgrp group access their chrooted HOME DIRECTORY without problem.

But, the problem is  the problem is when theses users try to SSH (using Pub KEy) the same server, I this error:

/dev/pts/5: No such file or directory
open /dev/tty failed - could not set controlling tty: No such device

See part of debuged log from SSHD:

.
.
debug3: aix_restoreauthdb: restoring old registry ''
debug1: audit session open euid 0 user iga3 tty name /dev/pts/5
debug3: mm_request_send entering: type 26
debug3: mm_answer_pty: tty /dev/pts/5 ptyfd 6
debug1: session_pty_req: session 0 alloc /dev/pts/5
debug1: Ignoring unsupported tty mode opcode 42 (0x2a)
debug1: server_input_channel_req: channel 0 request shell reply 1
debug1: session_by_channel: session 0 channel 0
debug1: session_input_channel_req: session 0 req shell
debug1: Forced command (config) 'internal-sftp -l INFO'
debug1: Values: options.num_allow_users: 0
debug1: RLOGIN VALUE  :0

debug3: mm_audit_run_command entering command internal-sftp -l INFO
debug3: mm_request_send entering: type 57
/dev/pts/5: No such file or directory
open /dev/tty failed - could not set controlling tty: No such device
debug3: 

Select all Open in new window

…

Hi,

what are the best practices and features, options while using grep.

i am using these days to search in log files, files, directories, content etc

When should i give single quote '  '
like
zgrep 'xyz' aaa.gz


When should i give double quote " "
like
zgrep "xyz" aaa.gz


how to use tail and head etc along with grep to effectively monitor last or first 100 lines etc
please advise

Hi,

https://bash.cyberciti.biz/guide/Hello,_World!_Tutorial

I created hello.sh script using vi hello.sh
then typed below

echo "Hello, World!"
echo "Knowledge is power."

do i need to tyope below line as well at top?

#!/bin/bash
what above line means?

when i try to execute gets errror as

$ ./hello.sh
-bash: ./hello.sh: Permission denied



please advise