Não finaliza o serviço do banco no Red Hat

Verificar se existem as linhas abaixo nos scripts de stop e start do oracle /etc/init.d/oraclestart RETVAL=$? echo [ $RETVAL -eq 0 ] && touch /var/lock/subsys/oraclestop RETVAL=$? echo [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/ora...

Read More

Instalar idioma "Português" no Oracle Portal

Executar da Mid:./ptllang.sh -i custom -s portal -sp password -c hostname:1521:servicename -lang...

Read More

Rotacionar ssl_request_log

Modificar no ssl.conf:CustomLog "|/u01/OraMid10g/Apache/Apache/bin/rotatelogs /u01/OraMid10g/Apache/Apache/logs/ssl_request_log 43200" "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" ...

Read More

IE 7/8 and Firefox + FORMS + Crash

Para resolver este problema, basta copiar o arquivo jvm.dll da sua JRE para o diretório hotspot do Jinitiator.Ex: De: C:\Program Files\Java\jre1.6.0_05\bin\client Para: C:\Program Files\Oracle\JInitiator 1.3.1.28\bin\hots...

Read More

connect and ORA-06553: PLS-801: internal error [56319] , After i duplicate database from 64bits to 32bits

sql>connect / as sysdbasql>shutdown immediate;sql>startup migrate;sql> @$ORACLE_HOME/rdbms/admin/utlirp.sqlsql>shutdown immediate;sql> startupsql>sql> @$ORACLE_HOME/rdbms/admin/utlrp.sqlsql> connect system/passw...

Read More

TO_CHAR + NLS

select to_char(sysdate,'MONTH','NLS_DATE_LANGUAGE = PORTUGUESE') from d...

Read More