22. oktober 2007 - 15:05Der er
55 kommentarer og 1 løsning
Oracle går død efter genstart
Hej, hver gang jeg genstarter server, 2003 server, med oracle enterprise db - 10g- på, går databasen ned med en fejl som nedenstående.. Jeg har prøvet at formattere og lave en frisk install men samme resultat. Hvis jeg tilføjer en ny database virker den igen, lige indtil server bliver genstarter.. hvad i alverden er problemet??
DB er installeret på C-drevet. På en ms 2003 server. Oracle v. 10g
Fejl: Database Instance Host privat-rhm6o5w8.opgaveserver.dk Port 1521 SID opgaveserver Oracle Home C:\oracle\product\10.2.0\db_1
Listener Status Up Host privat-rhm6o5w8.opgaveserver.dk Port 1521
Name LISTENER Oracle Home C:\oracle\product\10.2.0\db_1 Location C:\oracle\product\10.2.0\db_1\network\admin
Agent Connection to Instance Status Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
Check at din database er sat til at starte automatisk når din service er startet. Gøres ved at starte regedit og gå til HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<homenavn> og finde den key der hedder ORA_opgaveserver_AUTOSTART - check at den står til true
Synes godt om
Slettet bruger
22. oktober 2007 - 15:15#3
hej, tak for svar.. alle services er starter, og sat til autostart
Den hedder nok alert_opgaveserver.log - så søg efter det. Filen ligger i det directory som du har sat background_dump_dest til.
Synes godt om
Slettet bruger
22. oktober 2007 - 15:29#7
det må være noget default.. mindes det i hvert fald ikke :)
Synes godt om
Slettet bruger
22. oktober 2007 - 15:30#8
Dump file c:\oracle\product\10.2.0/admin/opgaveserver/bdump\alert_opgaveserver.log Mon Oct 22 14:33:37 2007 ORACLE V10.2.0.1.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows Server 2003 Version V5.2 Service Pack 2 CPU : 1 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:1459M/2047M, Ph+PgF:3481M/3947M, VA:1928M/2047M Mon Oct 22 14:33:37 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.1.0. System parameters with non-default values: processes = 150 sga_target = 612368384 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=opgaveserverXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\CDUMP db_name = opgavese db_unique_name = opgaveserver open_cursors = 300 pga_aggregate_target = 203423744 PMON started with pid=2, OS id=2516 PSP0 started with pid=3, OS id=3808 MMAN started with pid=4, OS id=1840 DBW0 started with pid=5, OS id=3140 LGWR started with pid=6, OS id=240 CKPT started with pid=7, OS id=2960 SMON started with pid=8, OS id=3828 RECO started with pid=9, OS id=3880 CJQ0 started with pid=10, OS id=1032 MMON started with pid=11, OS id=1740 MMNL started with pid=12, OS id=2084 Mon Oct 22 14:33:37 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Mon Oct 22 14:33:43 2007 The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format. Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\USERS01.DBF. Elapsed time: 0:00:04 checkpoint is 534906 Mon Oct 22 14:34:00 2007 Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\UNDOTBS01.DBF. Elapsed time: 0:00:16 checkpoint is 534906 Mon Oct 22 14:35:26 2007 Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\SYSAUX01.DBF. Elapsed time: 0:01:42 checkpoint is 534906 Mon Oct 22 14:36:32 2007 Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\SYSTEM01.DBF. Elapsed time: 0:02:49 checkpoint is 534906 Mon Oct 22 14:36:33 2007 Create controlfile reuse set database "opgavese" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo03.log') SIZE 51200K RESETLOGS WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Setting recovery target incarnation to 1 Mon Oct 22 14:36:37 2007 Successful mount of redo thread 1, with mount id 3391582385 Mon Oct 22 14:36:37 2007 Completed: Create controlfile reuse set database "opgavese" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo03.log') SIZE 51200K RESETLOGS Shutting down instance: further logons disabled Mon Oct 22 14:36:37 2007 Stopping background process CJQ0 Mon Oct 22 14:36:37 2007 Stopping background process MMNL Mon Oct 22 14:36:39 2007 Stopping background process MMON Mon Oct 22 14:36:40 2007 Shutting down instance (immediate) License high water mark = 1 Mon Oct 22 14:36:40 2007 Stopping Job queue slave processes Mon Oct 22 14:36:40 2007 Job queue slave processes stopped Waiting for dispatcher 'D000' to shutdown All dispatchers and shared servers shutdown Mon Oct 22 14:36:42 2007 ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Mon Oct 22 14:36:42 2007 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Oct 22 14:36:44 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.1.0. System parameters with non-default values: processes = 150 sga_target = 612368384 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size= 2147483648 _no_recovery_through_resetlogs= TRUE undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=opgaveserverXDB) audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\CDUMP db_name = opgavese db_unique_name = opgaveserver open_cursors = 300 pga_aggregate_target = 203423744 PMON started with pid=2, OS id=436 PSP0 started with pid=3, OS id=1720 MMAN started with pid=4, OS id=3300 DBW0 started with pid=5, OS id=2460 LGWR started with pid=6, OS id=3568 CKPT started with pid=7, OS id=1908 SMON started with pid=8, OS id=2544 RECO started with pid=9, OS id=2280 MMON started with pid=10, OS id=2144 MMNL started with pid=11, OS id=3336 Mon Oct 22 14:36:45 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Mon Oct 22 14:36:45 2007 Create controlfile reuse set database "opgavese" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo03.log') SIZE 51200K RESETLOGS Mon Oct 22 14:36:45 2007 WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Setting recovery target incarnation to 1 Mon Oct 22 14:36:48 2007 Successful mount of redo thread 1, with mount id 3391601597 Mon Oct 22 14:36:49 2007 Completed: Create controlfile reuse set database "opgavese" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 Datafile 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSTEM01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\UNDOTBS01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\SYSAUX01.DBF', 'C:\oracle\product\10.2.0\oradata\opgaveserver\USERS01.DBF' LOGFILE GROUP 1 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo01.log') SIZE 51200K, GROUP 2 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo02.log') SIZE 51200K, GROUP 3 ('C:\oracle\product\10.2.0/oradata/opgaveserver/redo03.log') SIZE 51200K RESETLOGS Mon Oct 22 14:36:49 2007 Stopping background process MMNL Mon Oct 22 14:36:50 2007 Stopping background process MMON Starting background process MMON Starting background process MMNL MMON started with pid=10, OS id=3340 Mon Oct 22 14:36:51 2007 ALTER SYSTEM enable restricted session; Mon Oct 22 14:36:51 2007 alter database "opgavese" open resetlogs MMNL started with pid=11, OS id=4072 Mon Oct 22 14:36:51 2007 RESETLOGS after incomplete recovery UNTIL CHANGE 534906 Mon Oct 22 14:36:51 2007 Errors in file c:\oracle\product\10.2.0\admin\opgaveserver\udump\opgaveserver_ora_348.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.
Mon Oct 22 14:36:56 2007 Errors in file c:\oracle\product\10.2.0\admin\opgaveserver\udump\opgaveserver_ora_348.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO02.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.
Mon Oct 22 14:37:01 2007 Errors in file c:\oracle\product\10.2.0\admin\opgaveserver\udump\opgaveserver_ora_348.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO03.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.
Mon Oct 22 14:37:08 2007 Setting recovery target incarnation to 2 Mon Oct 22 14:37:08 2007 Assigning activation ID 3391601597 (0xca27bbbd) Thread 1 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO03.LOG Successful open of redo thread 1 Mon Oct 22 14:37:09 2007 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Oct 22 14:37:09 2007 SMON: enabling cache recovery Mon Oct 22 14:37:11 2007 Successfully onlined Undo Tablespace 1. Dictionary check beginning Tablespace 'TEMP' #3 found in data dictionary, but not in the controlfile. Adding to controlfile. Dictionary check complete Mon Oct 22 14:37:12 2007 SMON: enabling tx recovery Mon Oct 22 14:37:12 2007 ********************************************************************* WARNING: The following temporary tablespaces contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMP ********************************************************************* Database Characterset is US7ASCII Threshold validation cannot be done before catproc is loaded. Threshold validation cannot be done before catproc is loaded. ********************************************************** WARNING: Files may exists in db_recovery_file_dest that are not known to the database. Use the RMAN command CATALOG RECOVERY AREA to re-catalog any such files. One of the following events caused this: 1. A backup controlfile was restored. 2. A standby controlfile was restored. 3. The controlfile was re-created. 4. db_recovery_file_dest had previously been enabled and then disabled. ********************************************************** replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=2880 Mon Oct 22 14:37:18 2007 LOGSTDBY: Validating controlfile with logical metadata Mon Oct 22 14:37:18 2007 LOGSTDBY: Validation complete Global Name changed to OPGAVESE Completed: alter database "opgavese" open resetlogs Mon Oct 22 14:37:23 2007 alter database rename global_name to "opgavese" Completed: alter database rename global_name to "opgavese" Mon Oct 22 14:37:23 2007 ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\opgaveserver\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\opgaveserver\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED Mon Oct 22 14:37:24 2007 ALTER DATABASE DEFAULT TABLESPACE "USERS" Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS" Mon Oct 22 14:37:24 2007 alter database character set INTERNAL_CONVERT WE8MSWIN1252 Mon Oct 22 14:37:40 2007 Updating character set in controlfile to WE8MSWIN1252 Synchronizing connection with database character set information Refreshing type attributes with new character set information Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252 Mon Oct 22 14:37:59 2007 ALTER SYSTEM disable restricted session; Mon Oct 22 14:38:00 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Mon Oct 22 14:38:06 2007 Starting background process CJQ0 CJQ0 started with pid=19, OS id=2772 Mon Oct 22 14:38:22 2007 Starting background process EMN0 EMN0 started with pid=23, OS id=3260 Mon Oct 22 14:38:22 2007 Shutting down instance: further logons disabled Mon Oct 22 14:39:00 2007 Stopping background process CJQ0 Mon Oct 22 14:39:00 2007 Stopping background process QMNC Mon Oct 22 14:39:01 2007 Stopping background process MMNL Mon Oct 22 14:39:01 2007 Stopping background process MMON Mon Oct 22 14:39:03 2007 Shutting down instance (immediate) License high water mark = 5 All dispatchers and shared servers shutdown Mon Oct 22 14:39:09 2007 ALTER DATABASE CLOSE NORMAL Mon Oct 22 14:39:09 2007 SMON: disabling tx recovery SMON: disabling cache recovery Mon Oct 22 14:39:10 2007 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 1 Successful close of redo thread 1 Mon Oct 22 14:39:11 2007 Completed: ALTER DATABASE CLOSE NORMAL Mon Oct 22 14:39:11 2007 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Mon Oct 22 14:39:14 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.1.0. System parameters with non-default values: processes = 150 spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEOPGAVESERVER.ORA sga_target = 612368384 control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\CONTROL03.CTL db_block_size = 8192 compatible = 10.2.0.1.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=opgaveserverXDB) job_queue_processes = 10 audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\ADUMP background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\BDUMP user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\UDUMP core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\OPGAVESERVER\CDUMP db_name = opgavese db_unique_name = opgaveserver open_cursors = 300 pga_aggregate_target = 203423744 PMON started with pid=2, OS id=1524 PSP0 started with pid=3, OS id=2812 MMAN started with pid=4, OS id=1724 DBW0 started with pid=5, OS id=3716 LGWR started with pid=6, OS id=3096 CKPT started with pid=7, OS id=3560 SMON started with pid=8, OS id=3192 RECO started with pid=9, OS id=1548 CJQ0 started with pid=10, OS id=784 MMON started with pid=11, OS id=208 MMNL started with pid=12, OS id=1016 Mon Oct 22 14:39:14 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Mon Oct 22 14:39:14 2007 ALTER DATABASE MOUNT Mon Oct 22 14:39:19 2007 Setting recovery target incarnation to 2 Mon Oct 22 14:39:19 2007 Successful mount of redo thread 1, with mount id 3391582290 Mon Oct 22 14:39:19 2007 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Mon Oct 22 14:39:20 2007 ALTER DATABASE OPEN Mon Oct 22 14:39:22 2007 Thread 1 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO03.LOG Successful open of redo thread 1 Mon Oct 22 14:39:22 2007 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Oct 22 14:39:22 2007 SMON: enabling cache recovery Mon Oct 22 14:39:24 2007 Successfully onlined Undo Tablespace 1. Mon Oct 22 14:39:24 2007 SMON: enabling tx recovery Mon Oct 22 14:39:25 2007 Database Characterset is WE8MSWIN1252 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=15, OS id=3420 Mon Oct 22 14:39:39 2007 Completed: ALTER DATABASE OPEN Mon Oct 22 14:39:41 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Mon Oct 22 14:44:27 2007 Thread 1 advanced to log sequence 2 Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO01.LOG
Får fejlene som fra første post, når jeg går ind på oracle enterprise manager..
Database instance og agent connection to database instance er nede.. " Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) "
Og på websiden, der benytter databasen: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor "
sådan ser den ud pt # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora # Generated by Oracle configuration tools.
status skulle gerne vise dig at den nu lytter direkte på SID OPGAVESERVER
Synes godt om
Slettet bruger
22. oktober 2007 - 16:00#16
C:\oracle\product\10.2.0\db_1\BIN>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-OCT-2007 16:01 :02
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=privat-rhm6o5w8.opgavese rver.dk)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ ction Start Date 22-OCT-2007 16:00:51 Uptime 0 days 0 hr. 0 min. 13 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o ra Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=privat-rhm6o5w8.opgaveserver.dk)(POR T=1521))) Services Summary... Service "OPGAVESERVER" has 1 instance(s). Instance "OPGAVESERVER", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
øhh ? Har du mere end 1 database ? Du har indtil nu kun fortalt om SID:opgaveserver
Synes godt om
Slettet bruger
22. oktober 2007 - 16:18#20
altså har bare prøvet at installere én til, fordi den anden gik i kuk.. men gik så også gal ved genstart. opgaveserver er den nyeste.. bare jeg kan få en af dem til at køre er jeg godt tilfreds :)
# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.
så kører din database ikke! Så skal du forfra og checke at din service er startet + at registry parameret er sat til autostart + at din alert.log fortæller at databasen er "open.
Tror jeg stopper her... held og lykke..
Synes godt om
Slettet bruger
23. oktober 2007 - 10:13#39
heh.. så er vi samme sted.. kæft noget skrammel det oralce :p
Jeg siger tak for hjælpen i hvert fald.. må se om jeg kan finde nogen, der gider løbe det igennem.. bare smid et svar, for der er nok ikke nogen, der har mere kvalificerede bud end du...
Men hvis jeg lige må spørge til: "Din database virker fint - det er kun din db console der ikke kan starte ordenligt op fordi den har sit repository i samme database."
Er det noget jeg så kan ændre, hvis jeg for 10. gang afinstallere og installerer igen.. ? Er det en setting, noget jeg kan ændre før genstart eller hvorn ? forstod ikke lige delen med repository i samme database :)
Oracle er faktisk ganske simpelt - men det kræver en del indsigt og forståelse at komme ind i det. Jeg har arbejdet med det i 9 år fuldtids nu..
dbconsole bruger tabeller i databasen til at starte op. Men da din database ligger på samme maskine og ikke er startet når din dbconsole forsøger at starte, kan den naturligvis ikke starte op og vil fejle.
I vores setup her har vi 45 databaser fordelt over en masse servere. Jeg har så en database dedikeret til at tage sig af overvågning og administration.
Jeg ville nok starte med at få din database til at køre som den skal og så glemme alt om dbconsole. Tror det er den der forvirer dig.
Synes godt om
Slettet bruger
23. oktober 2007 - 10:27#41
mkay men kan jo bare slet ikke få forbindelse til databasen? ja har desværre kun mulighed for én server, der trækker ALT :p
prøv lige at genstarte din service oracleserviceopgaveserver og send mig de sidste 10 linier fra din alert.log
Synes godt om
Slettet bruger
23. oktober 2007 - 10:34#43
Completed: ALTER DATABASE OPEN Mon Oct 22 14:39:41 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Mon Oct 22 14:44:27 2007 Thread 1 advanced to log sequence 2 Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\OPGAVESERVER\REDO01.LOG
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 23 10:42:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Synes godt om
Slettet bruger
23. oktober 2007 - 10:44#48
Enter user-name: sys/dmudmu1 as sysdba Connected to an idle instance.
så kom den vist så prøver jeg det startup
Synes godt om
Slettet bruger
23. oktober 2007 - 10:46#49
ORACLE instance started.
Total System Global Area 612368384 bytes Fixed Size 1250452 bytes Variable Size 171969388 bytes Database Buffers 436207616 bytes Redo Buffers 2940928 bytes Database mounted. Database opened. SQL> select instance,status from v$thread;; select instance,status from v$thread; * ERROR at line 1: ORA-00911: invalid character
nu rykker det vist igen.. kanon, tak... MEN i tilfælde af at den går død efter genstart igen.. hvad er det så lige jeg skal gøre så? bare sidst nævnte ?
VERSION INFORMATION: TNS for 32-bit Windows: Version 10.1.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production Time: <timestamp> Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-530: Protocol adapter error nt secondary err code: 2 nt OS err code: 0
Cause
Bug 4598734 'NET START ORACLESERVICESID' FAILS TO START THE DATABASE ON 10.1.0.4 Solution
The fix for bug 4598734 has been included in Database Server patchset ver. 10.1.0.5 and in Server patchset ver. 10.2.0.2, respectively.
If running Database Server ver. 10.1, apply Server patchset ver. 10.1.0.5 / Windows 32-bit to implement the fix. Server patchset ver. 10.1.0.5 can be downloaded in Metalink with patch number 4505133.
If running Database Server ver. 10.2, apply Server patchset ver. 10.2.0.2 / Windows 32-bit to implement the fix. Server patchset ver. 10.2.0.2 can be downloaded in Metalink with patch number 4547817.
Synes godt om
Slettet bruger
23. oktober 2007 - 11:28#55
kanon, ikke bare mig så, takker, jeg kigger. Til øvrige der skulle google sig til spørgsmålet, kan jeg oplyse, at problemet kommer igen efter genstart. Men at gøre det sidstnævnte, fixer det. :)
Synes godt om
Slettet bruger
04. marts 2008 - 18:54#56
hov, gider du svmide et svar :) tak
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.