Home » RDBMS Server » Server Administration » DB_DOMAIN (Oracle 10.2.0.4, Solaris 10)
DB_DOMAIN [message #350336] Wed, 24 September 2008 15:13 Go to next message
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 messageGo to next message
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...
startup pfile='<path>';
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
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system set db_domain='' scope=spfile;

and restart.

Regards
Michel
Previous Topic: Oracle 9i/10g installation Window Vista Home Premium SP 1 ???
Next Topic: Problem in Oracle® Database Patch Set Notes 10g Release 2 (10.2.0.3) Patch Set 2 for Linux x86
Goto Forum:
  


Current Time: Sat Dec 10 20:53:04 CST 2016

Total time taken to generate the page: 0.09829 seconds