Link to home
Start Free TrialLog in
Avatar of nobleit
nobleit

asked on

error udump

[oracle@rac5 ~]$ export ORACLE_SID=+ASM
[oracle@rac5 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 10 15:46:13 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORA-07446: sdnfy: bad value '/u01/app/admin/+ASM/udump' for parameter user_dump_dest.
SQL>

Could you please me to resolve this issue..

+ASM.__db_cache_size=432013312
+ASM.__java_pool_size=4194304
+ASM.__large_pool_size=4194304
+ASM.__shared_pool_size=163577856
+ASM.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/+ASM/adump'
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/+ASM/control01.ctl','/u01/app/oracle/oradata/+ASM/control02.ctl','/u01/app/oracle/oradata/+ASM/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='+ASM'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=+ASMXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=201326592
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
*.core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/u01/app/oracle/admin/+ASM/udump'




Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>/u01/app/admin/+ASM/udump

I cannot say this enough:  just adding the + to file names does not mean you are running ASM.

ASM uses raw devices and not mounted file systems.  You cannot mix the two.


That said, sine you are specifying mounted filesystems and seem to be trying to create a SID of +ASM, did yu precreate the folder?

Still won't get you what you need but should remove this error.
Avatar of nobleit

ASKER

I've requested that this question be deleted for the following reason:

expert did not under stand my point..
What is your point of the question?    Maybe another Expert will understand later.
Avatar of nobleit

ASKER

fine..
You didn't answer my question:  what point didn't I get?

The error says there is a problem with the directory specified for the user_dump_dest parameter.  That almost always means the directory doesn't exist.

Based on all your other questions recently, you are trying to set up ASM.

To do this you need raw disks not folders in a mounted file system.

What point am I missing?
Avatar of nobleit

ASKER

I can answer these questions

I have two disk like this

[root@rac5 ~]# fdisk -l

Disk /dev/sda: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          25      200781   83  Linux
/dev/sda2              26        1300    10241437+  83  Linux
/dev/sda3            1301        1810     4096575   82  Linux swap / Solaris
/dev/sda4            1811        5221    27398857+   5  Extended
/dev/sda5            1811        2320     4096543+  83  Linux
/dev/sda6            2321        5221    23302251   83  Linux

Disk /dev/sdb: 12.8 GB, 12884901888 bytes
255 heads, 63 sectors/track, 1566 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        1566    12578863+  83  Linux
[root@rac5 ~]#


I created asm instance
 password file

only thing I am missing is the realtion ship between newly created disk and new instance..

I will demonstrate one more time


[root@rac5 ~]#  cat /etc/sysconfig/rawdevices
# raw device bindings
# format:  <rawdev> <major> <minor>
#          <rawdev> <blockdev>
# example: /dev/raw/raw1 /dev/sda1
#          /dev/raw/raw2 8 5
/dev/raw/raw1 /dev/sdb1
/dev/raw/raw1 /dev/sdb1
/dev/raw/raw1 /dev/sdb1
[root@rac5 ~]#


here is the init+ASM.ora

background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='SHARED'
user_dump_dest='/u01/app/oracle/admin/+ASM/udump'


I took off all the unwanted parameters what I did before..
only essential

[oracle@rac5 dbs]$ export ORACLE_SID=+ASM
[oracle@rac5 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 10 17:52:12 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup mount;
ORA-29701: unable to connect to Cluster Manager
SQL>

Now this is the error..

what did I not understand..

you can answer me where I am lagging..

>>ORA-29701: unable to connect to Cluster Manager

This is a different error than you posted previously.  Which problem do you wish to pursue?

You have had this error before in a previous question.

Error seems self-explanatory.  I think I provided a link about this in the previous question.  On mobile right now and cannot look through your other questions.

I suggest you Google around for that error number.  There were a few links on it if I remember correctly.
I have to apologize.  I think I gave you some bad advice on the first post.

I've not done much with ASM and thought everything had to be on raw devices.  It appears the bump folders can be on mounted disks but you need to let Oracle do it.

I forget what blog/link you are following but check out:

http://webcache.googleusercontent.com/search?q=cache:TUcGz2y9ex0J:blog.oracledb.net/5+oracle+ASM+user_dump_dest&cd=9&hl=en&ct=clnk&gl=us&source=www.google.com

ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial