• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Oracle / Sql Plus confusion

J

Jago

n00b
Joined
Apr 2, 2004
Messages
43
The basics of this stupid question is: I installed Oracle (Enterprise Edition) to work at home for school work. Install went fine (Maybe I went to fast, which comes to the problem, maybe...)

I open SQL Plus, and The Username / Password / Host String field pops up. At school, we don't bother with the Host String feild so I guess that might be the problem here. But usually when you first install oracle, what is the user name and pass? At our school it's usually Scott/Tiger or System/cs... but when I try those I get this error:


Code: 
Ora-12560: TNS: protocol adapter error

Can anyone help? I'd greatly appreciate it.
 
Actually, pretty damn sad, but that didn't help at all. Needless to say, I couldn't find where to put that... :eek: So I decided to mess around somewhere..and it worked, I just looked around almost every program that came with it, and set up whatever... Thanks anyways though, I will use that site in the near future if I have any more errors! :)
 
sorry to bring back a dead thread, but some things that might help you in the future:

always make sure your TNS listener is running (it's a service in Windows, which I assume you're using).

also, the files you want to look at first when having tns protocol errors are in $ORACLE_HOME/network/admin

Specifically, tnsnames.ora Make sure you have entries in there that match your hostname/SID
 
It's alright, I needed to set this up for my whole class actually, :rolleyes: . It was something about setting up a database at the begining to begin with.Thank you anyways, I appreciate it :) .
 
You must log in or register to reply here.
Back
Top