{"id":93,"date":"2014-01-25T12:36:25","date_gmt":"2014-01-25T12:36:25","guid":{"rendered":"http:\/\/www.dbafox.com\/?page_id=93"},"modified":"2017-09-05T09:13:05","modified_gmt":"2017-09-05T09:13:05","slug":"oracle-articles","status":"publish","type":"page","link":"https:\/\/dbafox.com\/?page_id=93","title":{"rendered":"Oracle Articles"},"content":{"rendered":"

\"oracle-logo\"<\/a>A series of links to <\/p>\n

Oracle articles and documents<\/h2>\n

.<\/p>\n

Oracle Wiki<\/h2>\n

“a website for IT Professionals involved with Oracle database”<\/p>\n

Oracle Wiki<\/a><\/p>\n

Show High Water Mark Statistics<\/h3>\n

The Oracle data dictionary contains a view which shows high water mark values for specific Oracle features and other licesing-related metrics (like CPU_COUNT)<\/p>\n

Show High Water Mark Statistics<\/a><\/p>\n

Oracle Dataguard<\/h2>\n

Maximum Availability Architecture, rolling upgrades (pdf whitepaper October 2011)<\/a><\/p>\n

Oracle and SCOM<\/h2>\n

“Oracle Management Connector for Microsoft SCOM enables customers who manage their data centers using Microsoft System Center Operations Manager(SCOM) to integrate with Oracle Enterprise Manager by enabling end-to-end event\/alert sharing”<\/p>\n

Oracle Enterprise Manager Grid Control Management Connector<\/em> for Microsoft System Center Operations Manager<\/a>
\nWhite paper for Oracle Grid Control and SCOM connector<\/a><\/p>\n

It is also possible to monitor Oracle databases with SCOM using the OLE DB management pack (the following link describes this solution). I have not personally tested this. Thanks to the author of the post (all credits are in the post)
\n
\nMonitor Oracle database with SCOM and OLE DB management pack<\/a><\/p>\n

sqlplus<\/h2>\n

define editor for sqlplus sessions (linux)<\/h3>\n

\nDEFINE _EDITOR=gedit
\nor
\nDEFINE _EDITOR=vi<\/p>\n

(put it in $ORACLE_HOME\/sqlplus\/admin\/glogin.sql)<\/p>\n

You can also define it in your OS environment, before starting Sql*Plus<\/p>\n

$ export EDITOR=vi
\n$ sqlplus ….

\nSQL> select * from dual;
\nSQL> edit — opens the defined editor inline so that the current command buffer can be edited<\/span>
\nto make it permanent you can set it within the OS user’s profile (.bash_profile).
\n\n<\/p>\n

Connecting from Windows to Linux to Manage Oracle databases on Linux<\/h2>\n

MobaXterm<\/h3>\n

Get MobaXterm from: MobaXterm download<\/a>
\n<\/p>\n

XMing and Putty<\/h3>\n

Get XMing from: XMing download<\/a>
\n
\nGet Putty from: Download Putty<\/a>
\n<\/p>\n

mRemoteNG<\/h3>\n

Get mRemoteNGfrom: Download mRemoteNG<\/a><\/p>\n

Oracle Instance on Linux<\/h2>\n

Files in the dbs ($ORACLE_HOME\/dbs) directory<\/h3>\n