Articoli marcati con tag ‘oracle 11.2’

Grid Console 10.2.0.5 con db 11.2??

venerdì, 4 febbraio 2011

Se avete un EM 10.2.0.5 e volete utilizzarlo per monitorare un db 11.2,preparatevi ad una serie problemi.
Oracle in una nota, la 953846.1, scrive “Grid Control 10.2.0.5.0 now supports DB 11.2.0.1.0 as a target.” purché installiate una serie di patch, per fortuna tutte incluse nell’ultima psu del management server e agent.
Purtroppo pur avendo tutto questo installato rischiate di imbattervi in questo bug non pubblicato:

Bug 9550229 <11.2.0.1 RAC NEW FEATURES SHOULD NOT BE PART OF 10.2.0.5 GRID CONTROL>
che dice “Enterprise Manager Grid Control 10.2.0.5, which provides management
support for previous Oracle Database versions, does not support new Oracle
Database 11g Release 2 (11.2) features. …”

Dal titolo parla di RAC, ma nella descrizione non ne fa riferimento, almeno nella parte visibile.

Potete provare ad installare l’agent 11.1 (compatibile con l’oms 10.2.0.5, almeno da matrice di compatibilità) anche se Oracle consiglia di utilizzare la stessa versione per agent e oms.

Insomma situazioni miste non sono tanto gradite all’EM.
Ciao
Davide

Tag:, , , , , , , , , , , , , , ,
Pubblicato in Mondo Oracle, Oracle, Oracle, Senza categoria | Nessun commento »

Delayed Failed Logins in 11gR2

martedì, 18 gennaio 2011
Nella versione 11g R2 se si tenta di accedere al db con una password sbagliata,
i primi tre tentativi rispondo abbastanza veloci.
Dal quarto tentativo in poi, viene applicato un delay di 1 secondo in più a tentativo nella risposta.
L’utente è attivo e non è in stato di lock.
-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:56:56 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m0.215s
user    0m0.011s
sys     0m0.032s

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:13 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m0.093s
user    0m0.016s
sys     0m0.029s

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:15 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m0.103s
user    0m0.011s
sys     0m0.035s

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:20 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Inizio il 4 tentativo:
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m1.099s
user    0m0.015s
sys     0m0.030s
Quinto tentativo:

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:23 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m2.096s
user    0m0.014s
sys     0m0.026s
Sesto tentativo:

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:27 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m3.101s
user    0m0.014s
sys     0m0.031s
Settimo tentativo:

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:32 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m4.101s
user    0m0.014s
sys     0m0.031s
Ottavo tentativo:

-bash-3.2$ time echo “select sysdate from dual;” |sqlplus user/password
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 17 09:57:39 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
<proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
Enter user-name:
real    0m5.102s
user    0m0.017s
sys     0m0.029s
e così via….
Questa è una nuova feature della 11g, definita come “brute force”.
Questo è per rendere più difficili l’hacking.
Se la password è corretta non ci sarà nessun delay.
Ciao,
Davide



Tag:, , , , , , , , , , , ,
Pubblicato in Data Base Management, Oracle, Oracle, Senza categoria | Nessun commento »