How to check the already set parameters in Linux/Oracle. For example, as soon as I login to Linux if I type cd $AU_TOP, it directly goes to the path set in AU_TOP. Now I want to see like AU_TOP what are the other parameters is there. Answer If typing cd $AU_TOP take you to some directory – Means you hav…
Tag: oracle
Java1.5 ExitOnOutOfMemory?
I am having a problem making my java instance recognize command line CrashOnOutOfMemoryError or ExitOnOutOfMemoryError any ideas to get the supported command line that will do the required feature Regards, Answer Unless you’re using Java 1.8 (specifically, 1.8u92 or newer), these command-line options ar…
Accessing Oracle Wallet using Oracle sqlplus Instant client
I’ve configured Oracle wallet successfully in my Linux server(Linux 2.6.32-642.4.2.el6.x86_64 GNU/Linux). When I try to execute the below command using Database connection string, it works perfect. $/sqlplus /@TESTDB SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 18 07:12:49 2016 Copyright (c) 1982,…
Generating Total Time in Milliseconds in SQL Developer
I need to replicate the linux command “date +%s%3N” in SQL Developer. I have tried the below code sample but it returns with a different value. I have also done extensive searching Google with no luck. The date +%s%3N command returns something like: 1475615656692870653 Whereas the above code sampl…
ssh -X oracle is not working properly
I run the following command to switch to oracle user on linux. This is suppose to set environmental variable DISPLAY. I ran xclock command but it throws the following error How should i set environmental variable DISPLAY correctly to run GUI application? Answer You may have logged in as Oracle with -l option,…
How to find the version for the Oracle Forms Compiler in Linux
I’m trying to find the version of the Oracle Forms Builder and/or Forms Compiler in a linux installation. I know it’s an Oracle Forms 11g install, but I need the specific version. In the Windows Desktop version of Forms Builder, this can be achieved by accessing the “Help” -> “…
Executing multiple commands under as another username within a file in BASH shell
I am attempting to execute a sqlplus command within a file. The file should be able to sudo switch into the oracle user and run the commands needed. The oracle user will need to first source a file with the parameters for the database, then be able to call a sql file from sqlplus. The script I have is Whether
cx_Oracle does not recognize location of Oracle software installation for installation on Linux
I have been able to successfully install cx_Oracle for use with Python 3.4 on my Windows 8 laptop, and I am now trying to get the same setup (cx_Oracle with Python 3.4) onto a Linux machine. When running the setup.py file from cx_Oracle-5.1.3.tar.gz, I end up with this error: Following some other answers I lo…
Connect to sqlplus with another linux user than oracle
I installed Oracle with sqlplus with user oracle (linux – CentOS). If I try to connect to database being oracle everything goes as expected (sqlplus / as sysdba for example), but I need to do the same thing (maybe not as sysdba, but as a user from database) being another linux user. I added this second …
Multiple Oracle versions using Perl
Have one system monitoring two Oracle Databases with different versions 12.1 and 10.1 Oracle client, sdk, sqlplus installed for each and I can query either 12.1 db or 10.1 by setting theses after setting appropriate values for But Perl does not seem to pick up the the different versions. I get: CRITICAL ̵…