asm_10g2.mht

oracle 10gr2 asm on windows and unix

  )

ORCL1 =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux1-vip)(PORT =3D 1521))
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D orcl.idevelopment.info)
      (INSTANCE_NAME =3D orcl1)
    )
  )

ORCL2 =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux2-vip)(PORT =3D 1521))
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D orcl.idevelopment.info)
      (INSTANCE_NAME =3D orcl2)
    )
  )

<B><FONT color=3D#0000ff>ORCL1_ASM1 =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux1-vip)(PORT =3D =
1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D +ASM)
    )
  )

ORCL2_ASM2 =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux2-vip)(PORT =3D =
1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D +ASM)
    )
  )</FONT></B>

ORCL_TAF =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux1-vip)(PORT =3D 1521))
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D linux2-vip)(PORT =3D 1521))
    (LOAD_BALANCE =3D yes)
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D orcl_taf.idevelopment.info)
      (FAILOVER_MODE =3D
        (TYPE =3D SELECT)
        (METHOD =3D BASIC)
        (RETRIES =3D 180)
        (DELAY =3D 5)
      )
    )
  )</PRE></TD></TR></TBODY></TABLE></P></BLOCKQUOTE>
<P><BR>
<HR>

<P><!--=0A=
   | **********************************************************=0A=
   |   BOUNCE THE TNS LISTENER=0A=
   | **********************************************************=0A=
   +--><A=20
name=3D"Bounce the TNS Listener"><U><B><FONT color=3D#000099>Bounce the =
TNS=20
Listener</FONT></B></U>=20
<BLOCKQUOTE>The final step is to bounce the Oracle TNS Listener. =
Remember that=20
  the listener process will need to be bounced on both of the nodes in =
the RAC=20
  cluster: <PRE># -----------
# FROM linux1
# -----------
[oracle@linux1 ~]$ <B>lsnrctl stop LISTENER_LINUX1</B>
[oracle@linux1 ~]$ <B>lsnrctl start LISTENER_LINUX1</B>

# -----------
# FROM linux2
# -----------
[oracle@linux2 ~]$ <B>lsnrctl stop LISTENER_LINUX2</B>
[oracle@linux2 ~]$ <B>lsnrctl start LISTENER_LINUX2</B></PRE>After =
restarting=20
  the TNS listener, the new service should be available from both nodes =
in the=20
  RAC cluster: <PRE># -----------
# FROM linux1
# -----------
[oracle@linux1 ~]$ lsnrctl status LISTENER_LINUX1 | grep ASM
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status <B><FONT color=3D#0000ff>UNKNOWN</FONT></B>, =
has 1 handler(s) for this service...
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

# -----------
# FROM linux2
# -----------
[oracle@linux2 ~]$ lsnrctl status LISTENER_LINUX2 | grep ASM
Service "+ASM" has 2 instance(s).
  Instance "+ASM2", status <B><FONT color=3D#0000ff>UNKNOWN</FONT></B>, =
has 1 handler(s) for this service...
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this =
service...</PRE></BLOCKQUOTE>
<P><BR>
<HR>

<P><!--=0A=
   | **********************************************************=0A=
   |   TEST ACCESS TO ASM FROM THE CLIENT MACHINE=0A=
   | **********************************************************=0A=
   +--><A=20
name=3D"Test Access to ASM from the Client Machine"><U><B><FONT =
color=3D#000099>Test=20
Access to ASM from the Client Machine</FONT></B></U>=20
<BLOCKQUOTE>After the new ASM service(s) have been added and the TNS =
listener=20
  successfully restarted, test access to the ASM instances from the =
client=20
  machine using SQL*Plus: <PRE>ORA10G on alex: <B>sqlplus =
"sys/&lt;ASM_SYS_PASSWORD&gt;@orcl1_asm1 as sysdba" =
@asm_diskgroups.sql</B>

Disk Group            Sector   Block   Allocation
Name                    Size    Size    Unit Size State       Type   =
Total Size (MB) Used Size (MB) Pct. Used
-------------------- ------- ------- ------------ ----------- ------ =
--------------- -------------- ---------
FLASH_RECOVERY_AREA      512   4,096    1,048,576 MOUNTED     EXTERN     =
    596,985            339       .06
ORCL_DATA1               512   4,096    1,048,576 MOUNTED     EXTERN     =
    597,017         40,784      6.83
                                                                     =
