Hot answers tagged

17

I found this to be the best solution and it works in a terminal or within a script: echo @scriptname | sqlplus username/password@connect


12

Here is how I did it. Had to hack it. a) Download Oracle 11.2 XE for Linux 64 in your $HOME b) Unzip the zip file you get c) Unpack the content of the rpm file without installing it (we don't need the Oracle RDBMS to be running on the server) mkdir ~/Oracle11XE-binaries cd ~/Oracle11XE-binaries # extract all the binaries from the RPM (rather ...


12

First prerequirements are a working apache2 and php7.2 (Ubunti 18.04) environement. Download the basic (like instantclient-basic-linux.x64-12.2.0.1.0.zip) and the sdk (instantclient-sdk-linux.x64-12.2.0.1.0.zip) package from the Oracle Website http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html Upload both ...


10

People pay research firms like Gartner gobs and gobs and gobs of money for this data. I do not expect you to get reliable information from individual vendor sites or from the opinions of folks here on ServerFault (as well-meaning as they may be). If you hold this information highly valuable, and want to rely on authenticity and currency, I suggest you hit up ...


9

Better than fighting with udev to force a device name for a given device, a permanent solution is to use UUIDs. This is valid for any device known to the device-mapper. This way, you don't have to worry if you add extra disks to your host. The UUID identifier guaranties that the right device will be used.


9

Oracle's pretty hostile, and wants more money from the Sun tech they spent so much on - security for end users (who can't afford $10k for basic updates) be damned. You're almost certainly looking at a large bill if you go the paid support route to get the JRE 6 updates - I'm not seeing anything you're missing that would be any cheaper. Ideas: What OS is ...


8

Are you sure that the original approach using the all_tables view includes LOB extents? I would think not. Here is one that I am finding useful: with da as ( SELECT owner, segment_name, SUM(bytes)/1024/1024 size_mb FROM dba_extents group by rollup(owner, segment_name) ) select owner, segment_name, size_mb, round(size_mb/total_mb*100) from da ...


8

I blame HP for convincing people to buy the ProLiant DL360e/DL380e series of servers. The storage controller is a big compromise on those servers. Here, you basically installed onto one of the two disks. The HP Dynamic Smart Array needs a binary driver to really function... See this Red Hat knowledge base article. You'll have to slipstream it into the ...


7

Assuming a Unix-like Operating System, running processes will not pick up the new secondary group. To pick up the new group membership a new login will be required. If you are starting / stopping Oracle as root via scripts, that is probably sufficient. If you are logged in as the Oracle user, then you will have to log out and back in again. In general, Unix-...


6

sudo and su have different configuration files. For sudo to work properly, the non-root user you are logging in should be either explicitly (I mean by user name) or implicitly (either in a UNIX group or in a defined set of users) permitted to run sudo su - If you don't know how this is configured, just follow the examples in the /etc/sudoers file For su, ...


6

In general—and not specific to DBAs—anyone who demands root access without giving a valid reason is either: Someone who doesn’t know what they are doing. Arrogant & uncooperative. Both of the above. Now, there might be real reasons they need root access to handle their task, but again if they cannot explain why & put it in writing, I would not deal ...


6

I've used this persons guide to installing both versions for .NET developers for a few years now, works like a charm. How to install 32 and 64 bit versions of Oracle Client -Stephen


6

Which is faster SSD or Memory DRAM is faster than NAND flash. A RAM access is on the order of 100 ns, while a SSD random read around 16,000 ns. Latency Numbers Every Programmer Should Know You need to do a systematic analysis of what is happening and why. Do not change things merely because you heard something secondhand about another system. Find what the ...


5

