Re: Problem with creating DB on Linux

From: Gene Hubert <ghubert_at_skillspoint.com>
Date: 2000/06/02
Message-ID: <3937bf7d.262058660@news.interpath.net>#1/1

Double check your oracle.sh script and see if anything is missing. Here is one from 8.0.5 on Linux.

ORACLE_BASE=/extra/oracle
ORACLE_HOME=$ORACLE_BASE/app/8.0.5
ORACLE_SID=bo
ORACLE_OWNER=oracle
ORACLE_TERM=vt100

ORA_PWFILE=$ORACLE_HOME/dbs/orapwbo
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_OWNER ORACLE_TERM ORA_PWFILE
export NLS_LANG
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/odbc/lib:$ORACLE_HOME/lib export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib

Gene Hubert
http://www.skillspoint.com - Where Smart People Buy Training!

On Tue, 30 May 2000 00:23:04 +0200, lam <mailbox_at_online.de> wrote:

>Finally, Oracle8i apparently has been installed on my Linux box. I can
>fire up server manager. However, the problem is
>after having created a password file and trying to connect to Server
>Manager to create the database, I encountered the following problem:
>
>**************************************************************
>[oracle8i_at_feb2000 create]$ echo $ORACLE_SID
>tst3
>[oracle8i_at_feb2000 create]$ svrmgrl
>
>Oracle Server Manager Release 3.1.5.0.0 - Production
>
>(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
>ORA-12545: Connect failed because target host or object does not exist
>SVRMGR> connect internal
>Password:
>ORA-12545: Connect failed because target host or object does not exist
>SVRMGR> exit
>Server Manager complete.
>[oracle8i_at_feb2000 create]$
>*****************************************************************************
>
>As shown, ORACLE_SID is set up and a corresponding password exists in
>the default directory. CONNECT INTERNAL is supposed to let me connect
>without password anyway. But in practice, this is not the case. Do I
>have to change
>
>remote_login_passwordfile = exclusive
>
>in the INITSID.ORA file to another value? That was the pre-set value
>from the sample file.
>
>Any hints will be appreciated!
>
>--
>To reply to me via email, please substitute the text no_spam with
>mailbox in the return address.
>
>
Received on Fri Jun 02 2000 - 00:00:00 CDT