Revision [4112]
Last edited on 2011-09-01 03:12:48 by KenFongAdditions:
[[OracleInstance Instance]]
Revision [3996]
Edited on 2011-05-25 22:46:02 by KenFongAdditions:
[[OracleAWR OracleAWR]]
-----
-----
Revision [3979]
Edited on 2011-05-21 03:39:17 by KenFongAdditions:
[[OracleRAC OracleRAC]]
Revision [3754]
Edited on 2010-07-15 21:07:47 by KenFongAdditions:
== crs_stat deprecated ==
Use these.
[grid@rac01 ~]$ $GRID_HOME/bin/crsctl stat res -t
[grid@rac01 ~]$ srvctl status database -d pocdb
Use these.
[grid@rac01 ~]$ $GRID_HOME/bin/crsctl stat res -t
[grid@rac01 ~]$ srvctl status database -d pocdb
Revision [3712]
Edited on 2010-05-13 20:45:21 by KenFongAdditions:
[[OracleSQLPlus OracleSQLPlus]]
Revision [3691]
Edited on 2010-04-23 20:12:26 by KenFongAdditions:
OCP finally.
{{image url="images/OCP_ODb10gAdmin_clr.gif"}}
{{image url="images/OCP_ODb10gAdmin_clr.gif"}}
Deletions:
{{image url="images/OCA_ODb10gAdmin_clr.gif"}}
Revision [3684]
Edited on 2010-04-18 16:36:48 by KenFongAdditions:
===Exam stuff===
[[OracleMyExamNotes My Exam Notes]]
[[OracleMyExamNotes My Exam Notes]]
Revision [3674]
Edited on 2010-03-24 01:38:05 by KenFongAdditions:
[[OracleSQL OracleSQL]]
Revision [3633]
Edited on 2010-02-03 07:40:42 by WikiAdminAdditions:
[[OracleSQLTuning SQLTuning]]
Revision [3629]
Edited on 2010-02-01 06:55:13 by WikiAdminAdditions:
[[OracleFlashback Flashback]]
Revision [3626]
Edited on 2010-02-01 06:31:32 by WikiAdminAdditions:
[[OracleRedo Redo logs]]
Revision [3559]
Edited on 2009-10-28 05:38:16 by WikiAdminAdditions:
===My Oracle Profile===
Deletions:
Revision [3558]
Edited on 2009-10-28 05:37:56 by WikiAdminAdditions:
===Oracle Certifications===
Too lazy to get more...
{{image url="images/OCA_ODb10gAdmin_clr.gif"}}
Too lazy to get more...
{{image url="images/OCA_ODb10gAdmin_clr.gif"}}
Revision [1993]
Edited on 2008-10-09 03:05:30 by WikiAdminAdditions:
[[OracleExpress Express Edition]]
Revision [1911]
Edited on 2008-08-26 23:07:52 by WikiAdminAdditions:
[[OracleSuspend Database Suspend]]
Revision [1900]
Edited on 2008-08-19 16:18:50 by WikiAdminAdditions:
== Show running SID in sqlplus==
select instance from v$thread;
select instance from v$thread;
Revision [1863]
Edited on 2008-08-04 01:49:11 by WikiAdminAdditions:
=== SQLplus with history!===
Install rlwrap http://freshmeat.net/projects/rlwrap
%%
alias sqlplus='/usr/bin/rlwrap -m ${ORACLE_HOME}/bin/sqlplus'
%%
There you go, you can now use the arrow key to access the historic commands, like in bash.
Install rlwrap http://freshmeat.net/projects/rlwrap
%%
alias sqlplus='/usr/bin/rlwrap -m ${ORACLE_HOME}/bin/sqlplus'
%%
There you go, you can now use the arrow key to access the historic commands, like in bash.
Revision [1494]
Edited on 2008-03-14 23:57:52 by WikiAdminAdditions:
[[OracleCPUPatch Applying CPU patch]]
Revision [978]
Edited on 2007-09-24 02:50:09 by WikiAdminAdditions:
===10g specific===
[[Oracle10gASM Oracle ASM]]
[[Oracle10gASM Oracle ASM]]