oracle login information

Hi
Please tell me how to login to oracle 8i plus.
it asks for username,password and hoststring..
i entered scott,tiger and oracle respectively.it gave error.please help
uma
uma_prabhakarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RCorfmanCommented:
what error?
uma_prabhakarAuthor Commented:
i am getting packet not found something error....
I and my husband forgot the host string....
uma
RCorfmanCommented:
Look for tnsnames.ora on your computer in your oracle home directory in network/admin. Probably under the c:/oraclient817/network/admin/tnsnames.ora. In this you will find entries that have something like :

yourdb=(DESCRIPTION=
      (ADDRESS=
blah, blah blah )

The part before the first = is the hostname.
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

eric81Commented:
Try this on your command prompt

sqlplus username@(description=(address=(protocol=tcp)(host=localhost)(port=1521))(connect_data=(sid=sid_here)))

If you install the oracle on your local pc and follow the procedure, it should not be a problem.

Attention to host (localhost if you installed it locally), port number (default is 1521), sid (here is what name you given to the database).
Look at tnsnames.ora to ensure. But dont modify it.


Hope this gives some enlightmensts.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
uma_prabhakarAuthor Commented:
Eric your command worked at the command prompt.I could login to sql but that is at the Dos level.How do i do the same with windows...
One more problem is i tried to execute a VB6 executable file(exe file) .It gives runtime error 3706 .Says 'provider cannot be found'
what could be the problem.i want to run this application.
RCorfmanCommented:
YOu need to find the tnsnames.ora file, then put that same entry that eric81 gave you into the tnsnames.ora file.

sid_here=(description=(address=(protocol=tcp)(host=localhost)(port=1521))(connect_data=(sid=sid_here)))

You should then be able to log in using your userid, password, and sid_here

Note that if you don't want to change the tnsnames.ora, you can use the same within all products.
Where it prompts for userid, you can put in the same sutff that eric81 had you use.

That was why I was asking about what the entry was in the tnsnames.ora. That is where you put in a shortcut name with all the information to connect.
schwertnerCommented:
user: sys
password: change_on_install

On Windows level find in Programs ----> SQL*Plus and start it.
Before this find the tnsnames.ora file (if many look in the file where the Oracle software resides).
and investigate the host string.

After that login answering on the popup window.
uma_prabhakarAuthor Commented:
The same error i am getting still.i have still not got the answer.
I copied the above and pasted in tnsnames.ora . Now sql is working .But my vb application is not.Someone please tell me
IT gives 3706 runtime error.and says 'Provider not found'.i cant execute the file further
anybody?
RCorfmanCommented:
Are you trying to use an ODBC connection? If so, you need to assure that you have the ODBC installed and have properly specified the username/password/SERVICE NAME as appropriate.
RCorfmanCommented:
This has information on connecting with ado... I don't know if that is what you are using
http://www.experts-exchange.com/Databases/Oracle/Q_21604419.html
uma_prabhakarAuthor Commented:
I dont so much internals of vb whatever u r talking about....Yesterday i have entered the script which was posted on this site in my tnsnames.ora.i entered username as scott,password as tiger and host string blank.
It logged into sql>
I tried to execute my vb application which was developed on a different pc .It is not running on my machine.
How do i check the odbc connectivity.How do i do the checking whatever u mentioned.let me know steps
uma
RCorfmanCommented:
There are a ton of other EE PAQ items that refer to how to resolve the error you are receiving when connecting VB to Oracle. If the three links above do not help, below is the search that I used to find those three, there are many others. Hopefully you will be able to get an anwer. Since we know you can connect with sql*plus, we know the Oracle client is installed, it may be that the ODBC driver is missing.
If you go to Control Panel--> Administrative Tools-->Data Source (ODBC), there should be a Drivers Tab (This is on XP, it may be slightly different in other Windows Environments).  There should be a driver for "Oracle ODBC Driver" or "Microsoft ODBC for Oracle".  If neither of these are present, you need to get one installed, if so, then you can configure and odbc connection there. That would be the DSN that you use if you go this route.

I believe it is also possible to configure this in ADO/VB directly, but, as I mentioned, I don't know VB, but there are similar questions on EE, maybe one of these has the solution you seek?

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_21336883.html

http://www.experts-exchange.com/Databases/Oracle/Q_20755300.html#9484650

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_21077573.html#11898864


There are a ton of other EE PAQ items that refer to how to resolve the error you are receiving when connecting VB to Oracle. If the three links above do not help, below is the search that I used to find those three, there are many others. Hopefully you will be able to get an anwer. Since we know you can connect with sql*plus, we know the Oracle client is installed, it may be that the ODBC driver is missing.

http://search.experts-exchange.com/search.jsp?query=vb+connect+oracle+%22provider+cannot+be+found%22&searchType=all&Submit.x=44&Submit.y=9
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.