Server Administration :: Few Cluster Services Are Down

Nov 9, 2010

on 6th of August at 02:36 our following cluster services were down,i see the logs and found that ASM is down and disk group are not accessible and ASMb process is terminated and both instances was restarted, i checked the cluster services so five services were down and these are

Quote: ora_ OCR_DG.DG, ora_fedb96.asm2.asm, ora_fedb96.gsd, ora_fedb96.ons and ora_fedb96.oc4j...

I restarted the services and they were successfully up and application become available . What can be the reason of the service failure?

alert.log

ORA-03113: end-of-file on communication channel
Process ID:
Session ID: 157 Serial number: 6655
ASMB (ospid: 23903): terminating the instance due to error 15064
Mon Aug 06 02:36:38 2012
NOTE: Deferred communication with ASM instance
Errors in file /u01/app/oracle/diag/rdbms/grid12/grid91/trace/grid91_ora_25856.trc:
ORA-15055: unable to connect to ASM instance
ORA-01092: ORACLE instance terminated. Disconnection forced
[code]...

View 1 Replies


ADVERTISEMENT

RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Nov 21, 2012

RAC star crs failed

[root@tyan147 crsd]# /orahome/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

cssd.log

2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1100] GIPC gipcretConnectionRefused (29) gipcConnect(ipc-ipc://GPNPD_tyan147)
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1101] Result: (48) CLSGPNP_COMM_ERR. Failed to connect to call url "ipc://GPNPD_tyan147"
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnp_getProfileEx: [at clsgpnp.c:546] Result: (13) CLSGPNP_NO_DAEMON. Can't get GPnP service profile from local GPnP daemon
2012-11-21 11:12:29.313: [ default][3613030480]Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2012-11-21 11:12:29.313: [ CSSD][3613030480]clsgpnp_getProfile failed, rc(13)

[code]....

View 2 Replies View Related

Clusterware :: CRS-4535 - Cannot Communicate With Cluster Ready Services

May 23, 2013

We have 3 node RAC. In one of the node clusterware is down and also CSSD process is down. I got to know that we have to clear socket files in that node.what needs to be done instead ofclearing socket files.

database
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
[code]...

View 3 Replies View Related

RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008

Jan 22, 2013

I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).

srvctl stop database -d <database_name>

Node 1:
crsctl stop has

Node 2:
crsctl stop has

But i am getting error like Oracle HAS Service not stopped successfully. Finally what i did was stopped the OHAS Service from Windows Services.

which is the right procedure to have a clean stopping of RAC Services in 11g R2.

View 4 Replies View Related

RAC/ASM Clusterware Installation :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Dec 7, 2012

im having problems with CRS in a Rac installation. Because of this i cant start the database.I installed Oracle Rac 11.2.0.1 with ASM in a Red Hat 5.8 linux server. Everything was ok until a server reboot. I have 2 nodes, nodo1 and nodo2. Both got rebooted and after that im not able to start the cluster.

All the other resources seem to be just fine .

At nodo1:
[root@nodo1 oracle]# crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo2'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo1'
CRS-2672: Attempting to start 'ora.diskmon' on 'nodo1'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo2'

[code]....

View 5 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: Oracle And Active Directory Services - Missing Binaries

Mar 8, 2012

What two Active Directory services are stopped when you install Active Directory before Oracle 10g? I know the error message for that and I know why it happened but I just need to know the two services so I can start them again. I think it happened because I installed Active Directory first so when I installed Oracle second it stopped two services and I just need to know them. The error message is:

Active Directory is missing binaries, please restart and try again

View 2 Replies View Related

Server Administration :: ORA-29702 / Error Occurred In Cluster Group Service Operation

Aug 12, 2010

I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called

Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:

ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation

View 11 Replies View Related

Restarting Oracle Services Through Services.msc Is Faster Than Manual

May 17, 2013

Restarting oracle services through services.msc is faster then manual (In command prompt).

Even If we have heavy transaction on the oracle database But we can restart the database within minutes by using services.msc But It will take more time in command prompt(sql>shu immediate). So shall we assume here that services.msc is using shut abort command while restarting the database?

View 3 Replies View Related

Clusterware :: Grid On Standalone Server Cluster Daemons Not Starting During Server Boot

