Home » RDBMS Server » Server Administration » How to change global name (Win XP + 10.2.0.1)
How to change global name [message #390523] Fri, 06 March 2009 23:41 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

log_archive_dest_state_8             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S_%R.%T
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
remote_archive_enable                string      true
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS
SQL> alter system set archive_lag_target=1800 scope=spfile;

System altered.

SQL> show parameter log

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1          string
db_create_online_log_dest_2          string
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S_%R.%T
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace                    integer     0
log_buffer                           integer     7024640
log_checkpoint_interval              integer     0
log_checkpoint_timeout               integer     1800
log_checkpoints_to_alert             boolean     FALSE
log_file_name_convert                string
logmnr_max_persistent_sessions       integer     1
remote_login_passwordfile            string      EXCLUSIVE
SQL>
SQL> alter system set log_archive_dest_1='location=(D:\ArchiveLog\KnbDb)' scope=spfile;

System altered.

SQL> startup force mount
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             167775108 bytes
Database Buffers          436207616 bytes
Redo Buffers                7135232 bytes
Database mounted.
SQL>
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:\ArchiveLog\KnbDb
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7
SQL>
SQL> alter system switch logfile;

System altered.

SQL>
SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
KNBDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL> alter database rename global_name KnbDb;
alter database rename global_name KnbDb
                                  *
ERROR at line 1:
ORA-00946: missing TO keyword


SQL> alter database rename global_name to KnbDb;

Database altered.

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
KNBDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL> show parameter global

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_context_pool_size             string
global_names                         boolean     FALSE
SQL>
SQL> alter system set global_names='true' scope=spfile;
alter system set global_names='true' scope=spfile
                              *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter system set global_names=true scope=spfile;

System altered.

SQL> show parameter job

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     10
SQL>
SQL> show parameter log_archive_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      location=(D:\ArchiveLog\KnbDb)
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S_%R.%T
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
SQL> alter system set log_archive_config='dg_config=('knbdb','rdb')' scope=spfile;
alter system set log_archive_config='dg_config=('knbdb','rdb')' scope=spfile
                                                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set log_archive_config='dg_config=('knbdb,rdb')' scope=spfile;
alter system set log_archive_config='dg_config=('knbdb,rdb')' scope=spfile
                                                 *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set log_archive_config='dg_config=(knbdb,rdb)' scope=spfile;

System altered.

SQL> show parameter open

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
open_links                           integer     4
open_links_per_instance              integer     4
read_only_open_delayed               boolean     FALSE
session_max_open_files               integer     10
SQL> alter syestm set open
  2  .
SQL> alter syestm set open_links = 10 scope=spfile;
alter syestm set open_links = 10 scope=spfile
      *
ERROR at line 1:
ORA-00940: invalid ALTER command


SQL> alter system set open_links = 10 scope=spfile;

System altered.

SQL> show parameter parallel

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback         string      LOW
parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     FALSE
parallel_execution_message_size      integer     2148
parallel_instance_group              string
parallel_max_servers                 integer     40
parallel_min_percent                 integer     0
parallel_min_servers                 integer     0
parallel_server                      boolean     FALSE
parallel_server_instances            integer     1
parallel_threads_per_cpu             integer     2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
recovery_parallelism                 integer     0
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     150
SQL>
SQL> startup force
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             171969412 bytes
Database Buffers          432013312 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL>
SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
KNBDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL> show parameter global

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_context_pool_size             string
global_names                         boolean     TRUE
SQL>
SQL> show parameter db_u

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      KnbDb
SQL>
SQL>
SQL> alter database rename global_name to 'knbdb';
alter database rename global_name to 'knbdb'
                                     *
ERROR at line 1:
ORA-01729: database link name expected


SQL> alter database rename global_name to knbdb;

Database altered.

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
KNBDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL>


Hello,

After renaming global name; it's showing only default name; what was the problem from my end. Please advice me

Babu
Re: How to change global name [message #390526 is a reply to message #390523] Fri, 06 March 2009 23:49 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
UPDATE GLOBAL_NAME SET = global_name 'knbdb';
COMMIT;
select * from global_name;

-- done as user SYS
-- do you really want name to be lower case? Just asking.
Re: How to change global name [message #390536 is a reply to message #390523] Sat, 07 March 2009 01:30 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Thanks..

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
KNBDB.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL>
SQL> update global_name set global_name='knbdb';

1 row updated.

SQL> commit;

Commit complete.

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
knbdb

SQL> alter database rename global_name to knbdb;

Database altered.

SQL>


Could you please explain me; why ALTER DATABASE command not working??
Re: How to change global name [message #390538 is a reply to message #390536] Sat, 07 March 2009 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
db_domain is not set.

Why are you popsting so useless information? Why are you posting invalid statement execution? Too much lines hide useful information.

Regards
Michel
Re: How to change global name [message #390539 is a reply to message #390538] Sat, 07 March 2009 02:10 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello Mr Mic,


SQL> show parameter db_domain

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string


Thanks for your feedback. Yes your correct db_domain missing; Thanks for catching..

Apologies for my posting; I try to Edit my session; but power outage and unable to edit my session information.

I was doing some streams implementation; Mistakenly I just post my session information.

Thank you in advance.

Babu
Re: How to change global name [message #390576 is a reply to message #390523] Sat, 07 March 2009 14:13 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>Could you please explain me; why ALTER DATABASE command not working??
What do you mean by "not working"?

For what it is worth, changing GLOBAL_NAME could break any previously defined database links.

[Updated on: Sat, 07 March 2009 17:18]

Report message to a moderator

Previous Topic: plz. help me out , oracle 10g database problem
Next Topic: Issue in running autoconfig in appsTier while cloning
Goto Forum:
  


Current Time: Wed Dec 07 18:14:32 CST 2016

Total time taken to generate the page: 0.11181 seconds