Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connecting to sqlplus in 9i to create db problems

Re: connecting to sqlplus in 9i to create db problems

From: Ron Reidy <r_reidy_at_comcast.net>
Date: Wed, 17 Sep 2003 20:31:31 -0600
Message-ID: <3F691903.6010602@comcast.net>


Add to Daniels statements,

  1. init.ora 'local_listener' parameter?

Daniel Morgan wrote:

> Glen A Stromquist wrote:
> 

>> I am trying to do a startup nomount in sqlplus so I can create a
>> database sans dbca on 9.0.2.1.0 on SuSE 7.3, I think I've done all the
>> neccesary steps with the /etc/oratab file, looking at the startup log
>> it says that the <dbname> is warm started & the listener is running,
>> but there is 2 lines above this that show the ORA-12545 error
>> described below.
>>
>> I created a tnsnames entry and can tnsping it ok.
>>
>> I'm missing something simple here because I keep getting "ORA-12545:
>> Connect failed because target host or object does not exist" when
>> entering "startup nomount pfile=/path_to/initdbarch.ora" so I can
>> carry on creating the database.
>>
>> I've checked the env and ORACLE_SID is ok, what else am I missing?
>>
>> TIA
>>
>>
> ORACLE_HOME?
> ORACLE_BASE?
> Invalid entries in SQLNET.ORA
> testing the listener to see if it is up?   lsnrctl status
> 


-- 
Ron Reidy
Oracle DBA
Received on Wed Sep 17 2003 - 21:31:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US