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'




Oracle Database

Avatar of undefined
Last Comment
mrjoltcola

8/22/2022 - Mon
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.
nobleit

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

expert did not under stand my point..
slightwv (䄆 Netminder)

What is your point of the question?    Maybe another Expert will understand later.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
nobleit

ASKER
fine..
slightwv (䄆 Netminder)

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?
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..

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
slightwv (䄆 Netminder)

>>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.
slightwv (䄆 Netminder)

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
mrjoltcola

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question