Oracle occurs connect problem Identifier is Too long

Asked

Viewed 797 times

2

I have the following problem, first setting up my PC.

OS: Fedora 20

PHP 5.5

Oracle Instant Client: 11.2.0.4.0

I try to connect via file settings tnsnames.ora and the following error occurs

ORA-12169: TNS:Net service name given as connect identifier is too long

To connect in PHP I use the extension idle with the version oci8-2.0.6

The string is actually large, but in SQL Developer it connects normally.

php oracle
  • 1

    Is it possible to decrease this string? nahttp://docs.oracle.com/cd/E11882_01/server.112/e17766/net12150.htm#ORA-12169 speaks of a limit of 255 characters

  • Worse that does not give, because it is necessary to redundancy, because there are many users connecting at the same time

  • I think I found the problem, after a lot of searching, the problem apparently is that the file was created in windows where it has CR/LF and linux only LF, just convert to default file on Linux and works properly.

  • Igor, I suggest you answer your own question. It may make things easier if someone has a similar problem and comes across this issue. Taking the opportunity to leave my opinion worth only 2 cents, I believe this is a bug. At the very least, the error code should be different, and I believe that the ORA-12154 and ORA-12162 are more appropriate.

1 answer

1

I think I found the problem, after a lot of searching, the problem apparently is that the file was created in windows where it has CR/LF and linux only LF, just convert to default file on Linux and works properly.

Browser other questions tagged php oracle

You are not signed in. Login or sign up in order to post.