oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2014/04/faqs-block-device-error-when-trying-to.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. How to connect to a pluggable database in 12c using SQL*plus:. There are 2 methods to connect to a 12c Pluggable database,. I using alter session set container on the server. Ii creating a service and connecting thru tns. Oracle@rac1 ]$ echo $ORACLE SID. Oracle@rac1 ]$ echo $ORACLE HOME. U01/app/oracle/product/12.1.0/db 1. Oracle@rac1 ]$ sqlplus /nolog. SQL conn / as sysdba.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2012/01/oracle-faqs.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Recover a deleted rows from undo without flashback. Select * from testtable versions between timestamp to timestamp('22-feb-2012 03:25:35' ,'dd-mon-rrrr HH24:MI:SS') and to timestamp('22-feb-2012 03:28:35' ,'dd-mon-rrrr HH24:MI:SS'). This query will return the deleted rows of the test table in the mentioned time. This will work even without flashback on.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2012/02/index-rebuild.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Alter index index name tablespace tbs name rebuild online parallel 2;. The parallel parameter works only in Enterprise edition of oracle. Because parallelism doesnt comes free with Standard Edition. Same way the compression techniques used in oralce, for example compressed backup, compressed table(LOB), compressed expdp, compressed archive log files for standby.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2011/05/determine-cpu-cores-in-linux.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. DETERMINE CPU CORES IN LINUX. There are different types of cores, namely. Grep “core id” /proc/cpuinfo. Grep -i core /proc/cpuinfo. Example for finding physical cores, here each CPU holds 6 cores(HEXA). Root@server1 ]# cat /proc/cpuinfo egrep "processor physical id core id cpu cores". Physical id : 0. Core id : 0. Cpu cores : 6. Psrinfo -v :for Solaris. To find CPU Sockets.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/p/home.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Subscribe to: Posts (Atom). Follow me on oracleadm! OCR and Vote disk locations.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2011/04/oracle-archivelagtarget.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Oracle archive lag target. The archive lag target parameter is very useful for DataGuard setup, since this parameter will switch the logfile in the specified time interval. By default the parameter is 0 sec. The unit for this parameter is in seconds. Subscribe to: Post Comments (Atom). Follow me on oracleadm! Oracle archive lag target.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2011/08/oracle-11g-rac-implementation-steps-on.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Oracle 11g RAC - Implementation Steps on Linux. Http:/ www.oracle-base.com/articles/11g/OracleDB11gR1RACInstallationOnLinuxUsingNFS.php. Subscribe to: Post Comments (Atom). Follow me on oracleadm! Oracle 11g RAC - Implementation Steps on Linux.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2010/07/control-file.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Oracle Database Control file. Control files has the status of the physical structure of a database. A control file should be backup whenever a change is made to the database. The controlfile contains the following sections:. THREAD INSTANCE NAME MAPPING. To view control file status. SQL show parameter control files. To backup control file before any operation:.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2010/04/linux-commands.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. The shell program consists of the shell commands. There are different kind of shells likely bash shell, C shell, bourne shell etc. Each shells have variance in them. The commands structure vary between shells, but each shell is same among different linux platforms. The prompts look is depend on the shell you use, and the settings you have for that shell. In this instance ls.
oracleadm.blogspot.com
ORACLE DBA | ORACLE PLSQL | ORACLE GUIDE | ORACLE RMAN | ORACLEADM | ORACLE BOOKS
http://oracleadm.blogspot.com/2011/02/responsibilities-of-oracle-dba.html
ORACLEADM - The admin's lounge. This Oracleadm community is exclusively for oracle DBA freshers who thrive to attain a DBA career. Responsibilities of an ORACLE dba. Installing, upgrading, and patching Oracle Database software. Designing databases based on requirements. Testing backup and recovery strategy, and prepare a plan for failure cases. Making connectivity for clients to connect the database across network. Startup and shutdown the database. Managing tablespaces and datafiles.