We are trying to install oracle 11g R2 64 bit in Rhel 5.5 machine ( 64 bit ). Kernel version is 2.6.18-194.el5. We are getting the below error while installation. error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/home/oracle/app/product/11.2.0/network/lib/ins_net_client.mk'. See '/home/oracle/oraInventory/logs/installAction2013-09-03_04-52-05PM.log' for details. We have installed all necessary library packages. binutils-2.17.50.0.6-14.el5.x86_64 compat-libstdc++-33-3.2.3-61.x86_64 compat-libstdc++-33-3.2.3-61.i386 elfutils-libelf-0.137-3.el5.x86_64 elfutils-libelf-0.137-3.el5.i386 elfutils-libelf-devel-static-0.137-3.el5.x86_64 elfutils-libelf-devel-static-0.137-3.el5.i386 elfutils-libelf-devel-0.137-3.el5.x86_64 elfutils-libelf-devel-0.137-3.el5.i386 gcc-4.1.2-48.el5.x86_64 gcc-c++-4.1.2-48.el5.x86_64 glibc-2.5-49.x86_64 glibc-2.5-49.i686 glibc-common-2.5-49.x86_64 glibc-devel-2.5-49.x86_64 glibc-devel-2.5-49.i386 glibc-headers-2.5-49.x86_64 ksh-20100202-1.el5.x86_64 libaio-0.3.106-5.x86_64 libaio-0.3.106-5.i386 libaio-devel-0.3.106-5.x86_64 libaio-devel-0.3.106-5.i386 libgcc-4.1.2-48.el5.x86_64 libgcc-4.1.2-48.el5.i386 libstdc++-4.1.2-48.el5.x86_64 libstdc++-4.1.2-48.el5.i386 libstdc++44-devel-4.4.0-6.el5.x86_64 libstdc++44-devel-4.4.0-6.el5.i386 libstdc++-devel-4.1.2-48.el5.x86_64 libstdc++-devel-4.1.2-48.el5.i386 make is already installed: make-3.81-3.el5.x86_64 Contents of log file: INFO: Calling Query fileQueries10.1.0.3.0 exists filename = /home/oracle/app/product/11.2.0/rdbms/lib/libknlopt.a INFO: Query Returned: false INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/network/lib/ins_nau.mk installTarget = ioklist installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = null undoArguments = null logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking Adapters INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/network/lib/ins_nau.mk installTarget = iokinit installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = null undoArguments = null logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking Adapters INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/network/lib/ins_nau.mk installTarget = iokdstry installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = null undoArguments = null logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking Adapters INFO: Linking 'Oracle Database Utilities 11.2.0.3.0 ' INFO: Linking 'Oracle Database Utilities 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component Oracle Database Utilities INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/rdbms/lib/ins_rdbms.mk installTarget = utilities installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = null undoArguments = null logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking Utilities Executables INFO: Linking 'SQL*Plus 11.2.0.3.0 ' INFO: Linking 'SQL*Plus 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component SQL*Plus INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/sqlplus/lib/ins_sqlplus.mk installTarget = install installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = null undoArguments = null logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking SQLPLUS Executables INFO: Linking 'Oracle Programmer 11.2.0.3.0 ' INFO: Linking 'Oracle Programmer 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component Oracle Programmer INFO: Linking 'Oracle Internet Directory Client 11.2.0.3.0 ' INFO: Linking 'Oracle Internet Directory Client 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component Oracle Internet Directory Client INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/ldap/lib/ins_ldap.mk installTarget = clientonlyinstall installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = null undoTarget = clientonlyinstall undoArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking OID Client INFO: Calling Action unixActions10.2.0.3.0 registerForMake installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/ldap/lib/ins_ldap.mk installTarget = clientonlyinstall installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 undoMakeFileName = /home/oracle/app/product/11.2.0/ldap/lib/ins_ldap.mk undoTarget = clientonlyinstall undoArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 logFile = /home/oracle/app/product/11.2.0/install/make.log progMsg = Linking Client-only Install INFO: Linking 'SQLJ Runtime 11.2.0.3.0 ' INFO: Linking 'SQLJ Runtime 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component SQLJ Runtime INFO: Linking 'Oracle SQLJ 11.2.0.3.0 ' INFO: Linking 'Oracle SQLJ 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component Oracle SQLJ INFO: Linking 'Oracle Client 11.2.0.3.0 ' INFO: Linking 'Oracle Client 11.2.0.3.0 ' INFO: 9/3/13 4:54:07 PM IST: Starting install Link Phase of component Oracle Client INFO: Linking in progress INFO: Linking in progress INFO: Link Phase JRE files in Scratch :0 INFO: Calling Action unixActions10.2.0.3.0 make registerOnly = false installMakePath = /usr/bin/make installMakeFileName = /home/oracle/app/product/11.2.0/network/lib/ins_net_client.mk installTarget = mkldflags ntcontab.o nnfgt.o undoMakeFileName = installArguments = ORACLE_HOME=/home/oracle/app/product/11.2.0 logFile = /home/oracle/app/product/11.2.0/install/make.log undoTarget = progMsg = Linking ldflags Executables INFO: Linking ldflags Executables INFO: Linking ldflags Executables INFO: The output of this make operation is also available at: '/home/oracle/app/product/11.2.0/install/make.log' INFO: INFO: Start output from spawned process: INFO: ---------------------------------- INFO: INFO: rm -f ntcontab.* INFO: (if [ "compile" = "compile" ] ; then \ /home/oracle/app/product/11.2.0/bin/gennttab > ntcontab.c ;\ /usr/bin/gcc -m32 -m32 -fPIC -c ntcontab.c ;\ rm -f /home/oracle/app/product/11.2.0/lib/ntcontab.o ;\ mv ntcontab.o /home/oracle/app/product/11.2.0/lib/ ;\ /usr/bin/ar rv /home/oracle/app/product/11.2.0/lib/libn11.a /home/oracle/app/product/11.2.0/lib/ntcontab.o ; fi) INFO: /bin/sh: line 2: /usr/bin/gcc: No such file or directory INFO: mv: cannot stat `ntcontab.o' INFO: : No such file or directory INFO: /usr/bin/ar: /home/oracle/app/product/11.2.0/lib/ntcontab.o: No such file or directory INFO: make: *** [ntcontab.o] Error 1 INFO: End output from spawned process. INFO: ---------------------------------- INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/home/oracle/app/product/11.2.0/network/lib/ins_net_client.mk'. See '/home/oracle/oraInventory/logs/installActions2013-09-03_04-52-05PM.log' for details. Exception Severity: 1 INFO: Adding ExitStatus STOP_INSTALL to the exit status set INFO: Finding the most appropriate exit status for the current application INFO: Exit Status is -4 INFO: Shutdown Oracle Client Installer What is the solution for this error?

