topic Re: problem creating a database in Operating System - HP-UX

problem creating a database

HPADM — Wed, 20 Nov 2002 14:28:58 GMT

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

Re: problem creating a database

harry d brown jr — Wed, 20 Nov 2002 14:32:11 GMT

tnsnames

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

live free or die
harry

Re: problem creating a database

Alan Casey — Wed, 20 Nov 2002 14:34:12 GMT

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

check out the install document for HP-UX

Re: problem creating a database

HPADM — Wed, 20 Nov 2002 15:20:33 GMT

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

Re: problem creating a database

harry d brown jr — Wed, 20 Nov 2002 15:27:33 GMT

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

Re: problem creating a database

harry d brown jr — Wed, 20 Nov 2002 15:32:59 GMT

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

live free or die
harry

Re: problem creating a database

HPADM — Wed, 20 Nov 2002 15:35:29 GMT

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)
)
)

Re: problem creating a database

Wodisch — Wed, 20 Nov 2002 17:23:06 GMT

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

Re: problem creating a database

HPADM — Thu, 21 Nov 2002 12:51:01 GMT

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

Re: problem creating a database

T G Manikandan — Thu, 21 Nov 2002 14:08:11 GMT

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

Re: problem creating a database

Thomas Schler_1 — Thu, 21 Nov 2002 15:34:14 GMT

hpadm:

Be sure to use full qualified db names. E.g. if your domain is mydomain.com, in listener.ora you should set GLOBAL_DBNAME = test.mydomain.com. In tnsnames.ora you should set:

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

In addition, it is better not to use the string "test". Often this is a reserved expression. Use e.g. "mytest" instead.

Re: problem creating a database

Wodisch — Thu, 21 Nov 2002 19:47:08 GMT

Hi again,

what does the output of "lsnrctl status" and "ping test" look like?
And what is the content fo your "sqlnet.ora"?

Regards,
Wodisch

Re: problem creating a database

Andreas D. Skjervold — Sat, 23 Nov 2002 23:48:43 GMT

Hi

Are you sure your database is succesfully created?. Check with 'ps -ef |grep pmon' should result in a ora__pmon process.

If not complete the database creation as advised in your second posting.

If the database is indeed running and you're logged in localy on the database server, there is no need for the listener to be configured as sqlplus connect directly to the database as directed by the ORACLE_SID enviroment setting.

If you're on the other hand is at a remote machine, this of course needs to be in place.

Andreas