If Oracle Express is suitable for you: Download Oracle XE 11g rpm. Convert rpm to deb using alien. "Extract" the deb package using dpkg-deb command. Modify the deb scripts: Change [ "$1" != "1" ] to [ "$1" != "install" ] at the beginning of preinst. Change [ "$1" = "1" -o -z "$2" ] to [ "$1" = "configure" -a -z "$2" ] at the beginning of postint. Change [ "...


4

You do NOT need to fully install an Oracle instance. Download the Oracle Client as mentioned in George3's answer Install - when it asks you to select either Instant Client, Runtime, Administrator, or Custom <-- pick Custom. Select Database Utilities. This contains the exp/imp files


4

It appears as though you are asking whether you can have two instances of the same RAC (in an active-passive configuration) connected to different set of disks. The answer to this question is no. To quote from the Introduction to Oracle RAC linked to in the comments of your other question: An Oracle RAC database is a shared everything database. All data ...


4

No there should be no difference, but if you have transient ports set on your switch it may give you a new port number which may effect the network reconnection in an unexpected manner. The vswitches don't act like normal switches either, they are more aware of the VM configuration state, so may also be effecting what happens. You would run a wireshark on a ...


4

Oracle 8 is not supported on Windows 2003, the earliest version supported is Oracle 9i.


4

Theoretically DBAs can work without root privs, but it is PITA for both sides. It is practically impossible to define list of command to be accessible via sudo. Give DBAs root privs if: you do not want to be woken up in the middle of the night, just to reboot the server you want quick and smooth incident management if your sever is dedicated for DB server ...


4

Download and install the Microsoft Visual C++ 2010 Redistributable Package: http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632 The problem is not with the SQLORA dlls, but the modules that those ddls refer to (missing from a default Windows installation).


4

When the installer asks you how to partition the disks, choose a custom layout. The installer will show you your existing drives, partitions, volume groups, and logical volumes. Select /dev/VolGroup00/LogVol00 and choose edit. Tell it to format it and use it for /. Similarly choose to edit /dev/VolGroup00/LogVol02 and /dev/VolGroup00/LogVol02. Tell the ...


4

OK, I resized my TEMP tablespace and that appears to have sorted out my issue. Here's the command I ran: ALTER TABLESPACE TEMP SHRINK SPACE KEEP 512M; Seems to have fixed the issue (DB size went from 19GB to 2GB), but I'm still in the dark about why this would have occurred in such a small environment. Added some CloudWatch alarms so I can jump on this ...


4

That web site does not explain how to install Oracle Database. Rather it explains how to install Oracle Linux, a clone of Red Hat Enterprise Linux. These packages are obviously conflicting with each other. To resolve the problem, remove the Oracle Linux repository files that you had installed from that site, then run yum distro-sync to repair your RHEL ...


4

I had a look in the installation log under C:\Program Files (x86)\Oracle\Inventory\logs\installActions<CurrentDate_Time>.log It was stuck on the step: INFO: Checking whether the IP address of the localhost could be determined... After a lot of playing around with hosts files, etc. I ended up disabling EVERY network adapter visible in Windows 10. ...


4

Due to license changes by Oracle, the package maintainers have discontinued support for the Java installers. Their announcement (effective April 16, 2019) is here: https://launchpad.net/~webupd8team/+archive/ubuntu/java


3

I have done some comparisons using a 4800 MB .DMP file. Resulting in: deflate, normal compression: 799 MB bzip2, normal compression: 749 MB PPMd, normal compression: 654 MB Then I have done some tests on a smaller .DMP file, of 72 MB: deflate, normal compression: 21 MB bzip2, normal compression: 15,4 MB bzip2, ultra compression: 15,4 MB LZMA (aka 7zip)...


3

No, there is no difference. Unchecking 'Connected' is just breaking the virtual link between the card and vSwitch: Unchecked 'Connected' and clicked 'OK': Nov 8 09:11:28 mtasink8 kernel: eth1: NIC Link is Down Checked 'Connected' and clicked 'OK': Nov 8 09:11:40 mtasink8 kernel: eth1: NIC Link is Up 10000 Mbps


3

You need access to My Oracle Support (MOS). Please contact to Oracle or Oracle partners for support.


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