Posts

Showing posts from 2015

Enable / Disable Archive Log Mode In Oracle

Let us we discuss about today  session how to enable / disable archive log mode in oracle 11g check these below link http://ampersandacademy.com/tutorials/enable-disable-archive-log-mode-oracle-11g/

Renaming or Relocate the Redo log file Members

Let us we discuss about how to relocate and renaming the redo log members in oracle 11g check the below link http://ampersandacademy.com/tutorials/renaming-relocate-redo-log-file-members-oracle-11g/

Managing Redolog in oracle11g

Let us discuss in these session about redo file , group members how to add the group log file in database ? how to add the log member in database ? refer the link below http://ampersandacademy.com/tutorials/archive-log-redolog-oracle-11g/

Dynamic Paramaters In oracle

Today we discuss about dynamic parameters in oracle 11g  here i m explained static and dynamic parameters of oracle how we can those parameter in oracle for more details refer these link http://ampersandacademy.com/tutorials/dynamic-paramaters-oracle-11g/

Maintaing or Managing Control File

Let us see in these tutorial what are the information holds the information holds the control file ? how can we Maintaing or Managing Control Files in oracle see this link http://ampersandacademy.com/tutorials/maintaing-managing-control-file-oracle-11g

Shut Down Commands

Today we discuss about show down commands in oracle  dba check this link http://ampersandacademy.com/tutorials/shut-commands-oracle-11g/

ORA-00845: MEMORY_TARGET not supported on this system

Today  We can discuss about the major oracle error , when  we start the oracle database by issuing "Startup " commands  its throw error ORA-00845: MEMORY_TARGET not supported on this system  from the leaning stage its big hectic of us ,Here i Mentioned  two methods to solve this error Method 1:          SQL> startup   ORA-00845: MEMORY_TARGET not supported on this system SQL> create pfile from spfile; file has been created  we need the pfile to solve these error ,so let's create the pfile (The default file has been created on "$ORACLE_HOME/dbs/"  location initdbname.ora) SQL> shut immediate because we ll up database by using  pfile so we must  shut database  SQL>! oracle@host.] cd $ORACLE_HOME/dbs oracle@host dbs]ls  spfileram.ora initram.ora now i m going to edit this pfile    oracle@host dbs>vi initram.ora now the parameters of pfile will be dispal...

Basic Linux Commands

Let us see the basic commands for linux operating system where we used on oracle 11g http://ampersandacademy.com/tutorials/basic-linux-commands-oracle-dba-2/

Managing an oracle instance

Let check these link for Managing an oracle Instances  http://ampersandacademy.com/tutorials/managing-oracle-instance-oracle11g/            

Optimal Flexible Architecture in 11g

Hi Friends ,            Let us discuss about  to Optimal Flexiable Architecture  in oracle database check it out http://ampersandacademy.com/tutorials/optimal-flexiable-architecture-oracle-dba-11g/

Getting Started with Oracle Server - DBA TOOLS

today  we discuss about most important DBA TOOLS in oracle http://ampersandacademy.com/tutorials/getting-started-oracle-server-dba-tools/

Oracle Database Architecture

Here i m explained the basic architecture of oracle database  in 11g check it out https://ampersandacademy.com/tutorials/oracle-admin-1/oracle-database11g-architecture