Renaming the instance DB in Oracle
Renaming the instance DB – simple procedure. Here are the steps for Windows. For other OS need to make amendments to the specific features, such as: names of environment...
How To Update A Database Instance
Steps for Windows on the example of upgrading from to For other OS need to make amendments to the specific features, such as: names of environment variables,...
Oracle RDBMS Communication under linux with MS SQL Server through ODBC
OS – Oracle Linux Server ; DB – Oracle 11gR2 (). Put ODBC: yum install -y unixODBC unixODBC-devel Downloading source ” FreeTDS” the links that can be found here: . For example: cd / tmp / wget ...
Connecting Oracle XML DB to the Windows disk-like WebDAV-resource
There was a need to ensure the Oracle database interaction with the system that can not work with Oracle, but is able to put the files on the FTP...
Changing Swap “on the fly”
Change the swap without rebooting the operating system is not easy, but very easy! Increase: Enjoying the current volume of swap (so as to increase the self-education): grep SwapTotal...
Very Useful Linux Commands
Command Description system information arch display computer architecture uname -m uname -r show used kernel version dmidecode -q show hardware system components – (SMBIOS / DMI) hdparm -i / dev / hda HDD output characteristics hdparm -tT / dev...
How to Disconnect a User Session in Oracle
Disable user (terminate session), you can do (in sqlplus): find the desired user on the “osuser” and “machine” in this query: select SID, SERIAL #, osuser, machine from v...
How To Creat a Link To a Remote Database
Oracle allows you to connect different databases with each other. This is possible even if the database is located on different servers. Do not forget that access to the...
Accessing local users to the local X-Server
In ubuntu (and perhaps in all debian), by default, to a running X-server can have access only to the user running the server instance. In this connection problems arise. For example, when you install Oracle, which has a graphical...
Creating a Oracle database manually in * nix
It is considered that you have already made the Oracle DB installation. These instructions are tested on Oracle DB for Linux under CentOS and Kubuntu Go under...