1 2 3 Previous Next 42 Replies Latest reply on Aug 14, 2009 4:10 AM by AnilSharma Go to original post
      • 16. Re: Error 1065 The database specified does not exist
        Hussein Sawwan-Oracle
        Anil,

        Usually, it is under $ORACLE_HOME/admin/<SID>/bdump directory.

        Regards,
        Hussein
        • 17. Re: Error 1065 The database specified does not exist
          AnilSharma
          This is some line of the files......

          f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=2
          DBW0 started with pid=3
          LGWR started with pid=4
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Wed Aug 12 22:09:09 2009
          alter database mount exclusive
          Wed Aug 12 22:09:13 2009
          Successful mount of redo thread 1, with mount id 248465221
          Wed Aug 12 22:09:13 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Wed Aug 12 22:09:13 2009
          alter database open
          Wed Aug 12 22:09:15 2009
          Beginning crash recovery of 1 threads
          Wed Aug 12 22:09:15 2009
          Started redo scan
          Wed Aug 12 22:09:31 2009
          Completed redo scan
          14275 redo blocks read, 275 data blocks need recovery
          Wed Aug 12 22:09:31 2009
          Started recovery at
          Thread 1: logseq 138, block 9906, scn 0.0
          Wed Aug 12 22:09:33 2009
          Recovery of Online Redo Log: Thread 1 Group 2 Seq 138 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG2.DBF
          Wed Aug 12 22:09:41 2009
          Completed redo application
          Wed Aug 12 22:09:41 2009
          Ended recovery at
          Thread 1: logseq 138, block 24181, scn 0.34390429
          275 data blocks read, 275 data blocks written, 14275 redo blocks read
          Crash recovery completed successfully
          Wed Aug 12 22:09:44 2009
          Thread 1 advanced to log sequence 139
          Thread 1 opened at log sequence 139
          Current log# 3 seq# 139 mem# 0: F:\ORACLE\VISDATA\LOG1.DBF
          Successful open of redo thread 1
          Wed Aug 12 22:09:46 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Wed Aug 12 22:09:46 2009
          SMON: enabling cache recovery
          Wed Aug 12 22:09:49 2009
          Successfully onlined Undo Tablespace 1.
          Wed Aug 12 22:09:49 2009
          SMON: enabling tx recovery
          Wed Aug 12 22:09:49 2009
          Database Characterset is UTF8
          Wed Aug 12 22:10:24 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open
          Wed Aug 12 23:03:03 2009
          Errors in file f:\oracle\visdb\9.2.0\admin\vis_ajay\udump\vis_ora_5356.trc:

          Wed Aug 12 23:03:03 2009
          Errors in file f:\oracle\visdb\9.2.0\admin\vis_ajay\udump\vis_ora_5384.trc:

          Wed Aug 12 23:03:03 2009
          Errors in file f:\oracle\visdb\9.2.0\admin\vis_ajay\udump\vis_ora_5588.trc:

          Wed Aug 12 23:03:05 2009
          Errors in file f:\oracle\visdb\9.2.0\admin\vis_ajay\udump\vis_ora_2692.trc:

          Wed Aug 12 23:03:05 2009
          Errors in file f:\oracle\visdb\9.2.0\admin\vis_ajay\udump\vis_ora_2504.trc:

          Dump file f:\oracle\visdb\9.2.0\admin\vis_ajay\bdump\alert_vis.log
          Thu Aug 13 13:05:26 2009
          ORACLE V9.2.0.6.0 - Production vsnsta=0
          vsnsql=12 vsnxtr=3
          Windows 2000 Version 5.2 Service Pack 1, CPU type 586
          Thu Aug 13 13:05:26 2009
          Starting ORACLE instance (normal)
          LICENSE_MAX_SESSION = 0
          LICENSE_SESSIONS_WARNING = 0
          SCN scheme 2
          Using log_archive_dest parameter default value
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up ORACLE RDBMS Version: 9.2.0.6.0.
          System parameters with non-default values:
          tracefiles_public = TRUE
          processes = 200
          sessions = 400
          timed_statistics = TRUE
          shared_pool_size = 301989888
          shared_pool_reserved_size= 30000000
          sharedpool_reserved_min_alloc= 4100
          java_pool_size = 58720256
          enqueue_resources = 32000
          nls_language = american
          nls_territory = america
          nls_sort = binary
          nls_date_format = DD-MON-RR
          nls_numeric_characters = .,
          nls_comp = binary
          nls_length_semantics = BYTE
          control_files = f:\oracle\visdata\cntrl01.dbf, f:\oracle\visdata\cntrl02.dbf, f:\oracle\visdata\cntrl03.dbf
          db_block_checksum = TRUE
          db_block_size = 8192
          db_cache_size = 167772160
          compatible = 9.2.0
          log_buffer = 10485760
          log_checkpoint_interval = 100000
          log_checkpoint_timeout = 1200
          db_files = 512
          db_file_multiblock_read_count= 8
          log_checkpoints_to_alert = TRUE
          dml_locks = 10000
          row_locking = always
          undo_management = AUTO
          undo_tablespace = APPS_UNDOTS1
          undo_suppress_errors = FALSE
          undo_retention = 1800
          db_block_checking = FALSE
          max_enabled_roles = 100
          O7_DICTIONARY_ACCESSIBILITY= FALSE
          remote_login_passwordfile= SHARED
          session_cached_cursors = 200
          utl_file_dir = c:\temp, c:\temp, f:\oracle\visdb\9.2.0\plsql\temp, f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=2
          DBW0 started with pid=3
          LGWR started with pid=4
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Thu Aug 13 13:05:35 2009
          alter database mount exclusive
          Thu Aug 13 13:05:39 2009
          Successful mount of redo thread 1, with mount id 248584031
          Thu Aug 13 13:05:39 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Thu Aug 13 13:05:39 2009
          alter database open
          Thu Aug 13 13:05:40 2009
          Beginning crash recovery of 1 threads
          Thu Aug 13 13:05:41 2009
          Started redo scan
          Thu Aug 13 13:05:41 2009
          Completed redo scan
          17226 redo blocks read, 336 data blocks need recovery
          Thu Aug 13 13:05:41 2009
          Started recovery at
          Thread 1: logseq 139, block 38101, scn 0.0
          Thu Aug 13 13:05:43 2009
          Recovery of Online Redo Log: Thread 1 Group 3 Seq 139 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG1.DBF
          Thu Aug 13 13:05:44 2009
          Completed redo application
          Thu Aug 13 13:05:44 2009
          Ended recovery at
          Thread 1: logseq 139, block 55327, scn 0.34480738
          336 data blocks read, 336 data blocks written, 17226 redo blocks read
          Crash recovery completed successfully
          Thu Aug 13 13:05:45 2009
          Thread 1 advanced to log sequence 140
          Thread 1 opened at log sequence 140
          Current log# 1 seq# 140 mem# 0: F:\ORACLE\VISDATA\LOG3.DBF
          Successful open of redo thread 1
          Thu Aug 13 13:05:45 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Thu Aug 13 13:05:45 2009
          SMON: enabling cache recovery
          Thu Aug 13 13:05:47 2009
          Successfully onlined Undo Tablespace 1.
          Thu Aug 13 13:05:47 2009
          SMON: enabling tx recovery
          Thu Aug 13 13:05:47 2009
          Database Characterset is UTF8
          Thu Aug 13 13:06:09 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open
          Dump file f:\oracle\visdb\9.2.0\admin\vis_ajay\bdump\alert_vis.log
          Thu Aug 13 15:25:11 2009
          ORACLE V9.2.0.6.0 - Production vsnsta=0
          vsnsql=12 vsnxtr=3
          Windows 2000 Version 5.2 Service Pack 1, CPU type 586
          Thu Aug 13 15:25:11 2009
          Starting ORACLE instance (normal)
          LICENSE_MAX_SESSION = 0
          LICENSE_SESSIONS_WARNING = 0
          SCN scheme 2
          Using log_archive_dest parameter default value
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up ORACLE RDBMS Version: 9.2.0.6.0.
          System parameters with non-default values:
          tracefiles_public = TRUE
          processes = 200
          sessions = 400
          timed_statistics = TRUE
          shared_pool_size = 301989888
          shared_pool_reserved_size= 30000000
          sharedpool_reserved_min_alloc= 4100
          java_pool_size = 58720256
          enqueue_resources = 32000
          nls_language = american
          nls_territory = america
          nls_sort = binary
          nls_date_format = DD-MON-RR
          nls_numeric_characters = .,
          nls_comp = binary
          nls_length_semantics = BYTE
          control_files = f:\oracle\visdata\cntrl01.dbf, f:\oracle\visdata\cntrl02.dbf, f:\oracle\visdata\cntrl03.dbf
          db_block_checksum = TRUE
          db_block_size = 8192
          db_cache_size = 167772160
          compatible = 9.2.0
          log_buffer = 10485760
          log_checkpoint_interval = 100000
          log_checkpoint_timeout = 1200
          db_files = 512
          db_file_multiblock_read_count= 8
          log_checkpoints_to_alert = TRUE
          dml_locks = 10000
          row_locking = always
          undo_management = AUTO
          undo_tablespace = APPS_UNDOTS1
          undo_suppress_errors = FALSE
          undo_retention = 1800
          db_block_checking = FALSE
          max_enabled_roles = 100
          O7_DICTIONARY_ACCESSIBILITY= FALSE
          remote_login_passwordfile= SHARED
          session_cached_cursors = 200
          utl_file_dir = c:\temp, c:\temp, f:\oracle\visdb\9.2.0\plsql\temp, f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=3
          DBW0 started with pid=4
          LGWR started with pid=2
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Thu Aug 13 15:25:16 2009
          alter database mount exclusive
          Thu Aug 13 15:25:20 2009
          Successful mount of redo thread 1, with mount id 248558620
          Thu Aug 13 15:25:20 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Thu Aug 13 15:25:20 2009
          alter database open
          Thu Aug 13 15:25:21 2009
          Beginning crash recovery of 1 threads
          Thu Aug 13 15:25:22 2009
          Started redo scan
          Thu Aug 13 15:25:22 2009
          Completed redo scan
          14313 redo blocks read, 209 data blocks need recovery
          Thu Aug 13 15:25:22 2009
          Started recovery at
          Thread 1: logseq 140, block 18662, scn 0.0
          Thu Aug 13 15:25:25 2009
          Recovery of Online Redo Log: Thread 1 Group 1 Seq 140 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG3.DBF
          Thu Aug 13 15:25:25 2009
          Completed redo application
          Thu Aug 13 15:25:25 2009
          Ended recovery at
          Thread 1: logseq 140, block 32975, scn 0.34554646
          209 data blocks read, 208 data blocks written, 14313 redo blocks read
          Crash recovery completed successfully
          Thu Aug 13 15:25:27 2009
          Thread 1 advanced to log sequence 141
          Thread 1 opened at log sequence 141
          Current log# 2 seq# 141 mem# 0: F:\ORACLE\VISDATA\LOG2.DBF
          Successful open of redo thread 1
          Thu Aug 13 15:25:27 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Thu Aug 13 15:25:27 2009
          SMON: enabling cache recovery
          Thu Aug 13 15:25:28 2009
          Successfully onlined Undo Tablespace 1.
          Thu Aug 13 15:25:28 2009
          SMON: enabling tx recovery
          Thu Aug 13 15:25:28 2009
          Database Characterset is UTF8
          Thu Aug 13 15:25:51 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open
          Dump file f:\oracle\visdb\9.2.0\admin\vis_ajay\bdump\alert_vis.log
          Thu Aug 13 18:58:52 2009
          ORACLE V9.2.0.6.0 - Production vsnsta=0
          vsnsql=12 vsnxtr=3
          Windows 2000 Version 5.2 Service Pack 1, CPU type 586
          Thu Aug 13 18:58:52 2009
          Starting ORACLE instance (normal)
          LICENSE_MAX_SESSION = 0
          LICENSE_SESSIONS_WARNING = 0
          SCN scheme 2
          Using log_archive_dest parameter default value
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up ORACLE RDBMS Version: 9.2.0.6.0.
          System parameters with non-default values:
          tracefiles_public = TRUE
          processes = 200
          sessions = 400
          timed_statistics = TRUE
          shared_pool_size = 301989888
          shared_pool_reserved_size= 30000000
          sharedpool_reserved_min_alloc= 4100
          java_pool_size = 58720256
          enqueue_resources = 32000
          nls_language = american
          nls_territory = america
          nls_sort = binary
          nls_date_format = DD-MON-RR
          nls_numeric_characters = .,
          nls_comp = binary
          nls_length_semantics = BYTE
          control_files = f:\oracle\visdata\cntrl01.dbf, f:\oracle\visdata\cntrl02.dbf, f:\oracle\visdata\cntrl03.dbf
          db_block_checksum = TRUE
          db_block_size = 8192
          db_cache_size = 167772160
          compatible = 9.2.0
          log_buffer = 10485760
          log_checkpoint_interval = 100000
          log_checkpoint_timeout = 1200
          db_files = 512
          db_file_multiblock_read_count= 8
          log_checkpoints_to_alert = TRUE
          dml_locks = 10000
          row_locking = always
          undo_management = AUTO
          undo_tablespace = APPS_UNDOTS1
          undo_suppress_errors = FALSE
          undo_retention = 1800
          db_block_checking = FALSE
          max_enabled_roles = 100
          O7_DICTIONARY_ACCESSIBILITY= FALSE
          remote_login_passwordfile= SHARED
          session_cached_cursors = 200
          utl_file_dir = c:\temp, c:\temp, f:\oracle\visdb\9.2.0\plsql\temp, f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=2
          DBW0 started with pid=3
          LGWR started with pid=4
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Thu Aug 13 18:58:58 2009
          alter database mount exclusive
          Thu Aug 13 18:59:02 2009
          Successful mount of redo thread 1, with mount id 248575282
          Thu Aug 13 18:59:02 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Thu Aug 13 18:59:02 2009
          alter database open
          Thu Aug 13 18:59:04 2009
          Beginning crash recovery of 1 threads
          Thu Aug 13 18:59:04 2009
          Started redo scan
          Thu Aug 13 18:59:16 2009
          Completed redo scan
          14166 redo blocks read, 234 data blocks need recovery
          Thu Aug 13 18:59:16 2009
          Started recovery at
          Thread 1: logseq 141, block 33497, scn 0.0
          Thu Aug 13 18:59:18 2009
          Recovery of Online Redo Log: Thread 1 Group 2 Seq 141 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG2.DBF
          Thu Aug 13 18:59:25 2009
          Completed redo application
          Thu Aug 13 18:59:25 2009
          Ended recovery at
          Thread 1: logseq 141, block 47663, scn 0.34644685
          234 data blocks read, 234 data blocks written, 14166 redo blocks read
          Crash recovery completed successfully
          Thu Aug 13 18:59:28 2009
          Thread 1 advanced to log sequence 142
          Thread 1 opened at log sequence 142
          Current log# 3 seq# 142 mem# 0: F:\ORACLE\VISDATA\LOG1.DBF
          Successful open of redo thread 1
          Thu Aug 13 18:59:28 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Thu Aug 13 18:59:29 2009
          SMON: enabling cache recovery
          Thu Aug 13 18:59:31 2009
          Successfully onlined Undo Tablespace 1.
          Thu Aug 13 18:59:31 2009
          SMON: enabling tx recovery
          Thu Aug 13 18:59:31 2009
          Database Characterset is UTF8
          Thu Aug 13 19:00:08 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open
          Dump file f:\oracle\visdb\9.2.0\admin\vis_ajay\bdump\alert_vis.log
          Thu Aug 13 21:19:38 2009
          ORACLE V9.2.0.6.0 - Production vsnsta=0
          vsnsql=12 vsnxtr=3
          Windows 2000 Version 5.2 Service Pack 1, CPU type 586
          Thu Aug 13 21:19:38 2009
          Starting ORACLE instance (normal)
          LICENSE_MAX_SESSION = 0
          LICENSE_SESSIONS_WARNING = 0
          SCN scheme 2
          Using log_archive_dest parameter default value
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up ORACLE RDBMS Version: 9.2.0.6.0.
          System parameters with non-default values:
          tracefiles_public = TRUE
          processes = 200
          sessions = 400
          timed_statistics = TRUE
          shared_pool_size = 301989888
          shared_pool_reserved_size= 30000000
          sharedpool_reserved_min_alloc= 4100
          java_pool_size = 58720256
          enqueue_resources = 32000
          nls_language = american
          nls_territory = america
          nls_sort = binary
          nls_date_format = DD-MON-RR
          nls_numeric_characters = .,
          nls_comp = binary
          nls_length_semantics = BYTE
          control_files = f:\oracle\visdata\cntrl01.dbf, f:\oracle\visdata\cntrl02.dbf, f:\oracle\visdata\cntrl03.dbf
          db_block_checksum = TRUE
          db_block_size = 8192
          db_cache_size = 167772160
          compatible = 9.2.0
          log_buffer = 10485760
          log_checkpoint_interval = 100000
          log_checkpoint_timeout = 1200
          db_files = 512
          db_file_multiblock_read_count= 8
          log_checkpoints_to_alert = TRUE
          dml_locks = 10000
          row_locking = always
          undo_management = AUTO
          undo_tablespace = APPS_UNDOTS1
          undo_suppress_errors = FALSE
          undo_retention = 1800
          db_block_checking = FALSE
          max_enabled_roles = 100
          O7_DICTIONARY_ACCESSIBILITY= FALSE
          remote_login_passwordfile= SHARED
          session_cached_cursors = 200
          utl_file_dir = c:\temp, c:\temp, f:\oracle\visdb\9.2.0\plsql\temp, f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=2
          DBW0 started with pid=3
          LGWR started with pid=4
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Thu Aug 13 21:19:49 2009
          alter database mount exclusive
          Thu Aug 13 21:19:53 2009
          Successful mount of redo thread 1, with mount id 248652341
          Thu Aug 13 21:19:53 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Thu Aug 13 21:19:53 2009
          alter database open
          Thu Aug 13 21:19:54 2009
          Beginning crash recovery of 1 threads
          Thu Aug 13 21:19:54 2009
          Started redo scan
          Thu Aug 13 21:19:55 2009
          Completed redo scan
          14342 redo blocks read, 239 data blocks need recovery
          Thu Aug 13 21:19:55 2009
          Started recovery at
          Thread 1: logseq 142, block 20901, scn 0.0
          Thu Aug 13 21:19:55 2009
          Recovery of Online Redo Log: Thread 1 Group 3 Seq 142 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG1.DBF
          Thu Aug 13 21:19:56 2009
          Completed redo application
          Thu Aug 13 21:19:56 2009
          Ended recovery at
          Thread 1: logseq 142, block 35243, scn 0.34720408
          239 data blocks read, 239 data blocks written, 14342 redo blocks read
          Crash recovery completed successfully
          Thu Aug 13 21:19:56 2009
          Thread 1 advanced to log sequence 143
          Thread 1 opened at log sequence 143
          Current log# 1 seq# 143 mem# 0: F:\ORACLE\VISDATA\LOG3.DBF
          Successful open of redo thread 1
          Thu Aug 13 21:19:57 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Thu Aug 13 21:19:57 2009
          SMON: enabling cache recovery
          Thu Aug 13 21:19:58 2009
          Successfully onlined Undo Tablespace 1.
          Thu Aug 13 21:19:58 2009
          SMON: enabling tx recovery
          Thu Aug 13 21:19:58 2009
          Database Characterset is UTF8
          Thu Aug 13 21:20:13 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open
          Dump file f:\oracle\visdb\9.2.0\admin\vis_ajay\bdump\alert_vis.log
          Thu Aug 13 22:11:33 2009
          ORACLE V9.2.0.6.0 - Production vsnsta=0
          vsnsql=12 vsnxtr=3
          Windows 2000 Version 5.2 Service Pack 1, CPU type 586
          Thu Aug 13 22:11:33 2009
          Starting ORACLE instance (normal)
          LICENSE_MAX_SESSION = 0
          LICENSE_SESSIONS_WARNING = 0
          SCN scheme 2
          Using log_archive_dest parameter default value
          LICENSE_MAX_USERS = 0
          SYS auditing is disabled
          Starting up ORACLE RDBMS Version: 9.2.0.6.0.
          System parameters with non-default values:
          tracefiles_public = TRUE
          processes = 200
          sessions = 400
          timed_statistics = TRUE
          shared_pool_size = 301989888
          shared_pool_reserved_size= 30000000
          sharedpool_reserved_min_alloc= 4100
          java_pool_size = 58720256
          enqueue_resources = 32000
          nls_language = american
          nls_territory = america
          nls_sort = binary
          nls_date_format = DD-MON-RR
          nls_numeric_characters = .,
          nls_comp = binary
          nls_length_semantics = BYTE
          control_files = f:\oracle\visdata\cntrl01.dbf, f:\oracle\visdata\cntrl02.dbf, f:\oracle\visdata\cntrl03.dbf
          db_block_checksum = TRUE
          db_block_size = 8192
          db_cache_size = 167772160
          compatible = 9.2.0
          log_buffer = 10485760
          log_checkpoint_interval = 100000
          log_checkpoint_timeout = 1200
          db_files = 512
          db_file_multiblock_read_count= 8
          log_checkpoints_to_alert = TRUE
          dml_locks = 10000
          row_locking = always
          undo_management = AUTO
          undo_tablespace = APPS_UNDOTS1
          undo_suppress_errors = FALSE
          undo_retention = 1800
          db_block_checking = FALSE
          max_enabled_roles = 100
          O7_DICTIONARY_ACCESSIBILITY= FALSE
          remote_login_passwordfile= SHARED
          session_cached_cursors = 200
          utl_file_dir = c:\temp, c:\temp, f:\oracle\visdb\9.2.0\plsql\temp, f:\oracle\visdb\9.2.0\appsutil\outbound\VIS_ajay, c:\temp
          job_queue_processes = 2
          systemtrig_enabled = TRUE
          cursor_sharing = EXACT
          parallel_min_servers = 0
          parallel_max_servers = 8
          background_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\bdump
          user_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\udump
          max_dump_file_size = 20480
          core_dump_dest = f:\oracle\visdb\9.2.0\admin\VIS_ajay\cdump
          optimizer_features_enable= 9.2.0
          db_name = VIS
          open_cursors = 600
          ifile = f:\oracle\visdb\9.2.0\dbs\VIS_ajay_ifile.ora
          sql_trace = FALSE
          sortelimination_cost_ratio= 5
          btree_bitmap_plans = FALSE
          fastfull_scan_enabled = FALSE
          optimizer_max_permutations= 2000
          query_rewrite_enabled = true
          indexjoin_enabled = FALSE
          sqlexecprogression_cost= 2147483647
          likewith_bind_as_equality= TRUE
          pga_aggregate_target = 1073741824
          workarea_size_policy = AUTO
          aq_tm_processes = 1
          olap_page_pool_size = 4194304
          PMON started with pid=2
          DBW0 started with pid=3
          LGWR started with pid=4
          CKPT started with pid=5
          SMON started with pid=6
          RECO started with pid=7
          CJQ0 started with pid=8
          QMN0 started with pid=9
          Thu Aug 13 22:11:44 2009
          alter database mount exclusive
          Thu Aug 13 22:11:48 2009
          Successful mount of redo thread 1, with mount id 248593504
          Thu Aug 13 22:11:48 2009
          Database mounted in Exclusive Mode.
          Completed: alter database mount exclusive
          Thu Aug 13 22:11:48 2009
          alter database open
          Thu Aug 13 22:11:49 2009
          Beginning crash recovery of 1 threads
          Thu Aug 13 22:11:49 2009
          Started redo scan
          Thu Aug 13 22:11:50 2009
          Completed redo scan
          14431 redo blocks read, 247 data blocks need recovery
          Thu Aug 13 22:11:50 2009
          Started recovery at
          Thread 1: logseq 143, block 22658, scn 0.0
          Thu Aug 13 22:11:51 2009
          Recovery of Online Redo Log: Thread 1 Group 1 Seq 143 Reading mem 0
          Mem# 0 errs 0: F:\ORACLE\VISDATA\LOG3.DBF
          Thu Aug 13 22:11:52 2009
          Completed redo application
          Thu Aug 13 22:11:52 2009
          Ended recovery at
          Thread 1: logseq 143, block 37089, scn 0.34798484
          247 data blocks read, 247 data blocks written, 14431 redo blocks read
          Crash recovery completed successfully
          Thu Aug 13 22:11:53 2009
          Thread 1 advanced to log sequence 144
          Thread 1 opened at log sequence 144
          Current log# 2 seq# 144 mem# 0: F:\ORACLE\VISDATA\LOG2.DBF
          Successful open of redo thread 1
          Thu Aug 13 22:11:53 2009
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          Thu Aug 13 22:11:53 2009
          SMON: enabling cache recovery
          Thu Aug 13 22:11:54 2009
          Successfully onlined Undo Tablespace 1.
          Thu Aug 13 22:11:54 2009
          SMON: enabling tx recovery
          Thu Aug 13 22:11:54 2009
          Database Characterset is UTF8
          Thu Aug 13 22:12:08 2009
          replication_dependency_tracking turned off (no async multimaster replication found)
          Completed: alter database open


          Thanks
          --Anil                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 18. Re: Error 1065 The database specified does not exist
            Hussein Sawwan-Oracle
            Anil,
            Completed: alter database open
            You can ignore those errors as the log file shows that the database is open. Now, you just need to verify that the database listener is also up.

            To connect to the database, please open a new DOS session, and run the database env file (<SID>_<hostname>.cmd) under %ORACLE_HOME%, then issue "sqlplus apps/apps".

            Regards,
            Hussein
            • 19. Re: Error 1065 The database specified does not exist
              AnilSharma
              Hussein,

              Thanks for your support.

              Run the script

              Getting Error: ORA 12547: TNS: lost contact

              and again asking for user-name:

              When I enter then same error.

              Thanks
              --Anil                                                                                                                                                                                                                                                                                                                                                                                       
              • 20. Re: Error 1065 The database specified does not exist
                Hussein Sawwan-Oracle
                Anil,

                ORA-12547 is a common error and requires some troubleshooting (Note: 555565.1 - Troubleshooting ORA - 12547 TNS LOST CONTACT).

                Are you able to run AutoConfig on the database tier node?

                Regards,
                Hussein
                • 21. Re: Error 1065 The database specified does not exist
                  AnilSharma
                  Hussein,

                  How to run AutoConfig

                  Thanks
                  --Anil                                                                                                                                                                                                               
                  • 22. Re: Error 1065 The database specified does not exist
                    Hussein Sawwan-Oracle
                    Anil,

                    Source the database env file (as shows above), and run adautocfg.cmd script under $ORACLE_HOME/appsutil/scripts/<SID>_<hostname> directory.

                    Regards,
                    Hussein
                    • 23. Re: Error 1065 The database specified does not exist
                      AnilSharma
                      Hussein,

                      .
                      Starting up AutoConfig engine...
                      .
                      Fri 08/14/2009
                      12:19 AM
                      Enter the APPS user password: apps

                      AutoConfig is configuring the Database environment...

                      AutoConfig will consider the custom templates if present.
                      Using ORACLE_HOME location : f:\oracle\visdb\9.2.0
                      Classpath : f:\oracle\visdb\9.2.0\jre\1.4.2\lib\rt.jar
                      ;f:\oracle\visdb\9.2.0\jdbc\lib\ojdbc14.jar;f:\oracle\visdb\9.2.0\appsutil\java\
                      xmlparserv2.zip;f:\oracle\visdb\9.2.0\appsutil\java;f:\oracle\visdb\9.2.0\jlib\n
                      etcfg.jar

                      Using Context file : F:\oracle\visdb\9.2.0\appsutil\VIS_ajay.xm
                      l

                      Context Value Management will now update the Context file
                      Error loading native library: oranjni9.dll.

                      Updating Context file...COMPLETED

                      Attempting upload of Context file and templates to database...COMPLETED

                      Context Value Management Complete. Check Logs for details
                      Updating rdbms version in Context file to db920
                      Updating rdbms type in Context file to 32 bits
                      Configuring templates from ORACLE_HOME ...


                      Thanks
                      --Anil                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                      • 24. Re: Error 1065 The database specified does not exist
                        AnilSharma
                        After running the AutoConfig I am now able to login through SQL * plus.

                        But not able to login to application. Error Page not found

                        Concurrent manager is now started.

                        Hussein Is it OK of run the Autoconfig????

                        Thanks
                        --Anil                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                        • 25. Re: Error 1065 The database specified does not exist
                          Hussein Sawwan-Oracle
                          Anil,
                          Hussein Is it OK of run the Autoconfig????
                          Yes please, run AutoConfig on the application tier (stop the application services first and just keep the database and the database listener up and running). AutoConfig script at the application tier can be found at %COMMON_TOP%\admin\scripts\<SID>_<hostname> directory.

                          Regards,
                          Hussein
                          • 26. Re: Error 1065 The database specified does not exist
                            AnilSharma
                            After running the AutoConfig I am now able to login through SQL * plus.

                            But not able to login to application. Error Page not found

                            Concurrent manager is now started.
                            • 27. Re: Error 1065 The database specified does not exist
                              Hussein Sawwan-Oracle
                              Anil,

                              Please see my previous reply.

                              Regards,
                              Hussein
                              • 28. Re: Error 1065 The database specified does not exist
                                AnilSharma
                                Hussein,

                                stop the application services first....

                                Can you specify more....

                                Thanks
                                --Anil                                                                                                                                                                                                   
                                • 29. Re: Error 1065 The database specified does not exist
                                  Hussein Sawwan-Oracle
                                  Anil,

                                  Just keep the database and the database listener services up, and shutdown the application services (Apache, Forms, CM, Application listener).

                                  Regards,
                                  Hussein