473,473 Members | 1,821 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Sqlplus ora-12154

zorgi
431 Recognized Expert Contributor
Hi all

I am not sure how to approach to this problem. There is a Oacle database on some server on the local network. Database is only available through VPN. Now there is a need for this database to be available through internet connection but without moving it, as it will still be updated in the same way through VPN. My only problem is connecting to this database with PHP (I am total newbie when it comes to oracle). I found this Connecting to a Remote Oracle Database with PHP and the Oracle Instant Client, Bernie Zimmermann tutorial but I am not getting very far. Every time I try to connect to the database using sqlplus I get ERROR: ORA-12154: TNS:could not resolve the connect identifier specifid. Any ides what this might mean.

Thanks
Dec 1 '08 #1
1 4154
Pilgrim333
127 New Member
Hi,

Google gives you a lot of results on this specific error code. I suggest you try some of the solutions posted, if nothing helps you, please post again, with the actions you have already taken.

Pilgrim.
Dec 1 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Alex | last post by:
Hi Everybody, I am new to Oracle. I just installed the Oracle9i (personal edition) on my Window XP system. I am trying to simply run some basic SQL commands using SQLPlus. After entering...
4
by: Jan Bols | last post by:
Whenever I execute TRIM(' ')in a stored procedure or trigger, I get an ORA-03113 error. I have an oracle db 8.1.7.0.1 Enterprise edition installed on a linux-Mandrake 9.1. EXEMPLE: I...
1
by: Alan Brown | last post by:
Hi All, I've been trying to access an 8.1.6 oracle database, running on solaris 7, remotely from another solaris 7 server. The remote database server (on the same subnet, same vlan as the remote...
7
by: Cherrish Vaidiyan | last post by:
hello, I am been getting mad with so many doubts and errors.. I have posted some doubts,test cases regarding listener,replication and standby database.But i havent got any response..(I am...
0
by: BobG | last post by:
-- The issue This following query works fine on Toad and PowerBuilder yet when it is run on SQLPlus I get: "ORA-03113: end-of-file on communication channel" When I remove the distinct from the...
5
by: mivey4 | last post by:
Hi, First off, I am aware that this is a very heavily documented error and I have done my homework for throughly researching probable causes before deciding to post my problem here. At this point,...
3
nabh4u
by: nabh4u | last post by:
HI everyone, I an getting the following errors when i execute my procedure. SQL> exec PROCEDURE_NAME BEGIN PROCEDURE_NAME; END; * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error:...
4
by: kkcholan | last post by:
Sir Backend Oracle 9i Front end VB.Net O/s Windows 2003 Server Server Crashed due to power failure then the following error displays when connect to oracle database
1
by: umesh049 | last post by:
Hi i install oracle on my system but getting this error C:\Documents and Settings\umesh>sqlplus sys/123456 as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 19 11:51:32 2008 ...
0
by: wolfee | last post by:
I'm running 10gR2 RAC in Prod, Test and DEV and after doing a clone to the DEV environment I'm getting a wierd ORA-12514 error for only one node. I can tnsping the node and it comes back fine. ...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.