N
N
Nikolai Shvetsov2016-06-29 01:04:21
linux
Nikolai Shvetsov, 2016-06-29 01:04:21

Can't connect to Oracle database, ORA error - 12154?

Installed java, executed ojdbc6.jar (if 14 then manifest error). When connecting via php, it gives an ORA error - 12154. Code to the studio:
oci_connect('test_user','test_user','jdbc:oracle:thin:@//10 .xx.xx.xx:1521/test');
through PHPStorm everything connects normally through ojdbc6.jar.
Oracle11g base.Need help me.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
DuD, 2016-06-29
@DuD

And here ojdbc6.jar if you work with orakl through php?
12154 - service name is not resolved. Check if you are connecting via SERVICE_NAME or via SID. Do you have tnsnames.ora configured.

N
Nikolay Shvetsov, 2016-06-29
@ShNn

yes, I looked, everything solved the error. The problem was in the syntax
: jdbc: oracle: thin:@//10.xx.xx.xx:1521/test
it is necessary: ​​//10.17.30.41:1521/m1oper_test

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question