Operating System - HP-UX
1748112 Members
3585 Online
108758 Solutions
New Discussion юеВ

Re: problem creating a database

 
HPADM
Advisor

problem creating a database

Hi!
I'm new to oracle and I would like to create a database. Oracle version is 8.1.5.
I have done:
init$SID.ora
su - oracle
sqlplus internal

I have got this error:

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

What's the problem?
thank you to help me
12 REPLIES 12
harry d brown jr
Honored Contributor

Re: problem creating a database

tnsnames

http://www.cryer.co.uk/brian/oracle/ORA12545.htm

live free or die
harry
Live Free or Die
Alan Casey
Trusted Contributor

Re: problem creating a database

http://docs.oracle.com/database_mp_8.html

check out the install document for HP-UX
HPADM
Advisor

Re: problem creating a database

In the sqlnet.log I tried this message:

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/sbrdbms/app/oracle/product/8.1.5/bin/oracle)(ARGV0=oracleCUSaprod)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(P
ROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bccust11)(USER=oracle))))

VERSION INFORMATION:
TNS for HPUX: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.1.5.0.0 - Production
Time: 20-NOV-02 16:17:53
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0

harry d brown jr
Honored Contributor

Re: problem creating a database

looks like a tns issue, smells like a tns issue, tastes like a tns issue, good thing we didn't step in it.

Look at your other sample tnsnames.ora files.

live free or die
harry
Live Free or Die
harry d brown jr
Honored Contributor

Re: problem creating a database

because you are describing TWO ADDRESS entries, don't you need ADDRESS_LIST = ( )

live free or die
harry
Live Free or Die
HPADM
Advisor

Re: problem creating a database

My tnsnames.ora is this:


TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.8.126.11)(PORT = 1521))
(ADDRESS = (PROTOCOL = ipc)(KEY = PNPKEY))
(CONNECT_DATA =
(SID = test)
)
)
Wodisch
Honored Contributor

Re: problem creating a database

Hi,

your TNSNAMES.ORA is ok, you simply didn't tell your LISTENER to listen on a TCP/IP port...
So, configure your LISTENER.ORA to listen on 127.0.0.1 (or your hostname/host's IP address) and port 1521, don't forget to include the "ORACLE_HOME=" in there, start the LISTENER, check with "tnsping" and then use "svrmgrl" instead of "sqlplus" (or you need an additional option, which I always seem to forget). Then do
connect internal
startup mount
create database ...;

The last setence with all the wanted parameters and option, of course :-)

FWIW,
Wodisch
HPADM
Advisor

Re: problem creating a database

now my listener.ora is :

# LISTENER.ORA Network Configuration File: /sbrdbms/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_test =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /sbrdbms/app/oracle/product/8.1.5)
(SID_NAME = test)
)
)

LISTENER_test =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.126.11)(PORT = 1521))
)
)


and my tnsnames is:

test =
(DESCRIPTION =
(ADDRESS_LIST =
ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.126.11)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = test)))

I did :
su - oracle
svrmgrl

I got :

Oracle Server Manager Release 3.1.5.0.0 - Production

Message 4505 not found; No message file for product=SVRMGR, facility=MGR

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

As oracle user my env is:

_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:/usr/dt
/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/perf/man/%L:/opt
/perf/man:/opt/resmon/share/man
SHLIB_PATH=/usr/lib:/sbrdbms/app/oracle/product/8.1.5/lib
PATH=/sbrdbms/oracle/bin:/sbin:/usr/sbin:.:/usr/bin/X11:/usr/contrib/bin:/usr/bin:/bin:/sbrdbms/app/oracle/product/8.1.5/bin:/sbrdbms/app/oracle/local
NLS_LANG=american_america.we8iso8859p1
COLUMNS=167
ORACLE_BASE=/sbrdbms/app/oracle
EXINIT=set ai tabstop=4
LOGNAME=oracle
ORACLE_SID=test
ERASE=^H
PRINTER=lp
TNS_ADMIN=/sbrdbms/app/oracle/product/8.1.5/network/admin
SHELL=/usr/bin/ksh
ORACLE_TERM=vt100
ORA_NLS32=/sbrdbms/app/oracle/product/8.1.5/ocommon/nls/admin/data
ORA_NLS33=/sbrdbms/app/oracle/product/8.1.5/ocommon/nls/admin/data
HOME=/sbrdbms/oracle
TERM=hp
LD_LIBRARY_PATH=/usr/lib:/sbrdbms/app/oracle/product/8.1.5/lib
ORACLE_HOME=/sbrdbms/app/oracle/product/8.1.5
PWD=/sbrdbms/oracle
TZ=MET-1METDST
LINES=55

T G Manikandan
Honored Contributor

Re: problem creating a database

ORACLE_BASE,ORACLE_HOME,ORACLE_SID,PATH (should include $ORACLE_HOME/bin),LD_LIBRARY_PATH
1.ORACLE_HOME is not set.
set ORACLE_HOME variable in the .profile file of the oracle user
2.Also check for any syntax errors in the .profile file.

Are you working on dt environment.Then make sure you set the .dtprofile.


Thanks