Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / PHP, Perl, Python [игнор отключен] [закрыт для гостей] / oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified) / 19 сообщений из 19, страница 1 из 1
24.06.2014, 16:58
    #38678788
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
Подскажите куда копать, при попытки законектится к базе oracle появляется ошибка
Код: php
1.
ORA-12154: TNS:could not resolve the connect identifier specified


CentOS 6.5, PHP Version 5.3.3, Apache 2.0, oci8 2.0.8
tnsping проходит (10 msec) plsql конектится. TNS_ADMIN, ORACLE_HOME прописаны.
...
Рейтинг: 0 / 0
24.06.2014, 17:57
    #38678870
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
мышки плакались, кололись, но продолжали не читать доки.
...
Рейтинг: 0 / 0
24.06.2014, 18:10
    #38678887
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowмышки плакались, кололись, но продолжали не читать доки.
А по существу.
...
Рейтинг: 0 / 0
25.06.2014, 12:09
    #38679540
alex564657498765453
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
Chek_FedorScareCrowмышки плакались, кололись, но продолжали не читать доки.
А по существу.

Незнаю какое существо тебе надо, но гугл сразу выдаёт

http://ora-12154.ora-code.com/

или тебе перевести что там написано? или угадать какая из возможных причин у тебя?
...
Рейтинг: 0 / 0
25.06.2014, 14:20
    #38679743
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
Использую TNSNAMES.ORA который лежит в /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
В SQLNET.ORA
Код: php
1.
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)


tnsping проходит
sqlplus подключается
Если
Код: php
1.
sqlplus подключается


то в TNSNAMES.ORA ошибок нет...
phpinfo(); часть

TNS_ADMIN /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
также делал
TNS_ADMIN /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
...
Рейтинг: 0 / 0
25.06.2014, 15:04
    #38679840
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ну тоесть доку ты читать категорически отказываешься?
...
Рейтинг: 0 / 0
25.06.2014, 15:09
    #38679850
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowну тоесть доку ты читать категорически отказываешься?
Ткни в нее. Гугл на запрос ORA-12154: TNS:could not resolve the connect identifier specified рою сделал как мне кажется все что там написано.
...
Рейтинг: 0 / 0
25.06.2014, 15:45
    #38679933
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
показывай phpinfo
...
Рейтинг: 0 / 0
25.06.2014, 15:51
    #38679951
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
phpinfo();


PHP Logo
PHP Version 5.3.3

System Linux localhost.localdomain 2.6.32-431.17.1.el6.x86_64 #1 SMP Wed May 7 23:32:49 UTC 2014 x86_64
Build Date Dec 11 2013 03:30:35
Configure Command './configure' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' '--without-sqlite' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' '--without-sqlite3' '--disable-phar' '--disable-fileinfo' '--disable-json' '--without-pspell' '--disable-wddx' '--without-curl' '--disable-posix' '--disable-sysvmsg' '--disable-sysvshm' '--disable-sysvsem'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc
Loaded Configuration File /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
Additional .ini files parsed /etc/php.d/curl.ini, /etc/php.d/dom.ini, /etc/php.d/fileinfo.ini, /etc/php.d/gd.ini, /etc/php.d/json.ini, /etc/php.d/mbstring.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/phar.ini, /etc/php.d/sqlite3.ini, /etc/php.d/wddx.ini, /etc/php.d/xmlreader.ini, /etc/php.d/xmlwriter.ini, /etc/php.d/xsl.ini, /etc/php.d/zip.ini
PHP API 20090626
PHP Extension 20090626
Zend Extension 220090626
Zend Extension Build API220090626,NTS
PHP Extension Build API20090626,NTS
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support enabled
Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies

PHP Credits
Configuration
apache2handler
Apache Version Apache/2.2.15 (CentOS)
Apache API Version 20051115
Server Administrator localhost
Hostname:Port employees.nationalpurchasingpartners.com:0
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 60 - Keep-Alive: 15
Virtual Server Yes
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_auth_basic mod_auth_digest mod_authn_file mod_authn_alias mod_authn_anon mod_authn_dbm mod_authn_default mod_authz_host mod_authz_user mod_authz_owner mod_authz_groupfile mod_authz_dbm mod_authz_default util_ldap mod_authnz_ldap mod_include mod_log_config mod_logio mod_env mod_ext_filter mod_mime_magic mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_substitute mod_rewrite mod_proxy mod_proxy_balancer mod_proxy_ftp mod_proxy_http mod_proxy_ajp mod_proxy_connect mod_cache mod_suexec mod_disk_cache mod_cgi mod_version mod_dnssd mod_php5 mod_ssl

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
HTTP_HOST localhost:8080
HTTP_USER_AGENT Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_COOKIE PHPSESSID=bn6lmqc59c9pquqbe7kuluhhl3
HTTP_CONNECTION keep-alive
HTTP_CACHE_CONTROL max-age=0
PATH /sbin:/usr/sbin:/bin:/usr/bin
SERVER_SIGNATURE <address>Apache/2.2.15 (CentOS) Server at localhost Port 8080</address>
SERVER_SOFTWARE Apache/2.2.15 (CentOS)
SERVER_NAME localhost
SERVER_ADDR ::1
SERVER_PORT 8080
REMOTE_ADDR ::1
DOCUMENT_ROOT /var/www/demo
SERVER_ADMIN localhost
SCRIPT_FILENAME /var/www/demo/index.php
REMOTE_PORT 40203
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /
SCRIPT_NAME /index.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET / HTTP/1.1
Host localhost:8080
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-US,en;q=0.5
Accept-Encoding gzip, deflate
Cookie PHPSESSID=bn6lmqc59c9pquqbe7kuluhhl3
Connection keep-alive
Cache-Control max-age=0
HTTP Response Headers
X-Powered-By PHP/5.3.3
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8

bz2
BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.5, 10-Dec-2007

calendar
Calendar support enabled

Core
PHP Version 5.3.3

Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 22527 22527
exit_on_timeout Off Off
expose_php On On
extension_dir /usr/lib64/php/modules /usr/lib64/php/modules
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors Off Off
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.enable_gc On On

ctype
ctype functions enabled

curl
cURL support enabled
cURL Information 7.19.7
Age 3
Features
AsynchDNS No
Debug No
GSS-Negotiate Yes
IDN Yes
IPv6 Yes
Largefile Yes
NTLM Yes
SPNEGO No
SSL Yes
SSPI No
krb4 No
libz Yes
CharConv No
Protocols tftp, ftp, telnet, dict, ldap, ldaps, http, file, https, ftps, scp, sftp
Host x86_64-redhat-linux-gnu
SSL Version NSS/3.15.3
ZLib Version 1.2.3
libSSH Version libssh2/1.4.2

date
date/time support enabled
"Olson" Timezone Database Version 0.system
Timezone Database internal
Default timezone America/Los_Angeles

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value

dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.7.6
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

ereg
Regex Library Bundled library enabled

exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15

fileinfo
fileinfo support enabled
version 1.0.5-dev

filter
Input Validation and Filtering enabled
Revision $Revision: 298196 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.34 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.3.11
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 6b
PNG Support enabled
libPNG Version 1.2.49
WBMP Support enabled
XPM Support enabled
XBM Support enabled

Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

gettext
GetText Support enabled

gmp
gmp support enabled
GMP version 4.3.1

hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.12

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1

json
json support enabled
json version 1.2.1

libxml
libXML support active
libXML Compiled Version 2.7.6
libXML Loaded Version 20706
libXML streams enabled

mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) backtrack check On
Multibyte regex (oniguruma) version 4.7.1

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.73
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli
MysqlI Support enabled
Client API library version 5.1.73
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.1.71
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off

oci8
OCI8 Support enabled
OCI8 DTrace Support disabled
OCI8 Version 2.0.8
Revision $Id: f04114d4d67cffea4cdc2ed3b7f0229c2caa5016 $
Oracle Run-time Client Library Version 12.1.0.1.0
Oracle Compile-time Instant Client Version 12.1

Directive Local Value Master Value
oci8.connection_class no value no value
oci8.default_prefetch 100 100
oci8.events Off Off
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics Off Off
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20

Statistics
Active Persistent Connections 0
Active Connections 0

openssl
OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.0.1e-fips 11 Feb 2013
OpenSSL Header Version OpenSSL 1.0.1e-fips 11 Feb 2013

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.8 2008-09-05

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000

PDO
PDO support enabled
PDO drivers mysql, sqlite

pdo_mysql
PDO Driver for MySQL enabled
Client API version 5.1.73

pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.6.20

Phar
Phar: PHP Archive support enabled
Phar EXT version 2.0.1
Phar API version 1.1.1
SVN revision $Revision: 298908 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
Native OpenSSL support enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On

Reflection
Reflection enabled
Version $Revision: 300393 $

session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn Off Off
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php/session /var/lib/php/session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies On On
session.use_trans_sid 0 0

shmop
shmop support enabled

SimpleXML
Simplexml support enabled
Revision $Revision: 299424 $
Schema support enabled

sockets
Sockets Support enabled

SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

sql_relay
Version 0.55

sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.6.20

Directive Local Value Master Value
sqlite3.extension_dir no value no value

standard
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value

tokenizer
Tokenizer Support enabled

wddx
WDDX Support enabled
WDDX Session Serializer enabled

xml
XML Support active
XML Namespace Support active
libxml2 Version 2.7.6

xmlreader
XMLReader enabled

xmlwriter
XMLWriter enabled

xsl
XSL enabled
libxslt Version 1.1.26
libxslt compiled against libxml Version 2.7.6
EXSLT enabled
libexslt Version 1.1.26

zip
Zip enabled
Extension Version $Id: php_zip.c 300470 2010-06-15 18:48:33Z pajoye $
Zip version 1.9.1
Libzip version 0.9.0

zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules
Module Name

Environment
Variable Value
TERM xterm
PATH /sbin:/usr/sbin:/bin:/usr/bin
PWD /
LANG C
SHLVL 2
_ /usr/sbin/httpd
ORACLE_HOME /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1
TNS_ADMIN /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
LD_LIBRARY_PATH /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/lib
ORACLE_INSTANCE /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/instantclient

PHP Variables
Variable Value
_COOKIE["PHPSESSID"] bn6lmqc59c9pquqbe7kuluhhl3
_SERVER["HTTP_HOST"] localhost:8080
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Firefox/24.0
_SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_COOKIE"] PHPSESSID=bn6lmqc59c9pquqbe7kuluhhl3
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_CACHE_CONTROL"] max-age=0
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.15 (CentOS) Server at localhost Port 8080</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.2.15 (CentOS)
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_ADDR"] ::1
_SERVER["SERVER_PORT"] 8080
_SERVER["REMOTE_ADDR"] ::1
_SERVER["DOCUMENT_ROOT"] /var/www/demo
_SERVER["SERVER_ADMIN"] localhost
_SERVER["SCRIPT_FILENAME"] /var/www/demo/index.php
_SERVER["REMOTE_PORT"] 40203
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /
_SERVER["SCRIPT_NAME"] /index.php
_SERVER["PHP_SELF"] /index.php
_SERVER["REQUEST_TIME"] 1403696919

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

...
Рейтинг: 0 / 0
25.06.2014, 15:59
    #38679970
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
теперь из консоли, из того места где работает TNSPING пишешь env и выкладываешь что выведет.
...
Рейтинг: 0 / 0
25.06.2014, 16:13
    #38679991
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowтеперь из консоли, из того места где работает TNSPING пишешь env и выкладываешь что выведет.

ORBIT_SOCKETDIR=/tmp/orbit-user
HOSTNAME=localhost.localdomain
GIO_LAUNCHED_DESKTOP_FILE_PID=13009
TERM=xterm
SHELL=/bin/bash
XDG_SESSION_COOKIE=b104f8f12b1aff60597597590000001b-1403601858.476669-718846715
HISTSIZE=1000
GTK_RC_FILES=/etc/gtk/gtkrc:/home/user/.gtkrc-1.2-gnome2
WINDOWID=35666524
OLDPWD=/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
USER=user
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
LD_LIBRARY_PATH=/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/lib
GNOME_KEYRING_SOCKET=/tmp/keyring-3igD9y/socket
SSH_AUTH_SOCK=/tmp/keyring-3igD9y/socket.ssh
SESSION_MANAGER=local/unix:@/tmp/.ICE-unix/2290,unix/unix:/tmp/.ICE-unix/2290
USERNAME=user
GIO_LAUNCHED_DESKTOP_FILE=/home/user/Desktop/gnome-terminal.desktop
MC_TMPDIR=/tmp/mc-root
TNS_ADMIN=/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
DESKTOP_SESSION=gnome
MAIL=/var/spool/mail/user
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/user/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin
PWD=/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin
GDM_KEYBOARD_LAYOUT=us
LANG=en_US.UTF-8
GNOME_KEYRING_PID=2279
GDM_LANG=en_US.UTF-8
GDMSESSION=gnome
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HISTCONTROL=ignorespace
HOME=/root
SHLVL=4
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
MC_SID=59372
LOGNAME=user
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-DTWR810ouI,guid=5a0cbe7bb26ecc2ddbf2bfdc0000021c
LESSOPEN=|/usr/bin/lesspipe.sh %s
WINDOWPATH=1
DISPLAY=:0.0
ORACLE_HOME=/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1
G_BROKEN_FILENAMES=1
XAUTHORITY=/root/.xauthTCTlQM
COLORTERM=gnome-terminal
_=/usr/bin/env
...
Рейтинг: 0 / 0
25.06.2014, 16:17
    #38680001
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
еще вопросы?
...
Рейтинг: 0 / 0
25.06.2014, 16:50
    #38680076
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowеще вопросы?
Один, что не так?
...
Рейтинг: 0 / 0
25.06.2014, 16:56
    #38680083
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
пишешь env grep oracle
и делашеim в phpinfo так же
...
Рейтинг: 0 / 0
25.06.2014, 17:20
    #38680131
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowпишешь env grep oracle
и делашеim в phpinfo так же
Не помогло
Код: php
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
Environment
Variable	Value
TERM 	xterm
PATH 	/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/user/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin:/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin
PWD 	/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin
LANG 	C
SHLVL 	2
_ 	/usr/sbin/httpd
OLDPWD 	/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
LD_LIBRARY_PATH 	/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/lib
TNS_ADMIN 	/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
ORACLE_HOME 	/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1 


В строке TNSNAME.ORA нет SID это критично?
...
Рейтинг: 0 / 0
25.06.2014, 21:51
    #38680338
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
Такое ощущение, что что-то не докрутил с правами на папки и файлы oracle. Oracle ставился из под пользователя "oracle" apache из под рута. Скрипт запускаю из под рута. Какие права нужно выставить?
Код: php
1.
echo system("/home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnsping ORAS1")


ругается
Код: php
1.
 /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnsping: Permission denied


Хотя это может и не имеет никакого отношения к oci_connect.
P.S. Может перенести тему в Unix
...
Рейтинг: 0 / 0
26.06.2014, 00:17
    #38680388
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
авторКакие права нужно выставить?
ставь 777, потом разберешься.
...
Рейтинг: 0 / 0
26.06.2014, 00:18
    #38680390
ScareCrow
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
автор Скрипт запускаю из под рута.

врешь ведь.

$user_info=posix_getpwuid(posix_getuid());
echo $user_info['name'];

или
posix_getlogin()
...
Рейтинг: 0 / 0
26.06.2014, 13:48
    #38680806
Chek_Fedor
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
ScareCrowавтор Скрипт запускаю из под рута.

врешь ведь.

$user_info=posix_getpwuid(posix_getuid());
echo $user_info['name'];

или
posix_getlogin()
Точно вру. скрипт на
Код: php
1.
get_current_user();


выдал nobody
Выставил права 777 на /home/oracle
и заработало все putenv() удалил все работает Спасибо
...
Рейтинг: 0 / 0
Форумы / PHP, Perl, Python [игнор отключен] [закрыт для гостей] / oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified) / 19 сообщений из 19, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]