Thanks Bruce.
That ifile part was the part I was missing.
(looks like the the closest I can get to a unix link)
I like the ifile implementation better than having
two copies of the init.ora.
Babette
-Original Message-
Bruce (CALBBAY)
Sent: Friday, August 17, 2001 12:21 AM
To: Multiple
Babette,
Bruce has the answer right-on regarding how NT starts Oracle services.
Another way to accomplish this is to use ORADIM to point to the
%oracle_home%\database\
directory. This is what I do so that I have one place to look for the
init.ora file. I personally do not like the -ifile
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Hi Rick,
I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Lisa,
Try:
SET ORACLE_SID
You should get:
ORACLE_SID='your_sid'
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Hi Igor, thanks for your reply.
Call me a bonehead... but I got nothing. What am I missing?
C:\set ORACLE_SID
Environment variable ORACLE_SID not defined
C:\sqlplus system
SQL*Plus: Release 8.1.7.0.0 - Production on Thu
check the sqlnet.ora file (in network/admin)
and see if there is a line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
in there. if so, change it to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
From: Cale, Rick T (Richard) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Igor
Lisa,
that's
only if someplace the ORACLE_SID was set somplace. It is not established
in environmental settings when you create a database, so it does not
exist.
I
always create a local {sid}.bat file in a directory
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Lisa,
C:\ set
ORACLE_SID=SID_NAME
Then...
C:\ set ORACLE_SID
ORACLE_SID=SID_NAME
Ed
Haskins
Oracle
DBA
Verizon Wireless
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
I ran into this as well. I figured I didn't need a listener on
my w2k box because everything was going to be local.
However I couldn't connect via sqlplus gui without a listener
(no listener error - maybe because I am specifying the sid).
I
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Ok, I
am getting a little closer to figuring out what is going on. I did mis-state
the type of install I did first. It was minimal installation without the starter
database. This did NOT create a listener service. However
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Rick,
I
think Networking services means TNSNAMES/SQLNET.ORA stuff (like a client
install).
You
could do a custom install (I think) and just install TNS Listener, and not the
starter database.
Tom Mercadante Oracle Certified
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
As everyone in this thread seemsso
knowledgeable
about NT, I would like to digress and ask a related
question.
When I use oradim to create a service,
oradim -new -sid MINE -pfile c:\mine\initMINE.ora
The service is created
Babette,
I'm not sure if I have read this anywhere but I think that the registry
entry (as created by oradim) might be used when the service is started.
However, when using startup the Oracle executable looks in
%oracle_home%\database for the file initMINE.ora.
What I do is create a file called
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
when I use svrmgrl to shutdown the instance and then try to
start it up, it complains because the init file does not exist
in %ORACLE_HOME%\pfile
use the -pfile c:\mine\initMINE.ora option when starting up
using svrmgrl.
BUT the oradim DID
14 matches
Mail list logo