Hot answers tagged

4

The database itself would probably not use the login shell for very much. The login shell does not restrict your use of bash for writing scripts. The #!-line in a script tells the shell what interpreter to use for running the script, and this can be bash or ksh or python or perl or whatever is appropriate for the particular script. The only thing that ...


3

Welcome to Debian; you no longer use cron. M. Kitt is right that Stack Exchange prefers one question per question, but in this case both questions stem from a fundamental mistake that you are making: You are erroneously assuming that you are running cron jobs. As you can see in the very cron job description that is in front of you, your cron jobs are ...


3

When you hit the Oracle JDK Download URL directly, you may see the html output contains <META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW"> and see In order to download products from Oracle Technology Network you must agree to the OTN license terms. and also see You attempt the download within 30 minutes of accepting the license. So, if you look into ...


3

As one of the primary authors of the Image Packaging System, I think I can answer this question. I've written about this topic before, so here's a quick summary: pkg(5), the image packaging system (IPS), is a software delivery system with interaction with a network repository as its primary design goal. Other key ideas are: safe execution for zones and ...


2

You can't download the complete source code for Java 1.4.2, Sun never published it (as far as I'm aware). On the Oracle page you link to, scroll down to version 1.4.2_19 and you'll find installation packages for 32-bit Intel CPUs, which you may be able to use on your Amazon server (if you can install the necessary 32-bit supporting libraries).


2

If your version of awk supports regular expressions as the field separator, you can do this: $ awk -F'[/.]' '{print $5}' oratab 11 9 alternatively, if you want the dbname printed too: $ awk -F'[:/.]' '{print $1,$6}' oratab dbname1 11 dbname2 9 I'm not sure if the Solaris or AIX versions of awk supports regexps as field separator. GNU awk does. So does ...


2

I'm sure there are better ways of handling this, but this pair of awk scripts will do the job. You can use either the enlarged version with comments or the one-liner below; they're functionally identical. awk ' BEGIN { RS="" } # Slurp paragraphs { print gensub("\n", " ", "g") } # Replace NL with SPACE ' /tmp/...


2

This question probably belongs on https://codereview.stackexchange.com/ instead of here, but here are my recommendations: use $() rather than backticks for command substitution. you (almost) never need to pipe grep in to awk. For example, instead of: ps -eaf | grep pmon | grep -v grep | awk '{print $8}' you can do: ps -eaf | awk '/pmon/ && ! /...


2

You may look for the pre-compiler starting from here: https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/appdev/proc/proc.htm Note that the pre-compiler needs the connection to an Oracle DB which contains the tables you use in the queries into the .pc file(s) that you have to pre-compile.


2

I would recommend making a personal unix account for regular use (Where you can use bash) and only use the oracle account when needed; this will help you from any surprises that might come from changing the account (or invalidating docs Oracle may send you on how to do things). It probably won't break the running process if you change the shell, it just may ...


2

Here's a quick and dirty howto to switch out java 8 from webupd8 ppa with Amazon's OpenJDK8-based Coretto: https://docs.aws.amazon.com/corretto/latest/corretto-8-ug/generic-linux-install.html


2

This seems to not be a single error message, but a combination resulting from an error happening several layers deep in your software stack and all the layers contributing parts to the error message as it finds its way out of the stack. The words "Schema" and "Password" together suggest that the script might be trying to connect to a database. The tail ...


1

You've asked if there is any way to connect to oracle without "cx_oracle" and without installing Instant client The documentation referenced from the error message clearly states ODPI-C requires Oracle Client libraries, which are found in Oracle Instant Client, or an Oracle Database installation, or in a full Oracle Client installation. If you haven'...


1

To have sqlplus print out the output of your script you can use: set serveroutput on From SQL*Plus® User's Guide and Reference: Controls whether to display output (that is, DBMS_OUTPUT.PUT_LINE) of stored procedures or PL/SQL blocks in SQL*Plus. To have the output appended to output.txt you may use the >> redirection operator: sqlplus -s $...


1

Looks like a MAC Address is part of the new host name after bridging. Could you have booted up with networking in DHCP since the bridge may be connecting to a DHCP server, where NAT did not? Run ifconfig and see if the 08-00-27-50-25-08 appears as the MAC address. Is the VM host connected to another network which could provide DHCP? What is the config for ...


