[root@DBServer /]# su - oracle[oracle@DBServer ~]$ . oraenvORACLE_SID = [oracle] ? orcl[oracle@DBServer ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0...
Read More » Oraclehttps://blogs.oracle.com/middleware/entry/getting_history_from_sqlplus_using Remember previous history commands in SQLPlus on Linux with rlwrap 1. Login to you Linux machine as the root...
Read More » Linux,Oracle[root@Ecatest1 ~]# su - oracle[oracle@Ecatest1 ~]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=10 force=y[oracle@DBTest ~]$ . oraenvORACLE_SID = [oracle] ? orcl[oracle@DBTest ~]$ sqlplus...
Read More » Oraclehttp://raresql.com/2013/10/30/sql-server-fix-error-agent-xps-component-is-turned-off/ SQL SERVER – Fix – Error – Agent XPs component is turned off October 30, 2013 by Muhammad Imran Today...
Read More » MsSqlhttps://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 5 This article describes the installation of Oracle Database 11g...
Read More » OracleSQL> select log_mode from v$database; LOG_MODE------------ARCHIVELOG 1 row selected. or if you are in ARCHIVELOG mode, you will see rows...
Read More » OracleORA-19815: WARNING: db_recovery_file_dest_size of 4227858432 bytes is 100.00% used http://chandu208.blogspot.nl/2012/07/ora-19815-warning-dbrecoveryfiledestsiz.html Here because of this error my SQL views getting hung...
Read More » OracleCheck Poolmasterin XenCenter, the top-of-the-list server in a pool is always the master -- the rest below are alll slaves....
Read More » Linuxhttp://www.debianadmin.com/users-and-groups-administration-in-linux.html Add New User in Linux -d home directory-s starting program (shell)-p password-g (primary group assigned to the users)-G (Other...
Read More » LinuxType the following commands: ssh-keygen Press Enter key till you get the prompt ssh-copy-id -i ~/.ssh/id_rsa.pub root@ip_address (It will once...
Read More » Linux