Error when connecting from Windows 2008 Server.

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
targinosilveira
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Tue, 16 Sep 2008 5:56 pm
Location: Fortaleza - CE

Good afternoon guys, I'm having some problems, I installed Oracle Xe on a Windows 2008 Server RC2 machine, but I can not access it well or network.

To take a test I performed the tnsping and it returns the following error:

Select all

 
C:\Users\Zevallos>TNSPING UNIDENTAL 
 
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-MAY-2 
010 12:31:20 
 
Copyright (c) 1997, 2005, Oracle.  All rights reserved. 
 
Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-035 
05: Message 3505 not found; No message file for product=NETWORK, facility=TNS 
I have been seeing that what It can cause this to be the environment variables, but they are being declared correctly.

Someone has a light so you can help me?

Sincerely,


Environment information:
* 10g xe
* Windows Server 2008RC2
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Select all

sqlplus "/ as sysdba"
Connect?

In the documentation does not say Windows 2008 ..
Operating System

One of the following 32-bit Windows Operating Systems:

* Windows 2000 Service Pack 4 or Later
Windows Server 2003
* Windows XP Professional Service Pack 1 or later

= /

If it is only for learning, I could install XE in a virtual machine with Windows XP or Linux, (if Linux learned would be very interesting)

Any progress posts there for us to know ...
targinosilveira
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Tue, 16 Sep 2008 5:56 pm
Location: Fortaleza - CE

Worse than not expensive, it just opens the sqlplus window and closes it at the same time without even at least any error message.

:( I am practically believing that not supported by Windows 2008 Server.

Hugs.
diegopedrao
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 164
Joined: Fri, 22 Aug 2008 12:28 pm
Location: SP

Diegolenhardt,

Download the 10G Enterprise version or make a VM, but for learning I would recommend Enterprise on Linux.


Att,

Diego Monteiro
targinosilveira
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Tue, 16 Sep 2008 5:56 pm
Location: Fortaleza - CE

The other bad news is that it is not learning :) rsrsrsrs
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

diegopedrao wrote: Diegolenhardt,

Download the 10G Enterprise version or make a VM, but for learning I would recommend Enterprise on Linux.


Att,

Diego Monteiro



It is not for me, rsrs

Here in the trap I have on my local machine a virtual machine in the VMware Workstation 7, Oracle Enterprise Linux 5, X86 with 5 bases in the ASM, everything to restore backups, tests, etc ...

Ball show, works well


=)
targinosilveira
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 45
Joined: Tue, 16 Sep 2008 5:56 pm
Location: Fortaleza - CE

Well personal now is in the following condition:

I installed the oracle on a machine with Windows Server 2003 (192.168.0.3) that is served as our server for development, in the machine itself as server I I can connect locally via SQLPlus and also to another Oracle bank via network.

When connecting to the production server everything works OK, but when I will connect to the development server it gives an error that calls some unsecured debug on the PC or generates those error reports.

And if I use the application in Forms it only closes.

any light?

If I give a tnsping as follows:

Select all

 
tnsping unidental 

Select all

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-MAI-2010 11:00:15 
 
Copyright (c) 1997, 2005, Oracle.  All rights reserved. 
 
Arquivos de parÔmetros usados: 
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora 
 
 
Usado o adaptador TNSNAMES para resolver o apelido 
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = XE 
))) 
OK (60 ms)

Note : Here in the company runs a system done in forms and I came to migrate it from forms to php but for now I need to fix some things in the forms so still need to be opening connection between the client machine and the servant machine.

Sincerely,
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest