Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
Подскажите куда копать, при попытки законектится к базе oracle появляется ошибка Код: php 1. CentOS 6.5, PHP Version 5.3.3, Apache 2.0, oci8 2.0.8 tnsping проходит (10 msec) plsql конектится. TNS_ADMIN, ORACLE_HOME прописаны. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.06.2014, 16:58 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
мышки плакались, кололись, но продолжали не читать доки. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.06.2014, 17:57 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ScareCrowмышки плакались, кололись, но продолжали не читать доки. А по существу. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.06.2014, 18:10 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
Chek_FedorScareCrowмышки плакались, кололись, но продолжали не читать доки. А по существу. Незнаю какое существо тебе надо, но гугл сразу выдаёт http://ora-12154.ora-code.com/ или тебе перевести что там написано? или угадать какая из возможных причин у тебя? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 12:09 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
Использую TNSNAMES.ORA который лежит в /home/oracle/u01/app/oracle/product/12.2.0/dbhome_1/network/admin В SQLNET.ORA Код: php 1. tnsping проходит sqlplus подключается Если Код: php 1. то в 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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 14:20 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ну тоесть доку ты читать категорически отказываешься? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 15:04 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ScareCrowну тоесть доку ты читать категорически отказываешься? Ткни в нее. Гугл на запрос ORA-12154: TNS:could not resolve the connect identifier specified рою сделал как мне кажется все что там написано. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 15:09 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
показывай phpinfo ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 15:45 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
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. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 15:51 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
теперь из консоли, из того места где работает TNSPING пишешь env и выкладываешь что выведет. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 15:59 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
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 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 16:13 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
еще вопросы? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 16:17 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ScareCrowеще вопросы? Один, что не так? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 16:50 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
пишешь env grep oracle и делашеim в phpinfo так же ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 16:56 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ScareCrowпишешь env grep oracle и делашеim в phpinfo так же Не помогло Код: php 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. В строке TNSNAME.ORA нет SID это критично? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 17:20 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
Такое ощущение, что что-то не докрутил с правами на папки и файлы oracle. Oracle ставился из под пользователя "oracle" apache из под рута. Скрипт запускаю из под рута. Какие права нужно выставить? Код: php 1. ругается Код: php 1. Хотя это может и не имеет никакого отношения к oci_connect. P.S. Может перенести тему в Unix ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.06.2014, 21:51 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
авторКакие права нужно выставить? ставь 777, потом разберешься. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.06.2014, 00:17 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
автор Скрипт запускаю из под рута. врешь ведь. $user_info=posix_getpwuid(posix_getuid()); echo $user_info['name']; или posix_getlogin() ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.06.2014, 00:18 |
|
||
|
oci_connect (ORA-12154: TNS:could not resolve the connect identifier specified)
|
|||
|---|---|---|---|
|
#18+
ScareCrowавтор Скрипт запускаю из под рута. врешь ведь. $user_info=posix_getpwuid(posix_getuid()); echo $user_info['name']; или posix_getlogin() Точно вру. скрипт на Код: php 1. выдал nobody Выставил права 777 на /home/oracle и заработало все putenv() удалил все работает Спасибо ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.06.2014, 13:48 |
|
||
|
|

start [/forum/topic.php?fid=23&msg=38680806&tid=1462666]: |
0ms |
get settings: |
8ms |
get forum list: |
20ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
43ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
75ms |
get tp. blocked users: |
2ms |
| others: | 221ms |
| total: | 390ms |

| 0 / 0 |
