菜鸟级的问题 Oracle9.2 Redhat 9.0

Question

如果喜欢看原版的，注册一个otn，到oracle的网站上下。中文版的到网上有好多，http://www.mycodes.net

Answer 1

hr用户在默认情况下是锁定的，所以你要先用sys进行登陆，对hr用户进行解锁：
alter user hr identified by hr account unlock;之后就可以使用conn hr/hr@servic_id进行登陆了

Answer 2

hr用户在安装的时候就已经解锁的了请问：SQL> connect username/ password@connect_identifier这个connection_idetifier应该是什么？我在安装的时候db_name和sid都是 db01, 
是否我的connection_idetifier就是db01呢？

Answer 3

我的spfile为什么是这个样子？
                                                                             ˜  6íþ                                                                                                                                                                                                                                                                                                                                                                                                                                        *.aq_tm_processes=1
*.background_dump_dest='/opt/ora9/admin/db01/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/ora9/oradata/db01/control01.ctl','/opt/ora9/oradata/db01/control02.ctl','/opt/ora9/oradata/db01/control03.ctl'
*.core_dump_dest='/opt/ora9/admin/db01/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='db01'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='db01'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/ora9/admin/db01/udump'