Oracle database is not startted when you restart windows server, then you can change regedit parameter for auto start. Each time you install Oracle products into a new Oracle home on your computer, HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME is created. This subkey contains parameter values for most Oracle products. HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME includes the following parameters for an Oracle home directory….
MsSQL Server Recovery Models Features
SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are…
MySQL Database Import And Export Operations
Take Backup With Data Open Command Prompt (cmd) # mysqldump -u dbusername -p db_name > /tmp/db_fullbackup.sql Take Only Metadata Backup # mysqldump -u dbusername -p –no-data db_name > /tmp/db_backupmetadata.sql or # mysqldump -u dbusername -p -d db_name > /tmp/db_backupmetadata.sql Restore Database Metadata From Backup # mysql -u dbusername -p db_name < /tmp/db_backupmetadata.sql Restore Database From...
How to Add or Delete Route in Oracle Linux
IP routing involves forwarding of IP datagrams. Its a simple process in which the host sends the IP datagram directly to the destination if the destination host is connected. For example, through a point to point link or through a shared network. If the destination host is not directly connected then the host sends the…
How to Increase Swap Space Size in Linux System
Swap space in Linux is used when the amount of physical memory (RAM) is full. If the system needs more memory resources and the RAM is full, inactive pages in memory are moved to the swap space. While swap space can help machines with a small amount of RAM, it should not be considered a…
MySQL Data File Size Decrease
If ibdata1 data file size is too big, you can decrease this file. My scenario is that my database have a table and size is 100 GB, I want to take backup and delete all data with decrease datafile size. If I use truncate command, this is not decrease ibdata1 size. I can use backup…
Oracle Flashback Database Technology in Oracle 11g
FLASHBACK DATABASE Technology to rewind the database to a target time, SCN or log sequence number. This command works by undoing changes made by Oracle Database to the datafiles that exist when you run the command. Flashback can fix logical failures, but not physical failures. Thus, you cannot use the command to recover from disk…
Useful SAP Basis System Administration Transactions
Administration AL11 Display SAP Directories BD54 Maintain Logical Systems OSS1 Logon to Online Service System SALE IMG Application Link Enabling SARA Archive Management SCC3 Copy Analysis Log SCC4 Client Administration SCC5 Client Delete SCC7 Client Import Post-Processing SCC8 Client Export SCC9 Remote client copy SCCL Local Client Copy SCU0 Customizing Cross-System Viewer SICK Installation Check…
Disable root SSH Login on Linux Server
Root user is the most authoritative user on linux operating systems. You can take measure for security with disable root ssh. You can connect to server with other users. Edit sshd_config vi /etc/ssh/sshd_config #LoginGraceTime 2m #PermitRootLogin yes #StrictModes yes Note : “PermitRootLogin yes” is default value. This value allows ssh root login You have to…
SAP Basis Introduction Documents
You can find SAP Basis introduction documents on here