I am trying to prepare the server running Oracle Linux 8.8 for Oracle database 19c installation. I installed oracle-database-preinstall-19c.rpm and noticed that ulimit -l value is showing unexpected to me value of 64. It's my first time configuring a server, so I need some help in understanding ulimit -l value. I expect it to be the value set in the /etc/limits.conf for (all) users and value from /etc/limits.d/oracle-database-preinstall-19c.conf for oracle user, but I see ‘64’ using both xrdp connection and local log in for all users. However, when I open a console and switch user using su and run ulimit -l I get the expected value that was set in .conf files. /etc/security/limits.d/oracle-database-preinstall-19c.conf file contains the following lines for setting memlock value: oracle soft memlock 134217728 oracle hard memlock 134217728 /etc/security/limits.conf file contains the following lines for setting memlock value: * soft memlock 134217728 * hard memlock 134217728 No other /etc/security/.conf files sets memlock value. The server has 96GB of memory and x86_86 architecture. sudo grep pam_limits /etc/pam.d/ shows: /etc/pam.d/fingerprint-auth: session required pam_limits.so /etc/pam.d/password-auth: session required pam_limits.so /etc/pam.d/runuser: session required pam_limits.so /etc/pam.d/system-auth: session required pam_limits.so grep Huge /proc/meminfo shows: AnonHugePages: 0 kB ShmemHugePages: 0kB FileHugePages: 0kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugeagesize: 2048 kB Hugetlb: 0 kB Transparent HugePages are set to ‘never’. I haven't found any memlock values in systemctl show user-$(id -u oracle).slice I also have set vm.hugetlb_shm_group value in /etc/sysctl.d/99-hugetlb-shm-group.conf in case that matters. I haven't installed Oracle database yet. So can anyone help me? Why is ulimit -l value set to 64? Is it okay? I can provide more environment settings and values if needed.

