ORA-12514 / XE Bank / Connection Client Server

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
LeoGoncalves
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 11 Jan 2017 4:15 pm

Good afternoon.

I am trying to make the connection in the database, between a notebook (client) and a desktop (server).
I fixed the server IP.
Set the TNSNAMES.ORA to make the connection.
through the client I can perform a ping on the server.
However when attempting to connect the server the ORA-12514 error is displayed.

TNSNAMES.ORA information is like this:

Select all

 EQUILIBRIUN = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = EQUILIBRIUN) 
    ) 
  ) 
When reading other forums here on the page I tried to make some changes to the Lister.ora, But without success, and still could not access the local client's bank. The last change test I did was:

Select all

 LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = Usuario-PC)(PORT = 1521)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521)) 
    ) 
  ) 
 
includes the line with the server IP.

Services are all in the air, both on the server, and the client.
Once informing the IP directly on tnsnames.ORA did not see the need to change sqlnet.ora.

Any help they can provide, will be very welcome.
Thank you for your attention.
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Topic moved to [url=http://en.glufke.net/oracle/viewforum.php?f=6]DBA Geral
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

Good morning Leo,

Make the following attempt.

1º Return the change you made in Listener
2º Change the sqlnet.ora file in the client SQLNET.AUTHENTICATION_SERVICES= (NONE)

if not
3rd Change the TNSNAMES.ORA DE

Select all

(SERVICE_NAME = EQUILIBRIUN)
to

Select all

(SID = EQUILIBRIUN)
If it does not work, they ended my ideas .

Only one reminder, if I am not mistaken, for a change in the listener of the bank to take effect, need to knock down and lift the bank.
LeoGoncalves
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 11 Jan 2017 4:15 pm

Spernega, thanks for the attention.

I made your first proposal:
Returning the change I made in the listener and altering the sqlnet.ora file
I could not connect.

After that, I made your second proposal:
Changing TNSNAMES.ORA


And with this began to occur Two errors:

In connection with the local bank:

Select all

ORA-12224 TNS não há ouvinte
In connection with the bank on the server:

Select all

ORA-12505 TNS o ouvinte não pode determinar o SID fornecido no descritor de conexão.


Remembering that I restarted the client machine to knock down and lift the seat.
spernega
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Tue, 19 Jun 2007 2:12 pm
Location: São Paulo - SP

My options are ending ...

The name in the SID or Service_Name Equilibriun is correct?

tries to connect directly to the bank and performs this select:

Select all

 
select name from v$database;
if it is not equilibriun, change your tnsnames, to try.

If it does not work, there is better a real DBA to give an answer ...
Post Reply
  • Information
  • Who is online

    Users browsing this forum: Bing [Bot] and 6 guests