1

You will need to use pkg set-publisher to change the solaris repo to use the free public repository (which does not get security fixes or bug fixes between releases, just updates every couple years when a new release comes out) at http://pkg.oracle.com/solaris/release/ and then use pkg update to update to the Solaris 11.4 release there. After you're running ...


1

To precisely answer the question: sure, you could change oracle's shell without affecting current processes. I'd suggest chsh instead of editing /etc/passwd, though. Consider cron (or otherwise-scheduled) jobs that expect to run as oracle in ksh. Consider also any jobs that are spawned from existing processes that expect to run ksh as their login shell. A ...


1

The best way to install Oracle’s Java 6 JDK is to proceed as follows: install java-package: apt-get install java-package download jdk-6u45-linux-i586.bin (not the RPM) from the Oracle achives; create the corresponding Debian package: make-jpkg jdk-6u45-linux-i586.bin install the resulting package: sudo dpkg -i oracle-java6-jdk_6u45_i386.deb This will ...


1

You will have to install the rpms: rpm -ivh jdk-6u45-linux-i586.rpm sun-javadb-core-10.6.2-1.1.i386.rpm sun-javadb-demo-10.6.2-1.1.i386.rpm sun-javadb-docs-10.6.2-1.1.i386.rpm sun-javadb-javadoc-10.6.2-1.1.i386.rpm sun-javadb-client-10.6.2-1.1.i386.rpm should be enough, if you do not intend to do development, I would leave the demos javadb-demo-10.6.2-1.1....


1

According to this ELinks manual, JavaScript is supported as long as you compile ELinks with SpiderMonkey. SpiderMonkey is Mozilla's JavaScript engine.


1

This issue is caused by non-export of bio_unmap_user kernel function in updated SUSE kernel. There is oracleasm update available to fix this issue on SLES12 SP3: oracleasm-kmp-default-2.0.8_k4.4.92_6.18-3.6.1.x86_64.rpm https://download.suse.com/Download?buildid=fAshWD23NFc~


1

Simple solution: install SLES 12.1. Version above that simply do not work with oracleasm


1

I’m on mobile so I cant provide sample output but $ free -m Will report cache You can as root run sync && echo 3 > /proc/sys/vm/drop_caches To drop the cache


1

INSERT INTO TABLE1 (a, b, c) SELECT a, b, NULL FROM TABLE2; This will insert the values from columns a and b in TABLE2 into the corresponding columns in TABLE1 while at the same time also inserting NULL values into TABLE1.c.


1

Actually it was the firewall itself which was blocking. Although I did added the rule in the INPUT Chain for TCP Port 80, but still due to the extensive default configuration of iptables in the CentOS 7, some rule of some other Chain was blocking the traffic from VM to Outside. I just tried by stopping the firewalld and it is now working.


1

It's likely that the installation has an /etc/profile.d file left behind, possibly named oracle-xe.sh or 20oos_oraclexe.sh. Find that file and remove it, e.g.: rm /etc/profile.d/oracle-xe.sh rm /etc/profile.d/20oos_oraclexe.sh If the file has a different name, find it with: egrep -l 'ORACLE_HOME|11.2.0/xe' /etc/profile.d/*.sh According to the Oracle® ...


1

Thomas, possible you must export the variable ORACLE_HOME, by; export ORACLE_HOME after declaration in script: rman.sh


1

You might start by reading that page: http://www.oracle.com/technetwork/articles/servers-storage-admin/o11-083-ips-basics-523756.html There is no connection between SYSV and IPS outside the fact Solaris is derived from the System V release 4.0 Unix branch but Solaris 11 deprecated the System V packaging commands (pkgadd, pkgrm, pkginfo, ...) to the new IPS ...


1

This solution works on a 64 bit machine. Download j2sdk-1_4_2_19-linux-i586.bin from Oracle. Run it: sudo sh j2sdk-1_4_2_19-linux-i586.bin You can move this folder to /opt/ or where you want it. After installing, you can check if it works: /opt/jre-1.4.2/bin/java -version Then you may get the following error message: -bash: /opt/jre-1.4.2/bin/java: /lib/...


Only top voted, non community-wiki answers of a minimum length are eligible