cancel
Showing results for 
Search instead for 
Did you mean: 

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
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
Thomas Schler_1
Trusted Contributor

Re: problem creating a database

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.
no users -- no problems
Wodisch
Honored Contributor

Re: problem creating a database

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
Andreas D. Skjervold
Honored Contributor

Re: problem creating a database

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!