- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: problem creating a database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 06:28 AM
тАО11-20-2002 06:28 AM
problem creating a database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 06:32 AM
тАО11-20-2002 06:32 AM
Re: problem creating a database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 06:34 AM
тАО11-20-2002 06:34 AM
Re: problem creating a database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 07:20 AM
тАО11-20-2002 07:20 AM
Re: problem creating a database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 07:27 AM
тАО11-20-2002 07:27 AM
Re: problem creating a database
Look at your other sample tnsnames.ora files.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 07:32 AM
тАО11-20-2002 07:32 AM
Re: problem creating a database
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 07:35 AM
тАО11-20-2002 07:35 AM
Re: problem creating a database
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.8.126.11)(PORT = 1521))
(ADDRESS = (PROTOCOL = ipc)(KEY = PNPKEY))
(CONNECT_DATA =
(SID = test)
)
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2002 09:23 AM
тАО11-20-2002 09:23 AM
Re: problem creating a database
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-21-2002 04:51 AM
тАО11-21-2002 04:51 AM
Re: problem creating a database
# 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-21-2002 06:08 AM
тАО11-21-2002 06:08 AM
Re: problem creating a database
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