Home » RDBMS Server » Server Administration » Dumb Noobie Question (sorry)
Dumb Noobie Question (sorry) [message #136720] Fri, 09 September 2005 12:26 Go to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Hello!

I have been trying to set up a local DB on my laptop so I can practice coding some SQL and testing D2K stuff away from the office. I have installed Oracle 9i D2K and 9i RDBMS on my laptop. I really need some help configuring the database so that I can "trick" the computer into thinking the server is on my local harddrive. I really am weak in networking skills and I wonder if anybody has set up this type of relationship before and if so, could you point me in the right direction? Even some documentation would be great. Thanks in advance!

Regards,
Steve
Re: Dumb Noobie Question (sorry) [message #136721 is a reply to message #136720] Fri, 09 September 2005 12:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I dont understand the issue.
You have a laptop.
You have installed oracle 9i database in laptop.
You have installed Developer 2000 in laptop.
Am i with you?
For a local connection (database server and client in the same machine)
you no need a tns-service name at all (works good for sqlplus. Used TO be also for D2k. Never checked it lately).
you can connect to datbase like
sqlplus scott/tiger

If you want to use tns entries, then create listener,add entries in tnsnmemes.ora and use
sqlplus scott/tiger@yourdb

Every client will have its own tnsnames.ora
So make sure you update the tnsnames.ora that D2K is using

Re: Dumb Noobie Question (sorry) [message #136723 is a reply to message #136721] Fri, 09 September 2005 12:42 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Yes, you've followed me appropriately. I will try to log in this evening and see if I can connect once I adjust the TNSNames file. I thought there was more configuration that would need to be done, but if I understand your response correctly, I should be ready to go?

Thank you for taking the time.

Regards,
Steve
Re: Dumb Noobie Question (sorry) [message #136726 is a reply to message #136720] Fri, 09 September 2005 12:46 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I don't think it is needed in your case (Mahesh already answered) but in case you do need the server name, you can generally use "localhost" as a "server name" for your pc/laptop.
Previous Topic: ORA-27101: Shared memory realm does not exist
Next Topic: 9i: Data dictionary views does exists
Goto Forum:
  


Current Time: Fri Jan 10 10:38:05 CST 2025