Jul 4, 2012

I have installed Oracle Grid on a standalone server and setup Oracle db 11.2.0.2 on Oracle Linux 6.2 64 bit server.When I reoot the server and run crs_stat -t,several daemons havent started thus the ASM and db instances are also down as below

Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type OFFLINE OFFLINE
ora.FRADG.dg ora....up.type OFFLINE OFFLINE
ora....ER.lsnr ora....er.type ONLINE ONLINE amldb01dc
ora.amldb.db ora....se.type OFFLINE OFFLINE
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE OFFLINE
ora.diskmon ora....on.type ONLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE amldb01dc
ora.ons ora.ons.type OFFLINE OFFLINE

I am forced to manually start the daemons via command crsctl start resource -all then I manually start the ASM and db instances. Yet when I run the commands

crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.

crsctl check has
CRS-4638: Oracle High Availability Services is online.

Thus I would assume the daemons would start automatically during boot.

View 5 Replies View Related

Application Express :: Defining Proxy Server For Web Services

Dec 5, 2012

I'm trying to create a web service via the WSDL wizard (Apex 4.0.2). We are behind a firewall and connect to the internet via a proxy server. The proxy server requires authentication with a username and password. How to include the username and password in defining the Proxy Server in the Application Definition page or optionally in the alternate location in the Manual Web Service wizard page?

I assume the base definition for the proxy server is [http://]host[:port][]

View 2 Replies View Related

Client Tools :: Oracle Services For Microsoft Transaction Server?

Apr 2, 2012

I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.

View 3 Replies View Related

Networking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?

Mar 11, 2011

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)

View 4 Replies View Related

To Query The Cluster Name From Server

Dec 20, 2012

We have few Solaris RAC Clusters. When I try to query the cluster name from server using the following command i get the same result for all the clusters.

soc02n02-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

soc03n01-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

While in the OEM Grid Console it shows the separate name given to each of them. Check the attached .pdf

Q.Why the cluster names are same from the OS level but different in the OEM console.
Q.Is there any way we can find out the individual cluster names other than cemutlo commands.
Q.In OEM why is the "Cluster" different from the "Cluster name"

Attached File(s)

SOC_Cluster.pdf ( 27.63K )
Number of downloads: 2 

View 1 Replies View Related

Install RAC Cluster Onto Linux Server

Apr 1, 2011

What I wanted to know was the steps to place a RAC cluster onto a brand new Linux server.

Step 1 - Install Cluster Software , CRS & Voting Disks
Step 2 - VIPCA - VIP Config (VIP, GSD, ONS) Resouce Apps
Step 3 - Create ASM Instance
Step 4 - Install Grid Infrastructure
Step 5 - Install RAC
Step 6 - Create Cluster DB - using DBCA with Enterprise Manager

This will be a 2 node RAC cluster going onto a Redhat 5 Linux box

View 2 Replies View Related

Server Utilities :: Does Oracle Forms / Report Services (Standalone) Support Data Export Utility

Jun 10, 2010

I have a From which take Logical Backup through oracle export utility. This Form work fine when i Start OCJ4 but when i want to take backup after running oracle Forms & Report services its not take backup.

My Question is dose Oracle Forms & Report Services (Standalone) Support data backup through Export (exp) utility. I have install Oracle Forms and Report Services (Standalone) on Window XP (SP-3).

View 1 Replies View Related

Server Utilities :: Export Hangs At Exporting Cluster Definitions?

Dec 22, 2010

Sunddenly my exports hangs at 'exporting cluster definitions'. I had been using this database since last 4 years and it never cause a problem or hangs at this level. here i'm pasting my screen details. it is my production db.

[oracle1@wbh_as1 smbshare]$ exp wb/wb

Export: Release 9.2.0.1.0 - Production on Thu Dec 23 00:02:44 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > wb

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user WB
About to export WB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions

View 11 Replies View Related

RAC/ASM Clusterware Installation :: Multiple Cluster Installation In Blade Server?

Dec 6, 2012

I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.

View 1 Replies View Related

RAC - CRS Services?

Feb 7, 2011