I have a RHEL 7.2 server with Oracle 11g Express Edition (11.2.0) installed. The installation of Oracle created a file named "oracle-xe" in /etc/init.d This is a bash script that can be used to start and stop the listener and database manually. When I'm logged on to the server, I can run the following: dzdo /etc/init.d/oracle-xe start and the Oracle listener + database are started without issue. I can log on using sqlplus and execute commands. I'm trying to use chkconfig to make it so that oracle-xe is executed automatically on system start, so that I do not have to manually start the listener and database every time the server is rebooted. The oracle-xe script itself is lengthy, but the meat of it contains the following: #!/bin/bash # chkconfig: 2345 80 05 # Source fuction library if [ -f /lib/lsb/init-functions ] then . /lib/lsb/init-functions elif [ -f /etc/init.d/functions ] then . /etc/init.d/functions fi SU=/bin/su ORACLE_OWNER=oracle $ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe LSNR=$ORACLE_HOME/bin/lsnrctl SQLPLUS=$ORACLE_HOME/bin/sqlplus $STARTUP_LOG=/home/tsm/log/oracle-xe.log echo $(date) >> $STARTUP_LOG $SU -s /bin/bash $ORACLE_OWNER -c "$LSNR start" >> $STARTUP_LOG 2>&1 $SU -s /bin/bash $ORACLE_OWNER -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" >> $STARTUP_LOG 2>&1 I added the $STARTUP_LOG code and the >> redirect of output so that I could sort out what was happening. I added the script to chckconfig with the following: cd /etc/init.d dzdo chmod 750 oracle-xe dzdo chkconfig --add oracle-xe dzdo chkconfig oracle-xe on The following command yields the given (shortened) output: dzdo chkconfig --list oracle-xe 0:off 1:off 2:on 3:on 4:on 5:on 6:off I reboot the server, and it generates a log file at /home/tsm/log/oracle-xe.log with the following output: Fri Jan 13 15:03:58 CST 2017 su: cannot open session: Permission denied su: cannot open session: Permission denied and as you might guess, as a result of this su failure, neither the listener nor the database engine have started. Since I see the reboot date/time in the log file, I know for sure that the script is being executed upon boot. It seems to me to be a permissions issue, that whatever account is being used to execute init scripts at startup for some reason cannot su as $ORACLE_OWNER, yet me as a lowly admin can do this just fine from the command prompt. It was my understanding that the init code is executed as root, and therefore this su command should run without a problem. I've been searching and trying various things for the better part of a day trying to sort this out, and have pulled out what little remains of my hair. The server itself is using DirectAuthorize to grant access permissions, which is why I end up using dzdo instead of sudo. Could this have something to do with it?

I just wanted to know is there any way to pass the arguments in perl script (adcfgclone.pl) during compilation time (i.e., the values should not be asked during script run time) Below is an example that i am passing the values after running the script. Provide the values required for creation of the new APPL_TOP Context file. Target System Hostname (virtual or normal) [proddb] : Target Instance is RAC (y/n) [n] : n Target System Database SID : proddb1 Target System Base Directory : /d06/oravis Target System utl_file_dir Directory List : /usr/tmp Number of DATA_TOP's on the Target System : 1 Target System DATA_TOP Directory 1 [/d01/oravsn12/db/apps_st/data] : /d06/oravis/db/apps_st/data Target System RDBMS ORACLE_HOME Directory [/d06/oravis/db/tech_st/10.2.0] : /d06/oravis/db/tech_st/10.2.0 Do you want to preserve the Display [null] (y/n) ? : n Target System Display [sharkap:0.0] : Target System Port Pool [0-99] : 34 Note: I am entering all the above values during the script run time, so i just pass those all arguments in one file and just run the adcfgclone.pl script.

I'm tryin to install oracle 19c on oracle linux 7.6, I'm required to install oracle 19c preinstall , knowing that this is a fresh install I don't understand why i'm getting these errors : yum -y localinstall http://yum1.stanford.edu/mrepo/ol8-x86 64/RPMS.appstream/oracle-database-preinstall-19c-1.0-2.el8.x86 64.rpm Loaded plugins: langpacks, ulninfo Repository ol7_latest is listed more than once in the configuration Repository ol7_u0_base is listed more than once in the configuration Repository ol7_u1_base is listed more than once in the configuration Repository ol7_u2_base is listed more than once in the configuration Repository ol7_u3_base is listed more than once in the configuration Repository ol7_u4_base is listed more than once in the configuration Repository ol7_u5_base is listed more than once in the configuration Repository ol7_u6_base is listed more than once in the configuration Repository ol7_security_validation is listed more than once in the configuration Repository ol7_optional_latest is listed more than once in the configuration Repository ol7_addons is listed more than once in the configuration Repository ol7_MODRHCK is listed more than once in the configuration Repository ol7_latest_archive is listed more than once in the configuration Repository ol7_optional_archive is listed more than once in the configuration Repository ol7_UEKR5 is listed more than once in the configuration Repository ol7_UEKR4 is listed more than once in the configuration Repository ol7_UEKR3 is listed more than once in the configuration Repository ol7_UEKR3_OFED20 is listed more than once in the configuration Repository ol7_UEKR5_RDMA is listed more than once in the configuration Repository ol7_UEKR4_OFED is listed more than once in the configuration Repository ol7_UEKR4_archive is listed more than once in the configuration Repository ol7_UEKR5_archive is listed more than once in the configuration Repository ol7_kvm_utils is listed more than once in the configuration Skipping: http://yum1.stanford.edu/mrepo/ol8-x86 , filename does not end in .rpm. Skipping: 64/RPMS.appstream/oracle-database-preinstall-19c-1.0-2.el8.x86, filename does not end in .rpm. Cannot open: 64.rpm. Skipping. Nothing to do

