select instance_name from v$instance_name;

show parameter instance_name;

select name,value from v$parameter where name='instance_name';

显示的都是test,最早的spfile;

test.__db_cache_size=96468992
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__shared_pool_size=58720256
test.__streams_pool_size=0
*.audit_file_dest='D:oracleproduct10.2.0/admin/test/adump'
*.background_dump_dest='D:oracleproduct10.2.0/admin/test/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:oracleproduct10.2.0/oradata/test/control01.ctl','D:oracleproduct10.2.0/oradata/test/control02.ctl','D:oracleproduct10.2.0/oradata/test/control03.ctl'
*.core_dump_dest='D:oracleproduct10.2.0/admin/test/cdump'
*.db_block_size=8192
*.db_domain='orashell.com'
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='D:oracleproduct10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.job_queue_processes=10
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:oracleproduct10.2.0/admin/test/udump'

动态修改instance_name的值

alter system set instance_name=test10g scope=spfile;

shutdown immediate;

startup;

test.__db_cache_size=96468992
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__shared_pool_size=58720256
test.__streams_pool_size=0
*.audit_file_dest='D:oracleproduct10.2.0/admin/test/adump'
*.background_dump_dest='D:oracleproduct10.2.0/admin/test/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:oracleproduct10.2.0/oradata/test/control01.ctl','D:oracleproduct10.2.0/oradata/test/control02.ctl','D:oracleproduct10.2.0/oradata/test/control03.ctl'
*.core_dump_dest='D:oracleproduct10.2.0/admin/test/cdump'
*.db_block_size=8192
*.db_domain='orashell.com'
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='D:oracleproduct10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.instance_name='test10g' ---新的instance_name 的值
*.job_queue_processes=10
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:oracleproduct10.2.0/admin/test/udump'

select instance_name from v$instance_name; --显示test

都可以看到instance_name的值;

show parameter instance_name;

select name,value from v$parameter where name='instance_name';

现在显示的值为test10g;了.

这个是为什么呢?

这个参数又有什么用呢,是不是都不设置的啊.

那当spfile或者pfile 中没有设置instance_name的时候

这个值从那里来的呢?是系统默认设置和db_name一样

还是什么的啊.