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

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Thu, 18 Sep 2003 02:17:36 GMT
Message-ID: <4B8ab.11983$jg7.280090@news1.telusplanet.net>

Anna C. Dent 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?

> 
> 
> Having SQL*Net functioning is NOT required to create or start a DB;
> as long as you are logged onto the actual system hosting Oracle.
> The only requirements are that ORACLE_SID & ORACLE_HOME be correct.
>

Thats what I thought, as long as its a local database tnsnames should be a non-issue, but thought I'd check it off in any case. I know sqlnet is working fine in any case because I connected to my names server on the network and connected to a few other db's.

I telneted in and here is my env:

oracle_at_linuxora2:~> env
PWD=/home/oracle
ORACLE_SID=wbsarch
PAGER=less
REMOTEHOST=winms-ts1.millsite.net
HOSTNAME=linuxora2
LD_LIBRARY_PATH=/opt/oracle/product/9ir2/lib:/opt/oracle/product/9ir2/ctx/lib LESSCLOSE=lessclose.sh %s %s
LS_OPTIONS=-N --color=tty -T 0
SUSE_DOC_HOST=localhost
QTDIR=/usr/lib/qt2
CLASSPATH=/opt/oracle/product/9ir2/JRE:/opt/oracle/product/9ir2/jlib:/opt/oracle/product/9ir2/rdbms/ jlib:/opt/oracle/product/9ir2/network/jlib LESSKEY=/etc/lesskey.bin
LESSOPEN=lessopen.sh %s
MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/man:/usr/openwin/man NNTPSERVER=news
LESS=-M -S -I
USER=oracle
LS_COLORS=
MACHTYPE=i686-suse-linux
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
MAIL=/var/mail/oracle
INPUTRC=/etc/inputrc
LESS_ADVANCED_PREPROCESSOR=no
LANG=en_US
HOST=linuxora2
ORACLE_BASE=/opt/oracle
COLORTERM=1
ORACLE_HOME=/opt/oracle/product/9ir2
INFOPATH=/usr/local/info:/usr/share/info:/usr/info LOGNAME=oracle
SHLVL=1
TEXINPUTS=:/home/oracle/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX MINICOM=-c on
INFODIR=/usr/local/info:/usr/share/info:/usr/info ORA_NLS33=/opt/oracle/product/9ir2/ocommon/nls/admin/data SHELL=/bin/bash
PRINTER=lp
HOSTTYPE=i386
CPU=i686
OSTYPE=linux
WINDOWMANAGER=/usr/X11R6/bin/kde
TERM=ansi
HOME=/home/oracle
XNLSPATH=/usr/X11R6/lib/X11/nls
no_proxy=localhost
PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:/opt/kde2/ bin:/opt/oracle/product/9ir2/bin
FROM_HEADER=linuxora2.millsite.net
TNS_ADMIN=/opt/oracle/product/9ir2/network/admin LC_COLLATE=POSIX
_=/usr/bin/env
oracle_at_linuxora2:~> sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 17 19:40:08 2003

SQL> startup nomount pfile="/opt/oracle/product/9ir2/dbs/initwbsarch.ora" ORA-12545: Connect failed because target host or object does not exist

So, unless I missed something in the install, I'm stumped. There was some linking errors but I did the documented changes to genclntsh file and ran it like it said. I also ran the relink all command just in case there was something else missed.

I also got some bizarre errors near the end of the installs about improper permissions when copying files, but I just found the files in /Disk3 and copied them over manually, they were only emwebsite and emca.

As an afterthought from root I ran ./oracle start from /etc/init.d and the results are:

linuxora2:/etc/init.d # ./oracle start

#############################################################################
#                 Begin of   O R A C L E   startup section 
     #
#############################################################################

SETTINGS start from /etc/sysconfig/oracle - !!! MISSING !!!

Set Kernel Parameters for Oracle: yes
Start Oracle OCFS: no
Start Oracle OCM: no
Start Oracle GSD: no
Start Oracle Database: yes
Start Oracle Listener: yes
Start Oracle Webserver: no
Start Oracle CManager: no
Start Oracle Agent: yes
Start Oracle Internet Filesystem: no
Start Oracle Directory Manager: no

Setting kernel parameters for Oracle, see file /etc/rc.config.d/oracle.rc.config for explanations.

Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152 Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256 Other values: FILE_MAX_KERNEL=131072 IP_LOCAL_PORT_RANGE=1024 65000

ULIMIT values:      MAX_CORE_FILE_SIZE_SHELL=unlimited
                     FILE_MAX_SHELL=65536  PROCESSES_MAX_SHELL=16384

Kernel parameters set for Oracle: 
                  done


   - Starting Oracle Cluster Filesystem... 
                   unused
   - Starting Oracle Cluster Manager... 
                   unused
   - Starting Oracle GSD... 
                   unused

+ Starting Database(s)...
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 17 19:58:19 2003

SQL> ERROR:
ORA-12545: Connect failed because target host or object does not exist

SQL> ORA-12545: Connect failed because target host or object does not exist SQL>
Database "wbsarch" warm started.

     Status of Oracle database(s) start: 
                   done

   - Starting Listener... 
                   done
   - Starting Apache... 
                   unused
   - Starting Agent... 
                   failed
   - Starting Connection Manager... 
                   unused
   - Starting Oracle Internet Filesystem... 
                   unused
   - Starting Oracle Internet Directory... 
                   unused

#############################################################################
#                      End of   O R A C L E   section 
     #
#############################################################################

I'm not sure about the /etc/sysconfig MISSING error, as there is no sysconfig in /etc in this install or my 8i SuSE install (which works fine)

I did do the following however, which seems a bit odd as I thought that if a db was warm started then smon would be running.

linuxora2:/etc/init.d # ps -ef|grep smon root 8507 8281 0 19:59 pts/7 00:00:00 grep smon

I'm a little to used to W2k, to see if oracle is running I just look for the oracle.exe process, in 'nix I'm not sure, thought perhaps some 'nix gurus here could help me out!

cheers Received on Wed Sep 17 2003 - 21:17:36 CDT