Connecting to oracle

Customer Support Database Support
1

I already have an oracle subscription, which I can connect to through the oracle control panel, but I am unable to connect to the database from any appliaction. I have tried, my tnsnames.ora:
Jodo.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 8.10.3.98)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = JODO)
)
)

incluedes the follorwing definition, without success - connecting to other Oracle databases, remotely, is not a problem.

Any ideas,

Best wishes,

Valgar?ur Gu?j?nsson

2

What language is this using? PHP?

3

No language, just trying to connect to the database from SQLPlus.

4

Use SID=jodo

That should work, one customer reported that as the issue to us

5

Thanks, but I believe I need an address for the server as well, in any case I’ve tried this

6

I have a client that is trying to connect using SQLPLUS did we solve this. They want to connect via TOAD too.

7

We have alarge number of people connecting andusing it successfully. I will point the oracle DBA to this topic and see if we can address this issue specifically.

8

Stephen that is a none answer. Can you point me to someone who is using something other then the online control panel? I haven’t found anyone who has used this before.

Can you point me to someone on your end who can give me some pointers on what needs to go where to make it work? All I am saying is that my user can’t connect from a 3rd party. Point me to some examples of other users that are connecting.

9

We have other customers connecting via SQL*Plus and websites, but I can not give the urls, as 1. I don’t remember them, we worked them in tickets, and 2. we don’t have their permissions to give them out.

Sunil, the Oracle DBA will be able to answer this question and possible give you an example, as I personally do not know Oracle, but he knows it very well.

10

When does Sunil come in?

11

Sunil is actually in now, but he just told me in order to connect with SQLPLUS you will need to create a TNSNAMES.ora

It needs to be like this:
JODO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 8.10.3.98)(PORT = 1521))
)
(CONNECT_DATA =
(SID = jodo)
(SERVER = SHARED)
)
)

12

I will let my user know…

Next thing is they are pressing me with the multiple login thing. I posted a message http://support.jodohost.com/showthread.php?t=4260

if you can look at it.