Avatar billede Slettet bruger
22. oktober 2007 - 15:05 Der 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)
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:13 #1
Check at din service er sat til at starte efter genstart af server.
gå i services -> find oracleserviceopgaverserver - sæt den til autostart
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:15 #2
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
Avatar billede Slettet bruger
22. oktober 2007 - 15:15 #3
hej, tak for svar.. alle services er starter, og sat til autostart
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:16 #4
Check din alert.log som formenligt ligger i C:\oracle\product\10.2.0\db_1\admin\opgaverserver\bdump - hvad står der i bunden af den ?
Avatar billede Slettet bruger
22. oktober 2007 - 15:20 #5
jeg har søgt hele drevet igennem, og jeg har desværre ingen alert.log ?
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:26 #6
Den hedder nok alert_opgaveserver.log - så søg efter det. Filen ligger i det directory som du har sat background_dump_dest til.
Avatar billede Slettet bruger
22. oktober 2007 - 15:29 #7
det må være noget default.. mindes det i hvert fald ikke :)
Avatar billede 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
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:34 #9
jamen det ser jo fint ud - din database kører da!

Hvad er problemet du oplever ?
Avatar billede Slettet bruger
22. oktober 2007 - 15:38 #10
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 "
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:44 #11
nå ok... det er fordi du ikke har lagt din sid ind i listener.ora

Gå til C:\ORACLE\PRODUCT\10.2.0\DB_1\NETWORK\ADMIN og se om du har en listener.ora ?

Ellers så brug din network assistant til at tilføje din SID. Den skal se ud ala det her:


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = OPGAVESERVER)
      (ORACLE_HOME = C:\ORACLE\PRODUCT\10.2.0)
      (SID_NAME = OPGAVESERVER)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = privat-rhm6o5w8.opgaveserver.dk)(PORT = 1521))
  )
  )
Avatar billede Slettet bruger
22. oktober 2007 - 15:48 #12
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.

# PLSExtProc

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = privat-rhm6o5w8.opgaveserver.dk)(PORT = 1521))
    )
  )
Avatar billede Slettet bruger
22. oktober 2007 - 15:51 #13
prøvede også din version, men ændrede udmiddelbart intet.. ved ikke om noget skal genstartes før effekten træder ind?
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:52 #14
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = OPGAVESERVER)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = OPGAVESERVER)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = privat-rhm6o5w8.opgaveserver.dk)(PORT = 1521))
    )
  )
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 15:53 #15
du skal genstarte din listener bagefter

c:\lsnrctl

lsnrctl> stop
lsnrctl> start
lsnrctl> status

status skulle gerne vise dig at den nu lytter direkte på SID OPGAVESERVER
Avatar billede 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

C:\oracle\product\10.2.0\db_1\BIN>
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:01 #17
det ser godt ud nu...
Avatar billede Slettet bruger
22. oktober 2007 - 16:01 #18
det har dog desværre ikke afhjulpet problemet. den ene database har den samme fejl, mens den anden nu skriver "Status  Failed

Details  ORA-01034: ORACLE not available
"
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:16 #19
øhh ? Har du mere end 1 database ? Du har indtil nu kun fortalt om SID:opgaveserver
Avatar billede 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 :)
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:21 #21
undre mig egenligt lidt over du har fået lov at lave en SID på over 8 tegn ...
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:22 #22
har du prøvet at vende din server nu - efter du har ændret listener?
Avatar billede Slettet bruger
22. oktober 2007 - 16:26 #23
vende ?

altså når jeg besøger manager så er der samme fejl.. se:
http://www.fluii.dk/pic/FluiiDK-01811.jpg
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:27 #24
nåå vent nu lidt.. tror det er fordi du har det hele liggende på samme server.
Prøv at genstarte db control og prøv igen.

Det er sikkert fordi din db control forsøger at connecte til databasen inden den er kommet op. Services starter bare op uden dependencies.

du kan evt. sætte db control til manuel og så starte den op så snart alle services siger de er startet.
Avatar billede Slettet bruger
22. oktober 2007 - 16:28 #25
det lyder meget rigtig :)  men hvordan genstarter jeg så den ?
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:35 #26
emctl stop dbconsole
emctl start dbconsole
Avatar billede Slettet bruger
22. oktober 2007 - 16:37 #27
"Environment variable ORACLE_SID not defined. Please define it." melder den når jeg skriver "emctl stop dbconsole" .oO
Avatar billede Slettet bruger
22. oktober 2007 - 16:38 #28
samme fejl når jeg starter den.
Avatar billede pnielsen Nybegynder
22. oktober 2007 - 16:42 #29
SET ORACLE_SID=opgaveserver 
emctl stop dbconsole
emctl start dbconsole
Avatar billede Slettet bruger
22. oktober 2007 - 16:47 #30
øh nu står der på alle 3 punkter fra billedet:
"Status  Unavailable"
Avatar billede Slettet bruger
22. oktober 2007 - 16:48 #31
nej nu kom listener og agent connection skriver: Status  Failed

