Starting 9ir2 in SuSE linux problems

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

Hey,

are you in Alberta??? Calgary ????

yeah - north of Edmonton

do you know how to fix this?

I did install Redhat Linux Advance server 2.1, I never done on suse. Seem like you are on the right track and my only advise is that reinstall Oracle and when you get to the root.sh, don't log out open another windows and su - and run the scripts

I do SuSE 7 and 8.

If you got to the root.sh, all the chosen Oracle software was installed and compiled.

You're good to go.

The errors you're having are TNS errors (sql*net). Did you create/configure a tnsnames.ora or listener.ora file?

What are the results of the following command:

ps -ef|grep _smon

Should look something like this if your database is running:

oracle 1890 1 0 15:00 ? 00:00:00 ora_smon_LINTEST

Quote:

---

Originally posted by KenEwald
I do SuSE 7 and 8.

If you got to the root.sh, all the chosen Oracle software was installed and compiled.

You're good to go.

**thats what I though (and was hoping!)

The errors you're having are TNS errors (sql*net). Did you create/configure a tnsnames.ora or listener.ora file?

**yes, but didnt think an entry in tnsnames was neccesary yet, in any case, I created one with netmgr and also made sure the listern was running, even added an database for the listener to listen for, but this should be unnecessary as well...

What are the results of the following command:

ps -ef|grep _smon

Should look something like this if your database is running:

oracle 1890 1 0 15:00 ? 00:00:00 ora_smon_LINTEST

---

this is where my problem is, all I get back is the ps -ef|grep _smon!

so how do I get oracle itself running?

thanks!

OK, let's get your database started.

If the database creation scripts completed successfully, login as the oracle user, set your $ORACLE_HOME and $ORACLE_SID environment variables, and add $ORACLE_HOME/bin to your $PATH.

I posted a script for this earlier today, you may want to check that out. It will end up looking something like this:

Select an Environment to Set :

1) LINT11i 8.l.7
2) LINTEST 9.2.0.3
3)
4) SLGX 8.1.7.2 Shareplex

Q) Quit

Enter choice :
2
ORACLE_SID is set to LINTEST
oracle@lintest:~> sqlplus

SQL*Plus: Release 9.2.0.3.0 - Production on Tue Sep 16 16:56:22 2003

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

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 219746960 bytes
Fixed Size 451216 bytes
Variable Size 201326592 bytes
Database Buffers 16777216 bytes
Redo Buffers 1191936 bytes
Database mounted.
Database opened.
SQL>


Once you get here, your database is running.

Next thing is to configure the listener.ora file and tnsnames.ora files.

Perhaps I didn't make myself clear enough. The problem is, I am still getting a "ORA-12545:connect failed because target host or object does not exist" and I'm not sure why as the ORACLE_HOME,ORACLE_BASE and ORACLE_SID entries are all showing up ok when I do an env command. I've created an entry for tnsnames for the db, but that should be unneccesary as it is a local database.

If I run ./oracle start from /etc/init.d it goes thru the oracle startup and tells me that the database is warm started, but if I do a ps-ef|grep smon it shows nothing, which tells me that oracle itself has not started.

:confused: