Discussion :

[smooncef]

Bonjour,

D'après vous que dois-je faire avec ça !
Je viens de terminer l'installation d'un oracle 9i sur un sun solaris 9

Merci de votre aide précieuse ...

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
 
$ dbstart
 
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Feb 26 16:03:04 2008
 
(c) Copyright 2001 Oracle Corporation.  All rights reserved.
 
SQL> Connected to an idle instance.
SQL> ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
SQL> Disconnected
 
Database "HOGAN" warm started.
$

[fulub]

Bonjour,

Voir sur metalink, la note 314179.1 qui semble correspondre à votre problème.

Fulub

[smooncef]

Bonjour,

Voir sur metalink, la note 314179.1 qui semble correspondre à votre problème.

Fulub

Ayai, j'ai trouvé tout seul comme un grand.
Merci

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
 
su - root
vi /etc/system
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=3025
set semsys:seminfo_semmni=100
set semsys:seminfo_semmnu=3025
set semsys:seminfo_semmsl=3025
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmnb=16384
set msgsys:msginfo_msgmni=3600
 
 
 
Some are shmsys.
Some are semsys.
You are not using semsys at all.
Your last three parameters should be semsys:xxxxx
Do not try the same settings. It may not work for you.
try with
SEMMNI 100 -- same as mine
SEMMNS 1024-- mine is different
SEMMSL 256 -- mine is different.

[smooncef]

Salut (re),

Voici que voilà, je ne sais pas là, je sèche !!!

Code :

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

1
2
3
4
5
6
7
8
9
10
 
SQL> startup
ORACLE instance started.
 
Total System Global Area  235701300 bytes
Fixed Size                   279604 bytes
Variable Size             167772160 bytes
Database Buffers           67108864 bytes
Redo Buffers                 540672 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

Et dans mon alert_HOGAN.log j'ai :

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
 
Tue Feb 26 16:42:07 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 67108864
  large_pool_size          = 1048576
  java_pool_size           = 67108864
  resource_manager_plan    = SYSTEM_PLAN
  control_files            = /export/home/oracle/product/9i/oradata/HOGAN/control01.ctl, /export/home/oracle/product/9i/oradata/HOGAN/control02.ctl, /export/home/oracle/product/9i/oradata/HOGAN/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 67108864
  compatible               = 9.0.0
  fast_start_mttr_target   = 0
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = TREM.BOD
  instance_name            = HOGAN
  dispatchers              = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=o
racle.aurora.server.SGiopServer)
  background_dump_dest     = /export/home/oracle/product/9i/admin/HOGAN/bdump
  user_dump_dest           = /export/home/oracle/product/9i/admin/HOGAN/udump
  core_dump_dest           = /export/home/oracle/product/9i/admin/HOGAN/cdump
  sort_area_size           = 524288
  db_name                  = HOGAN
  open_cursors             = 300
Data Guard broker requires Oracle Enterprise Edition license
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
Tue Feb 26 16:42:08 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Feb 26 16:42:08 2008
ALTER DATABASE   MOUNT
Tue Feb 26 16:42:11 2008
ORA-00202: controlfile: '/export/home/oracle/product/9i/oradata/HOGAN/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Feb 26 16:42:11 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...

Et lorsque je créé les fichiers control01.ctl control02.ctl control03.ctl dans le dossier /export/home/oracle/product/9i/oradata/HOGAN/ voici ce que ça donne :

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
 
Tue Feb 26 16:56:22 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 67108864
  large_pool_size          = 1048576
  java_pool_size           = 67108864
  resource_manager_plan    = SYSTEM_PLAN
  control_files            = /export/home/oracle/product/9i/oradata/HOGAN/control01.ctl, /export/home/oracle/product/9i/oradata/HO
GAN/control02.ctl, /export/home/oracle/product/9i/oradata/HOGAN/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 67108864
  compatible               = 9.0.0
  fast_start_mttr_target   = 0
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = TREM.BOD
  instance_name            = HOGAN
  dispatchers              = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=o
racle.aurora.server.SGiopServer)
  background_dump_dest     = /export/home/oracle/product/9i/admin/HOGAN/bdump
  user_dump_dest           = /export/home/oracle/product/9i/admin/HOGAN/udump
  core_dump_dest           = /export/home/oracle/product/9i/admin/HOGAN/cdump
  sort_area_size           = 524288
  db_name                  = HOGAN
  open_cursors             = 300
Data Guard broker requires Oracle Enterprise Edition license
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
Tue Feb 26 16:56:24 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Feb 26 16:56:25 2008
ALTER DATABASE   MOUNT
Tue Feb 26 16:56:28 2008
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/export/home/oracle/product/9i/oradata/HOGAN/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
Additional information: 1
Additional information: 16
Tue Feb 26 16:56:28 2008
ORA-205 signalled during: ALTER DATABASE   MOUNT...

Merci de votre aide.

[scheu]

Le répertoire /export/home/oracle/product/9i/oradata/HOGAN/ existe bien sur ton serveur ?
Tu as bien lancé au préalable un script "CREATE DATABASE" pour créer ta base ?

[scheu]

Juste au passage, si tu n'as encore qu'installé le produit Oracle sans aucune base, je te conseillerai fortement de le désinstaller et d'installer à la place une version 9.2.0.x (9.2.0.4 + éventuellement patcher jusqu'en 9.2.0.8), qui est sûrement beaucoup moins buggée

[orafrance]

j'ai fusionné tes 2 discussions

[smooncef]

Merci