danielbaccin

Comandos uteis do oracle para obter configiurações:
Parâmetros da NLS:
=> Select * from nls_database_parameters
=> Select * from nls_session_parameters
=> Select * from nls_instance_parameters 

Exibe os valores de database_parameters
=> SELECT name,value$ from sys.props$ where name like '%NLS_LANG%'
=> SELECT name,value$ from sys.props$ where name like '%NLS_CHAR%'
=> SELECT name,value$ from sys.props$ where name like '%_CHARACTER%'

danielbaccin

-Dhttp.proxyHost=localhost -Dhttp.proxyPort=8800

danielbaccin

--rodar esse comando como system
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
--reiniciar o serviço do listener (OracleXETNSListener):

danielbaccin

update-alternatives --config [javac, java, javap, ...]

danielbaccin

-Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true
-Dcom.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump=true
-Dcom.sun.xml.ws.transport.http.HttpAdapter.dump=true
-Dcom.sun.xml.internal.ws.transport.http.HttpAdapter.dump=true

danielbaccin

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
sudo passwd postgres 
su postgres 
psql -c "ALTER USER postgres WITH PASSWORD 'nova_senha'" -d template1 

http://blog.patrickmaciel.com/instalando-o-postgresql-9-3-no-ubuntu-14-04-lts/
http://alcemirprogramador.blogspot.com.br/2013/07/liberando-acesso-remoto-postgresql.html

danielbaccin

-Djava.rmi.server.hostname=ip

danielbaccin

jdbc:jtds:sqlserver://IP/NOME_DO_BANCO;instance=NOME_DA_INSTANCIA

danielbaccin

select forcod, forcgc from FORNECEDOR where forcgc in(
select forcgc from FORNECEDOR group by forcgc having count(forcgc) > 1)

danielbaccin

Loga-se como autenticação do windows.
E executa-se a seguinte query:

sp_password @new = 'sa1234', @loginame=sa