Oracle 10g nouveau
Le
JB
L'installation (ré) s'est bien déroulée
La connection à travers Konqueror est OK sauf pour:
http://alpha111.boxxx.fr:5620/ultrasearch et ultasearch/admin
pour isqlplus cest ok pour scott/tiger
mais non possible pour 5560/isqlplus/dba, j'ai une petite id le
lancement de Konquror par la barre de tache le user n'est oracle(!=
5500/em jocker
trace d'une connect manelle:
[oracle@alpha111 bin]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Mon Nov 22 13:51:31 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> connect system@orcl
Enter password:
Connected.
SQL> show sga
Total System Global Area 167772160 bytes
Fixed Size 778212 bytes
Variable Size 61874204 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes
SQL> shutdown
ORA-01031: insufficient privileges
SQL> !id
uidP2(oracle) gidP3(dba) groupesP3(dba),504(oracle)
SQL>
La syntaxe de l'arret base est-elle correcte puisque 10g?
[oracle@alpha111 bin]$ oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may
occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
[oracle@alpha111 bin]$
comment je m'attribue les priviléges!
A+
JB
La connection à travers Konqueror est OK sauf pour:
http://alpha111.boxxx.fr:5620/ultrasearch et ultasearch/admin
pour isqlplus cest ok pour scott/tiger
mais non possible pour 5560/isqlplus/dba, j'ai une petite id le
lancement de Konquror par la barre de tache le user n'est oracle(!=
5500/em jocker
trace d'une connect manelle:
[oracle@alpha111 bin]$ sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Mon Nov 22 13:51:31 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> connect system@orcl
Enter password:
Connected.
SQL> show sga
Total System Global Area 167772160 bytes
Fixed Size 778212 bytes
Variable Size 61874204 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes
SQL> shutdown
ORA-01031: insufficient privileges
SQL> !id
uidP2(oracle) gidP3(dba) groupesP3(dba),504(oracle)
SQL>
La syntaxe de l'arret base est-elle correcte puisque 10g?
[oracle@alpha111 bin]$ oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may
occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
[oracle@alpha111 bin]$
comment je m'attribue les priviléges!
A+
JB

Poser une question


Faire :
SQL> connect / as sysdba
au lieu de :
Si tu insiste à system lance
"connect system" au lieu de "connect "
Igor
Merci Bruno, Merci Igor ( par ordre alpha)
La base ne remonte plus, malgré un shutdown abort,
on va voir, car sinon l'accés user scott pas de pb,
nota le shutdown abort a eu lieu sans aucune maj du SGBD
encore merci
A+
JB
A+
JB
A+
JB