I am completely new to the Linux world. I am following a course on Udemy and trying to install the Oracle database on Oracle Linux 9.1. One of the prerequisites is to run the following command: dnf install oracle-database-preinstall-18c But I am getting the error > No match for argument: oracle-database-preinstall-21c > > Error: Unable to find a match: oracle-database-preinstall-21c

I am following a tutorial to install Oracle 19c on Oracle Linux 9 . If I run the installer (runInstaller) as a non-root user, I get a permissions denied error. But if I run it with sudo, I get Oracle's 'cannot run it as root'. I don't know what to do now. Here is the error for reference: I have tried installing the 19c database on Ubuntu. And although, I got the installer running, it just didn't work very well. So, I tried it on Oracle Linux 9. But I keep getting the above error.

Both users foobar and foobiz are in same group on RHEL.

-shellsession
foobar$ python3 -m pip list

Package           Version
----------------- -------
oracledb          1.4.2
pip               21.3.1

foobiz$ python3 -m pip list
 
Package           Version
----------------- -------
pip               21.3.1

foobar$ head -3 my_python.py
from datetime import datetime
import time
import oracledb

The code executes for foobar, but foobiz gets the following message:

import oracledb
ModuleNotFoundError: No module named 'oracledb'

Questions: * Does foobiz need its own oracledb module? * How can I get foobiz to run run my_python.py with out installing oracledb for foobiz?

I'm trying to upload .dat file to Oracle DB using SQLLDR.  File data columns are separated by "^A".  File charset is of binary. bash-4.4$ file -i /tmp/t_details_all_data_20240209.dat /tmp/t_details_all_data_20240209.dat: application/octet-stream; charset=binary Here is my CTL file LOAD DATA APPEND INTO TABLE DETAILS_TEMP FIELDS TERMINATED BY '^A' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( IS_ID "decode(trim(:ISSUE_ID),null,0,to_number(trim(:IS_ID)))", IS_NAME CHAR(1500) "trim(:IS_NAME)", IS_STATUS "trim(:IS_STATUS)", is_no_days_draft_status FILLER,.... But when I run the script, data is not loading and the first column is read as the complete row, not recognizing the field separator.  And/or the error in SQLLDR is "Record 1: Rejected - Error on table DETAILS_TEMP, column IS_ID. Field in data file exceeds maximum length". When I open this file in Notepad++, the field separator is showing as "SOH".  When I do cat /tmp/t_details_all_data_20240209.dat, it is not showing anything as field separator. I tried converting the file to UTF-8/ASCII by using "strings":

strings /tmp/t_details_all_data_20240209.dat > /tmp/t_details_all_data_20240209_tmp.txt

but all columns are as new rows in the file it generated. Converted file: cat /tmp/t_details_all_data_20240209_tmp.txt: IS ID IS Name IS Status... The command

od -tc < /tmp/t_details_all_data_20240209.dat

reports

i   s   _   i   d 001   i   s   _   n  a   m   e 001   i   s
_   s   t   a   t   u   s 001

confirming that the field separator is the character whose byte value is 001. I could not upload the file I used to load data due to security constraints.  But I can provide more details.

I am installing Oracle 11gR2 on CentOS 7. I have the packages installed, I have the kernel parameter set but still its not working. Here are the images. [Installation Image[![\]\[1\]]]

With the following shell script, why I am getting errors syntax error near unexpected token `else' Shell Script echo "please enter username" read user_name echo "please enter password" read -s pass echo ${ORACLE_SID} SID=${ORACLE_SID} if ["${ORACLE_SID}" != 'Test'] then sqlplus -s -l $USER_NAME/$PASS@$SID <