Ora-12514/XE/Bank Client Server Connection

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
  

Poston Wed, 11 Jan 2017 4:36 pm

Good afternoon.

I'm trying to perform the connection to the database, between a notebook and a desktop (client) (server).
I have fixed the server IP.
Set up the tnsnames.ora to perform the connection.
Through the client can perform a ping on the server.
But when trying to connect to the server the ORA-12514 error is displayed.

Tnsnames.ora information are thus:
Code: Select all
EQUILIBRIUN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EQUILIBRIUN)
    )
  )
To read other forums here on page tried to perform some changes to the listner.ora, but without success, and still couldn't access the local bank. The last test I did was change:
Code: 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 IP of the server.

The services are all in the air, both on the server and the client.
Once informing the IP directly in tnsnames.ora didn't see the need to change the sqlnet.ora.

Any help you can provide will be greatly appreciated.
I appreciate the attention.
LeoGoncalves

Poston Wed, 11 Jan 2017 4:42 pm

Thread moved to [url = ://glufke http . net/oracle/. viewforum php? f = 6] DBA General
dr_gori
Location: Seattle, WA, USA

Thomas F. G

Poston Thu, 12 Jan 2017 7:22 am

Good morning Leo, make the following attempt.

1 return the change that you made in the LISTENER 2nd change the file sqlnet.ora SQLNET client. AUTHENTICATION_SERVICES = (NONE) If you don't resolve, 3rd change the Tnsnames.ora (SERVICE_NAME = EQUILIBRIUN) for (SID = EQUILIBRIUN) if it still doesn't work, they just my ideas.

Just a reminder, if I'm not mistaken, for a change in the LISTENER from the Bank to take effect, you need to take down and up the Bank.
spernega
Location: São Paulo - SP

Poston Thu, 12 Jan 2017 10:26 am

Spernega, thanks for your attention.

Did your first proposal: Returning the amendment made in the LISTENER and changing the sqlnet.ora file I couldn't connect.

After that, I made your second proposal: Changing the Tnsnames.ora and with that began to occur two errors: In connection with the local bank: ORA-12224 TNS no listener On the database connection on the server: ORA-12505 TNS listener can't determine the SID given in connect descriptor.

Remembering that rebooted the client machine to tip and up the Bank.
LeoGoncalves

Poston Thu, 12 Jan 2017 11:02 am

My options are running out.

The name SID or SERVICE_NAME EQUILIBRIUN is correct?

Tries to connect directly into the Bank and executes this select:
Code: Select all
select name from v$database;
if not EQUILIBRIUN, change your TNSNAMES, to try.

If it doesn't work, it is better to some real DBA to respond ...
spernega
Location: São Paulo - SP



Return to DBA General

Who is online

Users browsing this forum: No registered users and 4 guests