--------------- --------------
Grand Total:                                                             =
  1,194,002         41,123



ORA10G on alex: <B>sqlplus "sys/&lt;ASM_SYS_PASSWORD&gt;@orcl2_asm2 as =
sysdba" @asm_diskgroups.sql</B>

Disk Group            Sector   Block   Allocation
Name                    Size    Size    Unit Size State       Type   =
Total Size (MB) Used Size (MB) Pct. Used
-------------------- ------- ------- ------------ ----------- ------ =
--------------- -------------- ---------
FLASH_RECOVERY_AREA      512   4,096    1,048,576 MOUNTED     EXTERN     =
    596,985            339       .06
ORCL_DATA1               512   4,096    1,048,576 MOUNTED     EXTERN     =
    597,017         40,784      6.83
                                                                     =
--------------- --------------
Grand Total:                                                             =
  1,194,002         41,123</PRE></BLOCKQUOTE>
<P><BR><!--=0A=
   | **********************************************************=0A=
   |   GOOGLE AD  -  (BEGIN)=0A=
   | **********************************************************=0A=
   +-->
<CENTER>
<SCRIPT type=3Dtext/javascript><!--=0A=
  google_ad_client =3D "pub-7890769181671129";=0A=
  google_ad_width =3D 728;=0A=
  google_ad_height =3D 90;=0A=
  google_ad_format =3D "728x90_as";=0A=
  google_ad_type =3D "text";=0A=
  google_ad_channel =3D"4978044779";=0A=
  google_page_url =3D document.location;=0A=
  google_color_border =3D "336699";=0A=
  google_color_bg =3D "FFFFFF";=0A=
  google_color_link =3D "0000FF";=0A=
  google_color_url =3D "008000";=0A=
  google_color_text =3D "000000";=0A=
  //--></SCRIPT>

<SCRIPT src=3D"http://pagead2.googlesyndication.com/pagead/show_ads.js"=20
type=3Dtext/javascript>=0A=
  </SCRIPT>
</CENTER><!--=0A=
   | **********************************************************=0A=
   |   GOOGLE AD  -  (END)=0A=
   | **********************************************************=0A=
   +--><!--=0A=
   | **********************************************************=0A=
   |   END OF PAGE - (COPYRIGHT AND DISCLAIMER)=0A=
   | **********************************************************=0A=
   +-->
<HR noShade SIZE=3D3>

<CENTER><SMALL><B><FONT color=3D#ff1010>Copyright (c) 1998-2009 Jeffrey =
M. Hunter.=20
All rights reserved.</FONT></B>=20
<P><I><FONT color=3Dpurple>All articles, scripts and material located at =
the=20
Internet address of <A class=3DnoLinkBlue =
href=3D"http://www.idevelopment.info/"=20
target=3D_blank>http://www.idevelopment.info/</A> is the copyright of =
Jeffrey M.=20
Hunter and is protected under copyright laws of the United States. This =
document=20
may not be hosted on any other site without my express, prior, written=20
permission. Application to host any of the material elsewhere can be =
made by=20
contacting me at <A class=3DnoLinkBlue=20
href=3D"mailto:[e-mail]">[e-mail]</A>. =

<P>I have made every effort and taken great care in making sure that the =

material included on my web site is technically accurate, but I disclaim =
any and=20
all responsibility for any loss, damage or destruction of data or any =
other=20
property which may arise from relying on it. I will in no case be liable =
for any=20
monetary damages arising from such loss, damage or destruction.=20
</FONT></I></SMALL></CENTER>
<P>
<CENTER><SMALL>Last modified on<BR>Tuesday, 29-Jan-2008 21:42:49 =
EST<BR><FONT=20
color=3D#ffffff>Page Count: 11218</FONT> </SMALL></CENTER></BODY></HTML>

------=_NextPart_000_0000_01C9B143.9E67D5A0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://www.idevelopment.info/gifs/header_oracle.gif

R0lGODlhdwE8APcAAAAAAGNj72Nj92Nj/2tj52tj72tj92tj/2trtWtrvWtrxmtrzmtr1mtr3mtr
52tr73NzrZSU55yU1pyU3pycvZyczpyc1pyc3pyc55yc75yc95yc/8bG1sbG3sbG58bG78bG98bG
/8bOzs7Ozt7e/+fn5+fn7+fn9/f39///////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAAdwE8AAAI/gBTCBxI
sKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzIsaPHjyBDihxJsqTJkyhTqlzJsqXLlzBjypxJs6bN
mzhz6tzJs6fPn0CDCh1KtKjRo0iTKl3KtKlAAFCjAugpVarTq1h5Vt26cyvUrGDDyvTKNSdZsWjT
oiTr1WxbtXDjemRb9uZZuXjzUjx7NwXfrwb7IhQ8kHDhunoTx/1bly7gw3QPOg78luBkxZjRMq4K
ma1lx4+fgp7a2erny5lTX91s2i/q0aFdgz7NuXRk1biXso5qu+zux797k5bNuXLu40V/D59N3Grf
4KIbtzWMvDrV6ZWZKxfeHHh27Iit/ovvCr52d9/lW0M/vzw97/HwdW6PHn4++/Pc6Y+Oz9+ue+/h
3feccZJ9B9tw/SUIk33UUTZggAU9CJuCFL7EIIEOeqbfewlJuF+FIKp0IYTsGWjeYCa2FuKKLY14
onAecoiidCSyaCNJLqq44Wv/5ScghjcGmVGOMu44VYxfpcihfUI2iRGRsf1IY3FTqvcfgk5mORGU
WEpp3npIHgmklmQyxGWGzimZZJVLXlnmmxAdSJuOXlrJFWJh3gfnngvJ6SOMgk34p598FjrjbX8a
qaGiOhL2oaGQohkgdQdiiVqiJUYZ6ab4FUjinUBSOmaDnJZq6qmopqrqqqy26uqr/rDGKuustNZq
66245qrrriEN4KuvAvzqwAIohLQAAQME+6uvDmBQrEcoNPBrsAcA64AGz3aEAgYOTLssARiEtEEA
BiS7rK8MiCTtuck+oEC2Hi1QgLLA+tqAusvSK8C1IWGAbL3ChpvCANUWPEC5DxBr7AMCGFztAM2C
FC3BFJd7gAHXwssRtxRXWy7EzoKkAbkdExxsAxpzJK3FFA+QcMobLfBAxS2nG5K0DjcswAMa9Nut
wR9HPHDL9A5LAgkwYySzuRQ37MAFJJjw0brmPoyxBkh/xLGy1Qb7dNQfacDwsh8f0AAJJUjtEdUH
U2w00klbJC/TB1B7dtpT19u1/ssEYF2C1t0C+7DZUJvQcsHBugsCB3/HW0DTLTcgQQccTG1wsh43
EEEHjXfkr8m+PtyABZSHTXLdoSfbgAcidK5y2/kqzvhHS38M+uqt5/1ww74+4MDmIgDeMugOTM7B
r7ZXO2wIs8f7AOq7DzB6B8GvXfWvBzygOefCQ16t5BxU39HIZXMtPeuub7SuxxS7y3z6Gs0NO8UM
fJC79cMjvL34G//7cNsNqAD18iesBYCAe44LHbXsVQEOVM56VqNYABowAQR6LnDeC6ADw8Yw6NUL
d/DLiLQWCCz3Na8jS6MWvUCYNwWGboKbG0H3ICc9CYTPhS0b1gFDqLSZkbBc/uDjn/qYhjztbY6H
F8nAz0hYw/CZrnyRQ5/uBMcsA56QI3PrGuJYaL2y/Up7FRSiRj5nsi028HiDW6AJkSi3mdHQbGec
4vzAaMGNYVCLTRRjRkYWrOSdTIoeYQAV3WZFNlZkab4ql7K42BGq1a1rBmAA8GYIsCACbHeKq2PM
3MjEIOaNd00zoibHiKy9hc4BAtQjRsTGNfMx8nUGC9bOFPA+2j3uf11rgP0MSRGcnWtn+9PavwyA
OOmd8QEPKIADHhCAZRKgAQlYHC8nooAGEACZDgiA7wrAgDg6r5nMXGYzFzC5aUoEAwwIJzKVGYBu
btAjGbCm77TpgAIwcwGA/kQhOMGZTWhK8yPVxCY475lPjqTzmsuc57Amp8qLXIAB9GymMh/gThEs
QAEXzShGEwABD1xxIxBQAEZHmlEEUMCJHkFARjW6gAQgoIHmjEgFEkBSjF40ASdtqEUuQFOWjhQB
1IspRFTqU5F29KMagUACVkpSoN6vI0St6UVfitKOzFSqN81pClBAAhCEwKtg9UBQP1IsEnz1rF79
APV0epGuovWrakUqR8CKVrWKgK0VQQEK3grWD4RPqBDhKl3TKla5ZoSrfA2BR5/KEb26Fa0giCte
LZJYu1aPBBygnGYdeFfAQgSzmQ0t5e46grhd5ASidaBqGeuRzaqWszIMVIkDKZdaEYzAsw/B7GZp
29mQoDa1o2UtR0Ab2tfaViS7Le5dBYKCEjj3udDFrUNMEN3qmtYi1K3uc9UGEu1CVyTe/W53w+vc
kGQ3vOYlr3Qdot6AAAA7

