Home » RDBMS Server » Server Administration » OracleCSServcie
OracleCSServcie [message #515891] Thu, 14 July 2011 02:30 Go to next message
piotrtal
Messages: 152
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 #515896 is a reply to message #515891] Thu, 14 July 2011 02:36 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
In 11.2, ASM can only be installed as part of Grid Infrastructure (even if on Single Node). Since the GI install does install CRS, CSS etc, these services should have been installed and configured.

See "The Oracle Clusterware Stack" at http://download.oracle.com/docs/cd/E11882_01/rac.112/e16794/intro.htm#CEGJDAHA

Did you have ASM running previously on this node ?
When was 11.2 installed ?
Do you have any documentation on the install ?


Hemant K Chitale
Re: OracleCSServcie [message #515920 is a reply to message #515896] Thu, 14 July 2011 03:42 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

hi Hermant and thanks for you answer.

this instance didn't have asm running. i just want to try to instal asm in my test environment and do some tests so this is only for tests purpose.

so the only think which i should install on my serwer is Oracle Clusterware, but where i should get this package from? i was searching on oracle site, but there is only overview and some technical papers (http://www.oracle.com/technetwork/database/clusterware/overview/index.html). didn't find any link where i could download it.

BTW: i have also 10g installation on another serwer and there is also no OracleCSService in the system.
but focus first on the answer: where i can get this package from?

thanks in advance.
Re: OracleCSServcie [message #515921 is a reply to message #515920] Thu, 14 July 2011 03:47 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

ok. the question is obsolete.
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html (third lik from the top)
i found it, and try it, and if i will have some other question come back. thanks for the moment.
Re: OracleCSServcie [message #515923 is a reply to message #515921] Thu, 14 July 2011 03:54 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

so in previous versions (< 10g) this package wasn't necessary to get ASM be running? everything was as default in the installation pack?
Re: OracleCSServcie [message #515927 is a reply to message #515923] Thu, 14 July 2011 04:09 Go to previous messageGo to next message
John Watson
Messages: 4710
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 #515928 is a reply to message #515927] Thu, 14 July 2011 04:21 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

thanks John,

but my problem is that I can't find OracleCSService and didn't know if i should install some separate package or something to have this service. my version od oracle is 11.2 and windows2008 and i was trying to run OracleInstaller again to find maybe there is an option or something - but there wasn't any trace of this.

the only trace of css was this catalog

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 files have their extensions changed from *.bat to *.sbs so I don't know what they are for and what I can use them.

so I presume first I should install OracleClusterware for 11g and then this services will appear in my system, and later i will login successfully to my fresh created ASM instance without such comments from oracle

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


Re: OracleCSServcie [message #515929 is a reply to message #515928] Thu, 14 July 2011 04:23 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

writing "Clusterware" i mean "Oracle Database 11g Release 2 Grid Infrastructure" which contains early mentioned functions.
Re: OracleCSServcie [message #515930 is a reply to message #515929] Thu, 14 July 2011 04:28 Go to previous messageGo to next message
John Watson
Messages: 4710
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 messageGo to next message
piotrtal
Messages: 152
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 messageGo to next message
John Watson
Messages: 4710
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 #515935 is a reply to message #515932] Thu, 14 July 2011 04:35 Go to previous messageGo to next message
John Watson
Messages: 4710
Registered: January 2010
Location: Global Village
Senior Member
Cluster Synchronization Services Daemon.
Re: OracleCSServcie [message #515937 is a reply to message #515933] Thu, 14 July 2011 04:37 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

i exported oracle_sid variable before i tryied to startup my ASM instance:

D:\oracle\product\11.2.0\dbhome_1\BIN>set oracle_sid=+ASM

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 11:36:24 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
SQL>
Re: OracleCSServcie [message #515938 is a reply to message #515935] Thu, 14 July 2011 04:39 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

John Watson wrote on Thu, 14 July 2011 04:35
Cluster Synchronization Services Daemon.


but this is the same as OracleCSService if we are taking Windows2008 OS platform?
Re: OracleCSServcie [message #515939 is a reply to message #515938] Thu, 14 July 2011 04:44 Go to previous messageGo to next message
John Watson
Messages: 4710
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 messageGo to next message
piotrtal
Messages: 152
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 #515945 is a reply to message #515942] Thu, 14 July 2011 05:15 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

ok. i managed to create this service in 10g

c:\oracle\10.2.0\db_1\BIN>localconfig.bat add
Step 1:  creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'piotr', privgrp ''..
Operation successful.
Step 2:  creating new CSS service
successfully created local CSS service
successfully added CSS to home


... so if i won't find info how i can create this service in 11g I do my examples on 10g - my loss
Re: OracleCSServcie [message #515964 is a reply to message #515945] Thu, 14 July 2011 05:43 Go to previous messageGo to next message
piotrtal
Messages: 152
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 #516031 is a reply to message #515964] Thu, 14 July 2011 12:29 Go to previous messageGo to next message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

just for the record:

I tryed to do my ASM instance after I get my home and I succeded. but it was done on 10g version of oracle. there was script (localconfig.bat) which I can use for creating OracleCSService. after that i recovered two raw disks from my OS using asmtool and mark them as active to ASM instance, and create diskgroup.

but i still don't understand why Oracle Corp. didn't include this tools in 11g version but forces administrator to install GridInfrasctructure instead to have this option. in 11g everything looks twice complicated.

nevermind... i still try to do this on 11g. maybe i will succedd some day.

thanks for replays.
Re: OracleCSServcie [message #516303 is a reply to message #516031] Sat, 16 July 2011 06:52 Go to previous message
piotrtal
Messages: 152
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.
Previous Topic: Oracle Rac Standard/Enterprise
Next Topic: Total No of files in FRA
Goto Forum:
  


Current Time: Fri Oct 31 17:25:10 CDT 2014

Total time taken to generate the page: 0.13078 seconds