used ip insteaad of name and it got fixed, why?
No idea.
BBBV_3_17.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jreyes)(PORT=1522))(CONNECT_DATA=(SID=BBBV)))
BBBV_3_17.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.17)(PORT=1522))(CONNECT_DATA=(SID=BBBV)))
viernes, 8 de diciembre de 2017
miércoles, 6 de diciembre de 2017
upgrading 12.2 preupgrade.jar ORA-01017
SET ORACLE_SID=BBBV
SET ORACLE_BASE=c:\app\jreyes
SET ORACLE_HOME=C:\app\jreyes\product\12.1.0.1.13\dbhome_1
C:\app\jreyes\product\11.2.0\dbhome_1\jdk\bin\java -jar C:\app\product\12.2.0\dbhome_1\rdbms\admin\preupgrade.jar FILE TEXT DIR D:\TEMPD
ERROR - Unable to run sqlplus due to:
ORA-01017:
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
Solution:
I ran
C:\app\product\12.2.0\dbhome_1\bin\launch.exe c:\app\product\12.2.0\dbhome_1\bin dbua.cl
and I run from the wizard the preupgrade check and it worked.
SET ORACLE_BASE=c:\app\jreyes
SET ORACLE_HOME=C:\app\jreyes\product\12.1.0.1.13\dbhome_1
C:\app\jreyes\product\11.2.0\dbhome_1\jdk\bin\java -jar C:\app\product\12.2.0\dbhome_1\rdbms\admin\preupgrade.jar FILE TEXT DIR D:\TEMPD
ERROR - Unable to run sqlplus due to:
ORA-01017:
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
Solution:
I ran
C:\app\product\12.2.0\dbhome_1\bin\launch.exe c:\app\product\12.2.0\dbhome_1\bin dbua.cl
and I run from the wizard the preupgrade check and it worked.
Suscribirse a:
Entradas (Atom)