Bonjour,

J'ai installé ORACLE 10.2g et plusieurs instances.
Lorsque je lance Le DATABASE CONTROL ,
j'ai une erreur ORA 1034 Oracle not available .

Mes services sont bien démarrés et en Automatique .

En DOS, si je lance un ORACLE_SID= mon instance,
puis un SQLPLUS /nolog suivi d'un connect sys/manager as sysdba et enfin un startup .

Ma base démarre et cela semble bon.

ci joint mon LISTENER

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.



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 = SERCL)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = SERCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = etw)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = etw)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SAGE.cuc.local)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = SAGE)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servertest)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )



ainsi que mon TNSNAme /

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

SERCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servertest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SERCL)
    )
  )

SAGE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servertest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SAGE)
    )
  )

ETW =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = servertest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ETW)
    )
  )


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

La notion de SERVICE NAME et de SID m'echappe un peu ...

Une idée