I installed 9ir2 on suse 7.3 pro, installation went ok except for a glitch near the end when it asked me to open a root window and run the root.sh script. At the time I didnt know that the suid was (somehow) changed in the su command and I could not su to root, so I logged out and back in as root, ran the root.sh script and then ran "relink all" as oracle. All seemed ok.

The problem is, I can open sqlplus, but I cant connect as / locally to create a database. I went thru dbca and had it create scripts to create a db, then tried run them a step at a time. The problem is I keep getting "ORA-12545: Connect failed because target host or object does not exist" errors, and I'm not sure why.

I'm not that used to the 'nix world here so I'm not sure what to try next. Ive tried running "./oracle start" from /etc/init.d as root and get the following:

#############################################################################
# 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 Tue Sep 16 11:38:20 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

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 "wbs" warm started.
Status of Oracle database(s) start: done

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

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

As you can see, it says the db is warm started, but I still cant connect without getting the ORA-12545 error

I've deleted and recreated the password file as well.

any suggestions?

TIA