Re: Newbie Question on SQL*Net

I don't know of any FAQ's, you might want to post specific questions/problems you have. Here is some info to help you out. On the Solaris Box (server): make sure your listener is turned on. As the UNIX Oracle User (usually Oracle), type: lsnrctl start at the Unix Prompt.

On the client side (Win 95): run SQL*NET easy configuration (click on start, program files, Oracle for win95). Add a database alias (mine is y2k). Choose TCP/IP. Instance name is the name of your Oracle Database Instance. Host name is our Solaris Box host name or IP address (use IP Address). Now when you want to use Enterprise manager, for example Security Manager. You type Username (this is the Oracle User name, like sys or system), password, service (which is your database alias, y2k in my case), connect as [normal, sysop, sysdba];Normal is default, if you want to use sysdba, you must run the orapwd command on the unix prompt and set a parameter up in your init<sid>.ora file.

Hopefully this general info helps you out, if you have specific questions, e- mail me and I'll help you out.

Good Luck,
Satar Naghshineh

In article <6ut7bf$li0$1_at_news.global.co.za>,   "Llewellyn Daniels" <llew_at_astgrp.co.za> wrote:
> Hello,
>
> We've got Oracle 7.3.3 running on Solaris 2.6 machines. Now I've installed
> EnterPrise Manager 1.3.5 on Windows 95 and would like to configure SQL*Net
> to connect to those Oracle instances and seem to have miss something
> somewhere. Is there a FAQ or document somewhere that discusses this point
> because the documentation does not seem to be clear
>
> Thanks
> Regards
>
> --
> Llewellyn Daniels
> e-mail - llew_at_astgrp.co.za
>
> --
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Sep 30 1998 - 13:28:51 CDT