OraFAQ Forum: Server Administration » DB

Home » RDBMS Server » Server Administration » DB_DOMAIN (Oracle 10.2.0.4, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB_DOMAIN [message #350336]

Wed, 24 September 2008 15:13

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Hi,
How can I set my db_domain parameter to NULL?

Thanks in Advance.

Report message to a moderator

Re: DB_DOMAIN [message #350393 is a reply to message #350336]

Wed, 24 September 2008 22:43

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter system set db_domain='' scope=spfile;

and restart.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 19:24:38 CST 2024