Details  ORA-01034: ORACLE not available
"
Avatar billede Slettet bruger
22. oktober 2007 - 16:54 #32
http://www.fluii.dk/pic/FluiiDK-01812.jpg her er der en extra lille fejl med kan jeg se.. noget shared memory ??
Avatar billede Slettet bruger
22. oktober 2007 - 16:57 #33
jeg må desværre gå for idag.. vender tilbage i morgen :)
Avatar billede Slettet bruger
23. oktober 2007 - 09:17 #34
hehe løb du også tør for ideen :) ?
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 09:29 #35
Næh - jeg tror du er i mål..

"ORA-01034: ORACLE not available" må komme fra den database du ikke har startet, da din alert_opgaveserver.log siger din database kører fint.

Din database virker fint - det er kun din db console der ikke kan starte ordenligt op fordi den har sit repository i samme database.

Prøv lige i en cmd prompt at skrive:
c:\SET ORACLE_SID=OPGAVESERVER
c:\sqlplus system/<ditpassword>
sqlplus> select instance,status from v$thread;;
Avatar billede Slettet bruger
23. oktober 2007 - 09:35 #36
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist efter  c:\sqlplus system/<ditpassword>
Avatar billede Slettet bruger
23. oktober 2007 - 09:41 #37
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = OPGAVESERVER)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = OPGAVESERVER)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = privat-rhm6o5w8.opgaveserver.dk)(PORT = 1521))
    )
  )

-----
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

OPGAVESE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = privat-rhm6o5w8.opgaveserver.dk)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = opgaveserver)
    )
  )



EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

----
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:08 #38
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..
Avatar billede 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 :)
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:21 #40
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.
Avatar billede 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
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:30 #42
prøv lige at genstarte din service oracleserviceopgaveserver og send mig de sidste 10 linier fra din alert.log
Avatar billede 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
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:36 #44
c:\SET ORACLE_SID=OPGAVESERVER
c:\sqlplus system/<ditpassword>
sqlplus> select instance,status from v$thread;;
Avatar billede Slettet bruger
23. oktober 2007 - 10:38 #45
det samme.. desværre
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:40 #46
send mig lige præcist hvad du skriver..

c:\SET ORACLE_SID=OPGAVESERVER
c:\sqlplus sys/<ditpassword> as sysdba
sqlplus>startup
sqlplus> select instance,status from v$thread;;
Avatar billede Slettet bruger
23. oktober 2007 - 10:43 #47
C:\oracle\product\10.2.0\db_1\BIN>SET ORACLE_SID=OPGAVESERVER

C:\oracle\product\10.2.0\db_1\BIN>sqlplus sys/mitpassword

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
Avatar billede 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
Avatar billede 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


SQL>  select instance,status from v$thread;

INSTANCE
--------------------------------------------------------------------------------

STATUS
------
opgaveserver
OPEN
Avatar billede Slettet bruger
23. oktober 2007 - 10:47 #50
JA FOR DÆLEN DA :D :D

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 ?

Husk at smid svar
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:51 #51
jeg tror ikke din autostart er sat i registry - har du testet det ?
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 10:52 #52
ellers så check om du får fejl i din oradim.log fil - ligger i  C:\oracle\product\10.2.0\db_1\database
Avatar billede Slettet bruger
23. oktober 2007 - 10:58 #53
altså den autogenstart som du referede til i starten er sat til true ja.

Tue Oct 23 10:33:54 2007
C:\oracle\product\10.2.0\db_1\bin\oradim.exe -startup -sid opgaveserver -usrpwd *  -log oradim.log -nocheck 0
Tue Oct 23 10:33:55 2007
ORA-12560: TNS:protocol adapter error

Den fejl er der et hav af.
Avatar billede pnielsen Nybegynder
23. oktober 2007 - 11:24 #54
Starting the instance service, either by using 'net start oracleserviceSID' or the Service panel, fails to start the database.

The key ORA_SID_AUTOSTART is set to TRUE in registry.

In ORACLE_HOME\database\oradim.log, an ORA-12560 error is logged:

ORA-12560: TNS:protocol adapter error

In ORACLE_HOME\database\sqlnet.log, the following errors are reported:

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracle<SID>)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=v1010)(CID=(PROGRAM=D:\Oracle\Ora101\bin\oradim.exe)(HOST=<hostname>)(USER=SYSTEM))))

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.
Avatar billede 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. :)
Avatar billede Slettet bruger
04. marts 2008 - 18:54 #56
hov, gider du svmide et svar :)
tak
Avatar billede Ny bruger Nybegynder

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.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester