Did you build a TNSNAMES.ORA file on the client? If you didn't click on the
Oracle icon in the start menu and find the NET8 Easy icon (I might have the
name wrong, but it should be second or third from the bottom) and use it to
build the TNSNAMES.ORA file which is used to validate the arguments you
supply. If I remember correctly you have to supply an alias (the name you
want to call the database), the communications protocol, the address/name of
the server, and the SID.
regards
Jerry Gitomer
Greg wrote in message ...
>I'm having awful trouble with 8.04.00 on the client side.
>
>I've installed a new DB (called "app2") on the NT server, running 8.04
>also. I installed the client side from the same CD on one of my 98
>machines on the same LAN as the server.
>
>I used Oracle's "database assistant" to create the DB. No problem.
>
>Now I cannot connect to this DB in any form or fashion. Even from the
>server. I'm asked by Oracle's tools the user id, password and either one
>of the following depending on which tool I'm using (I.e. : SQL Plus, Ent
>Manager etc):
>- Service
>- SID
>- Host String
>- Connect String
>- Server
>
>I've tried about everything and every combination of "app2" I can think
>of. There is no "ORACLE_SID" env var in either my NT server or my 98
>machine. I give up.
>
>What command, or tool will show me all DB's installed on that server?
>How do I display what remotes' expect for a connect string for a
>particular DB?
>
>Greg
>--
>Advertisers using spambots, please don't send to the following addresses:
>president_at_whitehouse.gov vice.president_at_whitehouse.gov
first.lady_at_whitehouse.gov consumerline_at_ftc.gov crc_at_ftc.gov fraud_at_uspis.gov
uce_at_ftc.gov rhunt_at_fcc.gov jquello_at_fcc.gov sness_at_fcc.gov rchong_at_fcc.gov
customer_at_usps.gov admin_at_HARRIS-MARKETING.COM postmaster_at_HARRIS-MARKETING.COM
jmorton_at_SAVOYNET.COM postmaster_at_agis.net abuse_at_agis.net root_at_agis.net
dns-admin_at_AGIS.NET noc_at_AGIS.NET hostmaster_at_agis.net pat.connally_at_state.co.us
phil_at_agis.net webmaster_at_agis.net
>postmaster_at_localhost info_at_tsf-industries.com protect_at_atg.wa.gov
lemon_at_atg.wa.gov monopoly_at_atg.wa.gov utility_at_atg.wa.gov c4enviro_at_atg.wa.gov
emailago_at_atg.wa.gov kea_at_cognigen.com
>document_at_agis.net ip-request_at_agis.net routing_at_agis.net news_at_agis.net
accounting_at_agis.net info_at_agis.net aapp_at_agis.net hr_at_agis.net
emailer_at_qlink2info.com simrem_at_answerme.com hostmaster_at_INREACH.COM
ap_at_INREACH.COM postmaster_at_EMAILDIRECT.NET abuse_at_EMAILDIRECT.NET
root_at_EMAILDIRECT.NET postmaster_at_e-bizness.com abuse_at_e-bizness.com
root_at_e-bizness.com comics_at_IAW.ON.CA maxemail_at_UNITED-CBE.ORG
domreg_at_EMAILDIRECT.NET domreg_at_HOSTING.NETCOM.COM bobgalena_at_EARTHLINK.NET
>sales_at_marketingmasters.com bizpro_at_SOFTCOM.NET domreg_at_HOSTING.NETCOM.COM
aral_at_ADDITIONALBENEFITS.COM
Received on Thu May 27 1999 - 07:49:22 CDT