------=_NextPart_000_0000_01C9B143.9E67D5A0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://www.idevelopment.info/gifs/home_button.gif

R0lGODlhPAAYAPcAAAAAAISEhMbGxv//////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAAPAAYAAAIygAHCBxI
sKDBgwgTKiQoYICAhxAjSpxIsaLFiw8DAHCIsaPHjxM1cgRJsiRFkSZTqkSpsiVIlhUBTJTpkiRM
ijQj5qzp8ebMnzw/+pS482FOAEiPCkBqdGfSohWH6nya1KjOpliXWoUINeTGi1BpOt2qdetYjFK5
Aj2r1CzVjmnJqi1rdm7Zrhfj0p3L1q7Yq2i/WgzLtSrZtksNBx4ZtDFEvY5XCo7sGDLlkpYvv5ys
uabIAKBDix5NurTp06hDU13NurXr17CpBgQAOw==

------=_NextPart_000_0000_01C9B143.9E67D5A0
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-Location: http://www.idevelopment.info/gifs/back_button.gif

R0lGODlhPAAYAPcAAAAAAISEhMbGxv//////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////ywAAAAAPAAYAAAI1gAHCBxI
sKDBgwgTKiQoYICAhxAjSpxIsaLFiw8DAHCIsaPHjxM1cgRJsiRFkSZTqkSpsiVIlioByJxpEsBF
mCltRtQJkufJjRVlShS6c2hJnyGBTiQKkWlTow9n+pQa9alEnFGROm0qlefUqk91Is2olOvQsWCt
CuiaNmxFrGu1otXaVuzSrRDhxj27FOrXtX0BJx3JdyfdooLBfvU62GXXqTTF0kxMWYBel5ivls3M
WTPhzqAvg3YpevTKzaYziwzAurXr17Bjy55Nu/Xj27hz696tOyAAOw==

------=_NextPart_000_0000_01C9B143.9E67D5A0
Content-Type: application/octet-stream
Content-Transfer-Encoding: quoted-printable
Content-Location: http://pagead2.googlesyndication.com/pagead/show_ads.js

<html><head><title>ACCESS DENIED</title></head><body bgcolor=3D"#000000" =
text=3D"#FF0000" =0D
link=3D"#CCCCCC" vlink=3D"#CCCCCC" alink=3D"#CCCCCC">
<table width=3D"80%" border=3D"1" align=3D"center" =
bordercolor=3D"#FF0000"> <tr><td><table =0D
width=3D"100%" border=3D"0" align=3D"center"><tr><td><div =
align=3D"center"><font color=3D"#FF0000" =0D
size=3D"5" face=3D"Verdana"><strong>Surf-Pune has denied this Website =
access =0D
</strong></font></div></td></tr><tr><td><div align=3D"center"><font =0D
color=3D"#FF0000"><br><font face=3D"Verdana"><tr><td><div =
align=3D"center"><font color=3D"#FF0000" =0D
size=3D"2" face=3D"verdana"><br>Access has been denied =0D
<br><br>Please log a call at tim.techmahindra.com/helpdesk <br>Kindly =
visit http://tim.techmahindra.com to find the Category Details for =
Internet Access
</font></div></td></tr><td><div =0D
align=3D"right"><font size=3D"1" face=3D"Verdana"><br>Tech Mahindra  =0D
Ltd.</font></div></td></tr><br></table></td></tr></table></body></html> 
------=_NextPart_000_0000_01C9B143.9E67D5A0--