DB_DOMAIN [message #350336] |
Wed, 24 September 2008 15:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
deepmachine
Messages: 80 Registered: August 2008 Location: United States
|
Member |
|
|
Hi,
How can I set my db_domain parameter to NULL?
Thanks in Advance.
|
|
|
Re: DB_DOMAIN [message #350393 is a reply to message #350336] |
Wed, 24 September 2008 22:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
deepmachine
Messages: 80 Registered: August 2008 Location: United States
|
Member |
|
|
First I tried using the following:
alter system set db_domain = ''; because in 10g (10.1.0.5) it is sysmodifiable, but it didn't work.
Then I ran the follwoing:
select issysmodifiable from v$parameter where name = 'db_domain'; ...to double check and figured out that its NOT SYSMODIFIABLE in 10g (10.2.0.4)
Now the only option that I think I have with my limited knowledge is to create a PFILE from SPFILE, shutdown the database and do a...
and then again create an SPFILE from PFILE.
What do you guys think?
Thanks in advance.
[Updated on: Wed, 24 September 2008 22:45] Report message to a moderator
|
|
|
Re: DB_DOMAIN [message #350399 is a reply to message #350336] |
Wed, 24 September 2008 23:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
alter system set db_domain='' scope=spfile;
and restart.
Regards
Michel
|
|
|