Discussion :

[sami_b]

Bonsoir,

j'ai installé oracle9 et j ai créé une base locale, mais il m est impossible de me connecter dessus, portant j arrive a me connecter sur une base distante !!!

[philcero]

La réponse est dans la boîte de dialogue, à première vue ton serveur "laptop_smb" ne possède pas de LISTENER en attente sur le port 1521.

Vérifie donc cette machine, elle doit avoir un LISTENER en mémoire et de plus un module d'écoute sur le port 1521.

[scheu]

C'est parce que Enterprise Manager utilise le listener pour se connecter, même si ta base est en locale sur la même machine
Il faut effectivement configurer et démarrer le listener

[sami_b]

Bonjour

le service Listner n'avait pas démarré, maintenat j arrive à me connecter une fois sur deux car je ne sais pour quelles raisons en ouvrant Entreprise manager ou en essayant de me connecter à une base, tnslistner plente !!!

voila ce que j ai dans les fichiers listner.ora :

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
# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = laptop_smb)(PORT = 1521))
      )
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = DBORAC)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = DBORAC)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = TFR)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = TFR)
    )
  )

et tnsnames :

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
# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
TFR.OXIA.CORP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = laptop_smb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TFR)
    )
  )
 
EXTPROC_CONNECTION_DATA.OXIA.CORP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
INST1_HTTP.OXIA.CORP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = laptop_smb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )
 
DBORAC.OXIA.CORP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = laptop_smb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBORAC)
    )
  )

est ce qu'il y a un fichier log pour savoir pourkoi le listner plente ??

[Leeloo_Multiboot]

Coucou,

Pour avoir le status de ton listener et voir les erreurs:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

lsnrctl -status

ps: la conversion est bizarre, c'est -status pas -STATUS.

Sinon pour les alertes générées lors de la connexion à ton instance:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

cat $ORACLE_BASE/admin/sid/bdump/alert_SID.log

Le fichier de log du démarrage:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

cat $ORACLE_HOME/startup.log

[sami_b]

concernant les commandes, comment les executer ?
j ai trouvé les fichiers logs je ne saurai les comprendre

pourrai je vous les envoyer ?

[Leeloo_Multiboot]

Coucou,

Tu peux sélectionner le contenu de tes fichiers de log et le coller ici.
Normalement, vu que la création est récente, ils ne devraient pas ètre trop volumineux

[sami_b]

JE nz trouve pas ce fichier : ORACLE_HOME/startup.log

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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
Tue Apr 22 18:54:49 2008
alter database rename global_name to DBORAC
Completed: alter database rename global_name to DBORAC
Tue Apr 22 18:54:50 2008
ALTER TABLESPACE TEMP ADD TEMPFILE 'E:\oracle\oradata\DBORAC\TEMP01.DBF' REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'E:\oracle\orad
Tue Apr 22 18:54:50 2008
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Updating character set in controlfile to WE8MSWIN1252
Completed: alter database character set INTERNAL_CONVERT WE8M
Tue Apr 22 18:54:56 2008
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON
Tue Apr 22 18:56:42 2008
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Apr 22 18:56:45 2008
ALTER DATABASE CLOSE NORMAL
Tue Apr 22 18:56:45 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Apr 22 18:56:46 2008
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.
Tue Apr 22 18:56:46 2008
Completed: ALTER DATABASE CLOSE NORMAL
Tue Apr 22 18:56:46 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Apr 22 18:56:49 2008
Starting ORACLE instance (normal)
Tue Apr 22 18:56:49 2008
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 50331648
  large_pool_size          = 8388608
  java_pool_size           = 33554432
  control_files            = E:\oracle\oradata\DBORAC\CONTROL01.CTL, E:\oracle\oradata\DBORAC\CONTROL02.CTL, E:\oracle\oradata\DBORAC\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 0
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  instance_name            = DBORAC
  dispatchers              = (PROTOCOL=TCP) (SERVICE=DBORACXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = E:\oracle\admin\DBORAC\bdump
  user_dump_dest           = E:\oracle\admin\DBORAC\udump
  core_dump_dest           = E:\oracle\admin\DBORAC\cdump
  sort_area_size           = 524288
  db_name                  = DBORAC
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
  aq_tm_processes          = 1
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
Tue Apr 22 18:56:51 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Oracle Data Guard is not available in this edition of Oracle.
Tue Apr 22 18:56:52 2008
ALTER DATABASE   MOUNT
Tue Apr 22 18:56:57 2008
Successful mount of redo thread 1, with mount id 4218638388.
Tue Apr 22 18:56:57 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue Apr 22 18:56:57 2008
ALTER DATABASE OPEN
Tue Apr 22 18:56:57 2008
Thread 1 opened at log sequence 1
  Current log# 3 seq# 1 mem# 0: E:\ORACLE\ORADATA\DBORAC\REDO03.LOG
Successful open of redo thread 1.
Tue Apr 22 18:56:57 2008
SMON: enabling cache recovery
Tue Apr 22 18:56:58 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Apr 22 18:56:58 2008
SMON: enabling tx recovery
Tue Apr 22 18:56:58 2008
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Apr 22 19:02:16 2008
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Apr 22 19:02:19 2008
alter database close normal