SQL Plus connection problems

[phamilton99]

I am running Win 98 on IBM thinkpad with Oracle8 client installed.  Sql will connect to to the NT server no problem but I want to use this at home to practice selects and not be connected to my NT server at work.  I understand there is a way to trick the computer with a listener but am unsure how to do it.  Any ideas out there???

 

[Raji]

Please forgive me, if I understood your mail incorrectly, But could you please tell me to which DB you want to connect to at your home. I don't you have any DB there? are you.

 

[phamilton99]

I want to use SQL Plus without a network connection. The oracle SID is ORCL I believe but am not sure. Does Oracle not have a default database that is installed so you can login as Scott/tiger. I have done it before but can't remember how it is done. Does this help??

 

[MikeLacey]

it does, if you have Oracle Server installed on your NT box you can edit the %ORACLE_HOME%\network\admin\tnsnames.ora file which will point you towards the correct DB

 

[Guest_imported]

you can install Oracle Personal Edition to your IBM Thinkpad

 

[morka]

For me my first question is can u ping your server in the office from your house if yes what is the IP address of the server. if u know the IP address
You can do any of the following
1 if u have easy net8 configuration use it to crate a database allias with the ip address supplied and the SID of the Databese in your office Server then test to see that u can connect
2 if u dont have such tool then go to your Oracle home
i.e say c:\orant\net80\admin\tnsname.ora if u have N.T
or c:\ora95\net80\admin\tnsname.ora f u have 95/98
the modify chane as discuss above
let me know when u are through