I have 10g 2 node cluster running on Linux OS (redhat 4). Oracle version is 10.2.0.5.0. The problem is when the CRS get start all the services are online but when i try to connect DB, its connecting to idle instance. When I check the details the backgroundprocesses all get started but instance not started. Later i stopped the background processes and start the instance manually using sqlplus, the DB instance started and I can connect. But when i check the crs service status (crs_stat -t), the instance and service status are offline, nodeapps services are online. When i try to restart (crs_start) it throws up error.

View 3 Replies View Related

Services On Oracle RAC

Mar 24, 2011

I have a 2 node RAC database. I have a service defined as a preferred service for one node and Available for the other node. the service was relocated to the available node. I want to know when it failed over and why. Where would I get this information?

some time After the service failed over to the other node I got connection issues for this service. I relocated the service and the issues went away. Why did it not relocate the service back to the preferred node when these issues were encountered?

View 1 Replies View Related

PL/SQL :: How To Call Web Services

Oct 31, 2012

how to call web services from PL/SQL? Steps, pros and cons, etc....

View 8 Replies View Related

Using Services To Correlate Workloads To Instances In RAC

Jan 17, 2011

We have a new requirement for a RAC environment. Its workload will comprise both OLTP and batch loads. Am I right in thinking that I can map the appropriate applications to the required node using services, e.g.

Application 1 (OLTP) has node 1 as its preferred service node - so all OLTP trxs run through node 1
Application 2 (Batch) has node 2 as its preferred service node - so all batch trxs run through node 2

Both applications will have the other node for its available service to facilitate HA in an emergency.

Does that sound right? (or have I got it completely wrong!)

View 3 Replies View Related

Disable All The Services For Node D Temporarily?

Dec 28, 2010

There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..

View 1 Replies View Related

SQL & PL/SQL :: How To Consume Exposed Services Of Sharepoint

Mar 2, 2010

I have to create a spool file using pl/sql (Oracle 10g/Solaris environment) and then copy the file from solaris environment to sharepoint(windows machine) folder. How to implement this(copy to sharepoint ) in pl/sql.

View 8 Replies View Related

RAC & Failsafe :: Unable To Communicate With CRS Services

Sep 13, 2010

i have a problem with DATABASE i have 2 nodes where all application on Node2 are tunning properly

[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora....de1.gsd application ONLINE ONLINE node1
ora....de1.ons application ONLINE ONLINE node1
ora....de1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
[code]....

View 3 Replies View Related

Create Two Services In One Oracle Client?

Feb 10, 2011

I have to create the two services(SID) in the same orcale 10g home.

View 2 Replies View Related

PL/SQL :: How To Call Web Services From Oracle Database 10g

Nov 11, 2012

How can i call web services from oracle database 10g ?

View 3 Replies View Related

Dbconsole Missing In Startup And Services.msc?

Jun 27, 2013

I have download and installed the trial version of oracle 11g enterprise on windows 2008 r2 in vmware workstation. I couldn't see the database control in start up as my destination path c:oracleyourdatabaselocationdboc4jj2eeoc4j_DBConsole though I tried to open manually https://<localhost, ipaddress, domainname>:1158/em but its failed to open. I also tried to recreate the db using below commandemca -deconfig dbcontrol db -repos dropemca –config dbcontrol –repos createGot some info from below details:[URL]

NOTE: Moreover dbcontrol services missing in services.msc

View 4 Replies View Related

Services Not Registered With Static Listener?

Jun 11, 2013

what configurations I do the static listener shows no services.Here is my listener.ora

:SID_LIST_LISTENER =        (SID_LIST =                (SID_DESC =                        (GLOBAL_DBNAME=ELLISON9)                        (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)                        (SID_NAME=ELLISON9)                )        ) LISTENER11G =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1522))    )ADR_BASE_LISTENER = /u01/app/oracle My tnsnames.ora:ELLISON9 = 

[code]...

View 13 Replies View Related

Listener Does Not Currently Know Of Services Requested In Connect Descriptor

Oct 3, 2012

I am new to oracle DBA. I have just installed the oracle on centos. when i create the oracle database for the first time then listener created and worked sucessfully. but when i stop the listener and start again. I get message "Listener does not currently know of services requested in connect descriptor.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved