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=43201 3312
+ASM.__java_pool_size=4194 304
+ASM.__large_pool_size=419 4304
+ASM.__shared_pool_size=16 3577856
+ASM.__streams_pool_size=0
*.audit_file_dest='/u01/ap p/oracle/a dmin/+ASM/ adump'
*.background_dump_dest='/u 01/app/ora cle/admin/ +ASM/bdump '
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/ oracle/ora data/+ASM/ control01. ctl','/u01 /app/oracl e/oradata/ +ASM/contr ol02.ctl', '/u01/app/ oracle/ora data/+ASM/ control03. ctl'
*.core_dump_dest='/u01/app /oracle/ad min/+ASM/c dump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_ count=16
*.db_name='+ASM'
*.db_recovery_file_dest='/ u01/app/or acle/flash _recovery_ area'
*.db_recovery_file_dest_si ze=2147483 648
*.dispatchers='(PROTOCOL=T CP) (SERVICE=+ASMXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=201 326592
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.background_dump_dest='/u 01/app/ora cle/admin/ +ASM/bdump '
*.core_dump_dest='/u01/app /oracle/ad min/+ASM/c dump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfil e='SHARED'
*.user_dump_dest='/u01/app /oracle/ad min/+ASM/u dump'
[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
SQL>
Could you please me to resolve this issue..
+ASM.__db_cache_size=43201
+ASM.__java_pool_size=4194
+ASM.__large_pool_size=419
+ASM.__shared_pool_size=16
+ASM.__streams_pool_size=0
*.audit_file_dest='/u01/ap
*.background_dump_dest='/u
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/
*.core_dump_dest='/u01/app
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_
*.db_name='+ASM'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.dispatchers='(PROTOCOL=T
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=201
*.processes=150
*.remote_login_passwordfil
*.background_dump_dest='/u
*.core_dump_dest='/u01/app
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfil
*.user_dump_dest='/u01/app
ASKER
I've requested that this question be deleted for the following reason:
expert did not under stand my point..
expert did not under stand my point..
What is your point of the question? Maybe another Expert will understand later.
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?
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?
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/oracl e/admin/+A SM/bdump'
core_dump_dest='/u01/app/o racle/admi n/+ASM/cdu mp'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile= 'SHARED'
user_dump_dest='/u01/app/o racle/admi n/+ASM/udu mp'
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..
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
core_dump_dest='/u01/app/o
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile=
user_dump_dest='/u01/app/o
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.