OraFAQ Forum: Server Administration » Using ASM first time

Home » RDBMS Server » Server Administration » Using ASM first time (11.2.0) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using ASM first time [message #562908]

Mon, 06 August 2012 15:19

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

First time guys, go easy.
I've created an ASM database and diskgroups, they are mounted:
SQL> select name, state from v$asm_diskgroup;

NAME STATE
------------------------------ -----------
DATA MOUNTED
FLASH MOUNTED

I can play around with this database, just trying to learn ASM, it's a play db.

I did the alter system commands to set asm and the controlfile to asm;

when I go into rman and issue this command:

RMAN> restore controlfile from 'D:\oradata\ORCQA08\CONTROL01.CTL';

Starting restore at 06-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/06/2012 16:17:07
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-19600: input file is control file (D:\ORADATA\ORCQA08\CONTROL01.CTL)
ORA-19601: output file is control file (+DATA)

So I googled and crs is running ok (no errors), my asm is started, the diskgroups are mounted, What else could it be? Right now I just want to move one small tablespace over to asm, later on I'll convert the entire db.

Report message to a moderator

Re: Using ASM first time [message #562930 is a reply to message #562908]

Tue, 07 August 2012 00:58

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-29701: unable to connect to Cluster Manager
 *Cause: Connect to CM failed or timed out.
 *Action: Verify that the CM was started.  If the CM was not started,
          start it and then retry the database startup. If the CM died
          or is not responding, check the Oracle and CM trace files for
          errors.

Is the cluster manager started?

crsctl check  cssd

Regards
Michel

Report message to a moderator

Re: Using ASM first time [message #562940 is a reply to message #562930]

Tue, 07 August 2012 01:29

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Or it could be permissions. Did you install Grid Infrastructure under the same OS account as the database? To what groups do the GI owner and the database owner belong?

Report message to a moderator

Re: Using ASM first time [message #562980 is a reply to message #562908]

Tue, 07 August 2012 07:17

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

Michael:

C:\Documents and Settings\imcsa_oracle>crsctl check cssd
Cluster Synchronization Services appears healthy

C:\Documents and Settings\imcsa_oracle>

So yes that's running.

Dave

Report message to a moderator

Re: Using ASM first time [message #563256 is a reply to message #562980]

Fri, 10 August 2012 09:34

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

OK, sorry for not answering, other priorities. Upon further investigation I see that my problem seems to have something to do with the Cluster Manager. The service is running, BUT if I run crsctl check crs, this is what i get:

C:\Documents and Settings\imcsa_oracle>crsctl check cssd
Cluster Synchronization Services appears healthy

C:\Documents and Settings\imcsa_oracle>crsctl check crs
Cluster Synchronization Services appears healthy
Cannot communicate with Cluster Ready Services
Cannot communicate with Event Manager

I've tried deleting the service and reinstalling it and get the same thing. I have 11.1 and 11.2 installed on this server, and the server is running Windows Server 2003 R2 64 bit.

The ASM instance is up, and I have a couple of diskgroups created. The problem is when I try to USE the diskgroups on another database.

TIA

Report message to a moderator

Re: Using ASM first time [message #563257 is a reply to message #563256]

Fri, 10 August 2012 09:43

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Are you aware of the compatibilties between the database software and the Grid Infrastructure software? When you say thisQuote:

I have 11.1 and 11.2 installed on this server

to which are you referring? You can't run an 11.2 database against 11.1 clusterware,is that what you are trying to do?

Report message to a moderator

Re: Using ASM first time [message #563260 is a reply to message #563257]

Fri, 10 August 2012 10:22

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

This might be the problem. I just checked and the services for css and asm are 11.1, the other database shows 11.2, and other the database from v$instance are showing 11.2.0.3. I'm going to recreate the asm instance .

Thanks I'll let you know.

Report message to a moderator

Re: Using ASM first time [message #563431 is a reply to message #563260]

Mon, 13 August 2012 15:17

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

ok, what I did today was to uninstall 11.1 and install 11.2.0.3 asm. I created the asm instance and when it starts it shows my diskgroups as mounted, and I can see them in the v$asm views.

But when I go to the other database and try: create tablespace testasm datafile size 10m; I get this error:
ERROR at line 1:
ORA-01119: error in creating database file '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges

I went to another database where I know asm is working and that exact syntax works fine. This version of oracle no longer has the crsctl, it's been depreciated.

Dave

Report message to a moderator

Re: Using ASM first time [message #563432 is a reply to message #563431]

Mon, 13 August 2012 15:34

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

When you say "install 11.2.0.3 asm" do you mean that you installed Grid Infrastructure, release 11.2.0.3? I do wonder what is going on, because crsctl is the main control utility for Grid Infrastructure, and if you don't have it, I wonder what you installed. Can you use copy/paste (formatting it with [code] tags)to show what you are doing when you say "when it starts it shows my diskgroups as mounted, and I can see them in the v$asm views"?

Report message to a moderator

Re: Using ASM first time [message #563434 is a reply to message #563432]

Mon, 13 August 2012 17:52

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

I do have crsctl, it's installed. Any suggestions on what to check? What I meant to say is I believe the problem is with the target database, not with the asm instance. I changed the db_create_file_dest to +DATA and the db_create_online_log_dest_1 to +FLASH. What am I missing?

This is from the asm instance, headings off.

SQL> l
1* select * from v$asm_diskgroup
SQL> /

1 DATA 512 4096
1048576 MOUNTED EXTERN 40000 39941 0
59 0 39941 0
11.2.0.0.0
10.1.0.0.0 N

2 FLASH 512 4096
1048576 MOUNTED EXTERN 30000 29948 0
52 0 29948 0
11.2.0.0.0
10.1.0.0.0 N

There's one diskgroup called DATA and another called FLASH.

ASMCMD> ls -l
State Type Rebal Name
MOUNTED EXTERN N DATA/
MOUNTED EXTERN N FLASH/
ASMCMD>

[Updated on: Mon, 13 August 2012 18:26]

Report message to a moderator

Re: Using ASM first time [message #563436 is a reply to message #563434]

Mon, 13 August 2012 18:32

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

I believe my problem is with the asm instance communicating with the database. I've changed the parameters on the target database, but I'm not able to use the asm file system. From the ASM instance, I see the diskgroups mounted and available, but when I try to use them I get the errors above.

Report message to a moderator

Re: Using ASM first time [message #563462 is a reply to message #563436]

Tue, 14 August 2012 01:09

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Part of your problem is that you don't answer questions that are intended to help with the diagnosis! Again, what did you install? And, also again, what OS account(s) did you use for installing the database home and the Grid Infrastructure home?
Check your version of RDBMS and ASM with

select * from v$version;

Parameters on the RDBMS instance are not relevant.
Lastly, before you copy/paste something, please read How to use [code] tags and make your code easier to read

Report message to a moderator

Re: Using ASM first time [message #563493 is a reply to message #563462]

Tue, 14 August 2012 07:40

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

OK I'll try to answer your questions and I DO appreciate you trying to help. Everything was installed and I'm using a oracle service account that has full admin rights on the server. Originally the server (which I inherited) had a 11.2.0.3 database with a 11.1 cluster and asm instance. The clusterware didn't work, when you had asked me to run crsctl check cssd, the output was that it wasn't working. So I decided to uninstall the 11.1.0 and install a grid instance of 11.2.0.3. It's a separate oracle_home. So now I have an 11.2.0.3 with a database that was restored using rman from another server, and I had an 11.2.0.3 with this oracle_home (E:\11.2.0\grid). The ASM instance was created, and I created diskgroups as well. From the ASM instance:


GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY                                       V
------------------------------------------------------------ -
           1 DATA                                   512       4096
             1048576 MOUNTED     EXTERN      40000      39941           0
          59                       0          39941             0

GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY                                       V
------------------------------------------------------------ -
11.2.0.0.0
10.1.0.0.0                                                   N


GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY                                       V
------------------------------------------------------------ -
           2 FLASH                                  512       4096
             1048576 MOUNTED     EXTERN      30000      29948           0
          52                       0          29948             0

GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    FREE_MB HOT_USED_MB
-------------------- ----------- ------ ---------- ---------- -----------
COLD_USED_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS
------------ ----------------------- -------------- -------------
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY                                       V
------------------------------------------------------------ -
11.2.0.0.0
10.1.0.0.0                                                   N

From the ASM Instance:

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL>

from the database instance:

SQL> select * from v$version;

BANNER
-------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

Report message to a moderator

Re: Using ASM first time [message #563499 is a reply to message #563493]

Tue, 14 August 2012 08:30

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Right, we know the versions of your products, and they are compatibile.
But we still don't know what you installed. When you installed Grid Infrastructure, you will have been prompted for this. What did you choose? Was it, for example, "Install and Configure Oracle Grid Infrastructure for a Cluster" ?
You say that both DB and GI were installed under the same OS account, but you will also have been prompted for operating system groups. When you installed the database home, what groups did you nominate for OSDBA and OSOPER? When you installed Grid Infrastructure, what groups did you choose for ASMDBA, ASMOPER, and ASMADMIN?

Report message to a moderator

Re: Using ASM first time [message #563504 is a reply to message #563499]

Tue, 14 August 2012 08:41

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

I believe (and I stated the installer up) that I installed, Install Oracle Grid Infrastructure Software Only.

Is there any log that will tell me that info for sure? I'm 99% sure it was that. The other choices are install and configure oracle grid infrastructure for a cluster (and I don't have a cluster in this install). Configure Oracle Grid Infrastructure for a standalone server, or upgrade oracle grid infrastructure or oracle ASM (and I wasn't upgrading).

[Updated on: Tue, 14 August 2012 08:44]

Report message to a moderator

Re: Using ASM first time [message #563506 is a reply to message #563504]

Tue, 14 August 2012 08:53

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

Found the install log:

Disk Space : required 4.5 GB available 5.11 GB
- Install Option : Install Oracle Grid Infrastructure Software Only
- Oracle base for Oracle Grid Infrastructure : e:\oracle
- Grid home : e:\11.2.0\grid
- Source Location : E:\p10404530_112030_MSWIN-x86-64_3of7\grid\install\..\stage\products.xml
--------------------------------------------------------------------------------

INFO: Completed executing action at state <showSummary>
INFO: Waiting for completion of background operations
INFO: Completed background operations
INFO: Moved to state <showSummary>
INFO: Waiting for

Report message to a moderator

Re: Using ASM first time [message #563508 is a reply to message #563506]

Tue, 14 August 2012 09:00

dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ

Member

John,

First of all THANK YOU for trying to help. I also had a ticket open with oracle and low and behold a miracle happened. It was the sqlnet.ora had to be set to:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

in both sqlnet.ora's. It now works.

THANKS AGAIN.

Report message to a moderator

Previous Topic:	vktm and dia0
Next Topic:	Creating tablespace in raw partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:46:49 CDT 2024