OracleCSServcie [message #515891] |
Thu, 14 July 2011 02:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
Hi everyone.
I mean Oracle Cluster Synchronization Service. This component is essential if we want to use database installed on ASM instance.
After login into my ASM instance i get
D:\oracle\product\11.2.0\dbhome_1\BIN>sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Cz Lip 14 08:34:21 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Po│╣czono z nieaktywn╣ instancj╣.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
at this momnent i didn't know that OracleCSService is required for proper working of ASM, but i started do believe.
so after checking this service in ControlPanel i found that i don't have it!!! - suprrise.
after 2 hours of digging on google i didn't find how to install this sercice - should i use OracleInstaller od do this with external program - don't know.
i found something like catalog which contain some files (i think connected with CSS)
D:\oracle\product\11.2.0\dbhome_1\crs\sbs>dir
Volume in drive D
Volume Serial Number is 4C2F-50DB
Directory of D:\oracle\product\11.2.0\dbhome_1\crs\sbs
2011-07-14 09:06 <DIR> .
2011-07-14 09:06 <DIR> ..
2007-07-18 18:50 529 clsrwrap.sbs
2005-06-08 10:42 1 604 localconfig.bat.sbs
2009-10-08 16:31 2 508 srvctl.sbs
3 File(s) 4 641 bytes
2 Dir(s) 93 353 299 968 bytes free
but the extensions are *.sbs so i can't run it.
the localconfig.bat.sbs contains something like that:
if (%1)==(delete) %ORACLE_HOME%\bin\crssetup.exe ldel %2 & goto done
if (%1)==(add) %ORACLE_HOME%\bin\crssetup.exe ladd -oh "%s_OracleHome%" -l "%s_languageid%" & goto done
if (%1)==(reset) %ORACLE_HOME%\bin\crssetup.exe lres -oh %2 -l "%s_languageid%" & goto done
%ORACLE_HOME%\bin\crssetup.exe %1 %2 & goto done
so i presume that this script is doing something like installation of CSS so i started digging further... and i didn't find crssetup.exe, and i give up after that.
could you help me with this.
i just want to play with ASM isntance and this component (OracleCSService) is required for proper working of this thing.
|
|
|
|
|
|
|
Re: OracleCSServcie [message #515927 is a reply to message #515923] |
Thu, 14 July 2011 04:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi, man - in releases < 11.2 you still need the CSSD to run ASM.
A version of CSSD was shipped with the 10.x and 11.1 database software, you would run the localconfig shell script from your $DBHOME to put an entry in your /etc/inittab file that would launch the CSSD from the $DBHOME. Or localconfig.bat for Windows would configure a Windows service.
So why do you need it? Here you go:
When your ASM instance mounts a disc group, it registers this fact with the CSSD. Then when your RDBMS instance wants to open an ASM file, at asks the CSSD "which instance is managing this disc group?" The CSSD replies with the name of the ASM instance, and the RDBMS then logs on to it, and asks for the extent map (the physical locations) of the file.
So CSSD sets up conenctions between RDBMS instance(s) and ASM instance, then the ASM instance sets up the connections between the RDBMS instance and the files.
|
|
|
|
|
Re: OracleCSServcie [message #515930 is a reply to message #515929] |
Thu, 14 July 2011 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I don't know how you managed to install the Grid Infrastructure without setting up the CSSD. If you installed it taking sensible options, it will have created all necessary services, and the ASM instance too.
Better start again.
|
|
|
Re: OracleCSServcie [message #515932 is a reply to message #515930] |
Thu, 14 July 2011 04:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
Jonh, what do you mean writing CSSD? OracleCSService (Cluster Synchronization Service) ?
you wrote "A version of CSSD was shipped with the 10.x and 11.1 database software" but i can't find it in my system.
and maybe i didn't want to install Grid Infrastructure to have this service.
[Updated on: Thu, 14 July 2011 04:34] Report message to a moderator
|
|
|
Re: OracleCSServcie [message #515933 is a reply to message #515930] |
Thu, 14 July 2011 04:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Oh, I've just seen what you are doing wrong: you are using SQL*Plus from your database home, probably connecting to your RDBMS instance. You need to set your environment variables to connect you to your Grid Infrastructure home, and the ASM instance. It is probably called +ASM.
Better read that 11.2 Database Storage Administrator's Guide.
|
|
|
|
|
|
Re: OracleCSServcie [message #515939 is a reply to message #515938] |
Thu, 14 July 2011 04:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:you are using SQL*Plus from your database home You have to setup your environment correctly. The Grid Infrastructure binaries are not the same as the RDBMS binaries.
If you look at the definition of the Windows CSS service in your Windows registry, you'll see what executable it is launching. Read the doc, and all will become clear.
I'm off shift now.
|
|
|
Re: OracleCSServcie [message #515942 is a reply to message #515939] |
Thu, 14 July 2011 04:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
the problem is that i don't have this OracleCSService in my OS and completelly don't know how can I get it -should i install this external softwrae which i mendioned before or execute some scripts.
i just wanted to do create my +ASM instance and log into it, and do some examples with it. the process of creating +ASM instance are described in many places in the internet, but there is nowhere where they get "ORA-29701: unable to connect to Cluster Synchronization Service" error after executing startup:
there is an example for 10g database from ( http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_10.shtml ) and it looks like everything work fine fro them but it don't work in my environmemnt becouse of this f* OracleCSService which does'nt exist in my OS
C:\> oradim -new -asmsid +ASM -syspwd change_on_install
-pfile C:\oracle\product\10.1.0\admin\+ASM\pfile\init.ora -spfile
-startmode manual -shutmode immediate
Instance created.
C:\> oradim -edit -asmsid +ASM -startmode a
C:\> set oracle_sid=+ASM
C:\> sqlplus "/ as sysdba"
SQL> startup pfile='C:\oracle\product\10.1.0\admin\+ASM\pfile\init.ora';
ASM instance started
Total System Global Area 125829120 bytes
Fixed Size 769268 bytes
Variable Size 125059852 bytes
Database Buffers 0 bytes
Redo Buffers 0 bytes
ORA-15110: no diskgroups mounted
after startup i get
ORA-29701: unable to connect to Cluster Synchronization Service
[Updated on: Thu, 14 July 2011 04:57] Report message to a moderator
|
|
|
|
Re: OracleCSServcie [message #515964 is a reply to message #515945] |
Thu, 14 July 2011 05:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
my story - continuation:
after i installed 11gr2 GridInfractructure i noticed that there is ocssd.exe executable file in the new home which was created after this installation.
.. and just after i executed ocssd.exe, it i can log into my +ASM instance
D:\oracle\product\11.2.0\dbhome_1\BIN>sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Cz Lip 14 12:39:03 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Po│╣czono z nieaktywn╣ instancj╣.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for ASM instance
Uruchomiono instancjŕ ASM
Total System Global Area 283930624 bytes
Fixed Size 2175048 bytes
Variable Size 256589752 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL>
i know that this is a little progress but at least i can log into my ASM instance.
[Updated on: Thu, 14 July 2011 05:44] Report message to a moderator
|
|
|
|
Re: OracleCSServcie [message #516303 is a reply to message #516031] |
Sat, 16 July 2011 06:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
i just can't supress with my opinion about ASM, so sorry for my comment.
i tryed it on 10g and now i am digging in it for about two days.
ITS REALLY POWERFULL. im' impressed.
|
|
|