{"id":14139,"date":"2023-07-11T06:26:00","date_gmt":"2023-07-11T06:26:00","guid":{"rendered":"https:\/\/blog.bachi.net\/?p=14139"},"modified":"2023-07-13T10:07:34","modified_gmt":"2023-07-13T10:07:34","slug":"oracle","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=14139","title":{"rendered":"Oracle"},"content":{"rendered":"
\r\n\r\n\/*************************************************************************************\r\n * sqlplus: no TNS_ADMIN => error\r\n *\/\r\n\r\n$ ${ORACLE_HOME}\/bin\/sqlplus -L <user>@<servicename>\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 10 19:08:27 2023\r\nVersion 19.13.0.0.0\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nERROR:\r\nORA-12154: TNS:could not resolve the connect identifier specified\r\n\r\nSP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus\r\n\r\n\/*************************************************************************************\r\n * sqlplus: with TNS_ADMIN, TCPS using sqlnet.ora\/wallet => error, wallet not accessible (permission denied)\r\n *\/\r\n\r\n$ TNS_ADMIN=\/app\/tns ${ORACLE_HOME}\/bin\/sqlplus -L <user>@<servicename>\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 10 19:08:56 2023\r\nVersion 19.13.0.0.0\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nERROR:\r\nORA-28759: failure to open file\r\n\r\nSP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus\r\n\r\n\/*************************************************************************************\r\n * tnsping: with TNS_ADMIN, TCPS using sqlnet.ora\/wallet => error, wallet not accessible (permission denied)\r\n *\/\r\n$ TNS_ADMIN=\/app\/tns ${ORACLE_HOME}\/bin\/tnsping <servicename>\r\nTNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 11-JUL-2023 08:18:34\r\nCopyright (c) 1997, 2021, Oracle.  All rights reserved.\r\n\r\nUsed parameter files:\r\n\/app\/tns\/sqlnet.ora\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION_LIST= (LOAD_BALANCE=off) (FAILOVER=off) (DESCRIPTION= (CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3) (RETRY_COUNT=3) (ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS= (PROTOCOL=TCPS) (HOST=<hostname>) (PORT=1522))) (CONNECT_DATA= (SERVICE_NAME=<servicename>))))\r\n\r\nTNS-12560: TNS:protocol adapter error\r\n\r\n\/*************************************************************************************\r\n * tnsping: with TNS_ADMIN, TCP => ok\r\n *\/\r\n$ TNS_ADMIN=\/app\/tns ${ORACLE_HOME}\/bin\/tnsping <servicename>\r\n\r\nTNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 11-JUL-2023 09:52:39\r\n\r\nCopyright (c) 1997, 2021, Oracle.  All rights reserved.\r\n\r\nUsed parameter files:\r\n\/app\/tns\/sqlnet.ora\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION_LIST= (LOAD_BALANCE=off) (FAILOVER=off) (DESCRIPTION= (CONNECT_TIMEOUT=5) (TRANSPORT_CONNECT_TIMEOUT=3) (RETRY_COUNT=3) (ADDRESS_LIST= (LOAD_BALANCE=o) (ADDRESS= (PROTOCOL=TCP) (HOST=<hostname>) (PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=<servicename>))))\r\n\r\nOK (0 msec)\r\n\r\n\/*************************************************************************************\r\n * sqlplus: with TNS_ADMIN, TCP => ok\r\n *\/\r\n$ TNS_ADMIN=\/app\/tns ${ORACLE_HOME}\/bin\/sqlplus <user>@<servicename>\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 11 09:52:48 2023\r\nVersion 19.13.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nEnter password:\r\nLast Successful login time: Tue Jul 11 2023 07:18:44 +02:00\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.18.0.0.0\r\n\r\nSQL> exit\r\n<\/pre>\n
\r\nNLS_LANG=American_America.WE8ISO8859P1\r\nNLS_LANG=American_America.UTF8\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
\/************************************************************************************* * sqlplus: no TNS_ADMIN => error *\/ $ ${ORACLE_HOME}\/bin\/sqlplus -L <user>@<servicename> SQL*Plus: Release 19.0.0.0.0 – Production on Mon Jul 10 19:08:27 2023 Version 19.13.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus \/************************************************************************************* * sqlplus: with TNS_ADMIN, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-14139","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/14139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14139"}],"version-history":[{"count":6,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/14139\/revisions"}],"predecessor-version":[{"id":14146,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/14139\/revisions\/14146"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}