-
Prblems acessing 10G Database running under XP
After recently installing 10G on my XP box to do an eval I am experiencing some difficulties.
My installation seemed to go well except for some warnings about choosing
the default IP address.
I was able to create several database. Now I just need to access them to create tables, Sps, etc.. I can't seem to do this.
I was told on an Oracle forum to just use this browser address
http://localhost:5500/etc. But when I do this I get A Java error message.
It was also suggested that I try to see if the console is running hwich I tried using this command, emctl start dbconsole. Ir responded with ORACLE_SID variable not defined ? I thought that I did this when I created the database.
Also I tried accessing trhe database via SQL plus. I assume that you enter the user name and password created for the desired database and the "host name" would be my pc name or "localhost" . I get an error message that states ORA-12541 TNS: no listener.
But when I look at my services 10G_homeTNSListener has started.
All in all setting up Oracle is pretty frustrating. And it shouldn't be.
Setting up other db products have been pretty straight foward i.e. SQL Server or My SQL.
Thanks you in advance for any input,
GMann
-
oracle is a little more advanced than sql*Server or mysql therefore it needs a bit more knowledge, if those are easy to use for you - go ahead and use them
so.
from a command prompt so this
lsnrctl status if it returns something about no listener do lsnrctl start
set ORACLE_SID=
then sqlplus "/ as sysdba"
what do you get here? connected to an idle instance or a full SQL prompt?
iF it says connected to an idle instance type startup to start the database then try your web page again, btw it is http://localhost:5500/em not /etc
-
Reply
Thanks for your response.
I tried issuing the command but got this message:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
H:\OraHome_1\BIN>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 08-JUL-2005 11:28
:45
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service , error 1060.
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
Log messages written to H:\OraHome_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gordonxp)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 08-JUL-2005 11:28:53
Uptime 0 days 0 hr. 0 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File H:\OraHome_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gordonxp)(PORT=1521)))
The listener supports no services
The command completed successfully
H:\OraHome_1\BIN>
Did that last line mean that it worked, the command that is ?
I thought about buying the Adminstrators Handbook but they only have the 9i version. Could I generalize from that book to some of the basic set up stuff that I am doing ? I really don't want to order a book when I am only evaluating the product at this time.
Thanks,
GMAnn
-
ok, the listeber is running - how about the database using the sqlplus command line tool
-
Thanks for your earlier suggestion.
I was able to log into SQL Plus via a DOS prompt.
Still can't log in via the windows GUI.
Also when trying to start the dbconsole I get the following:
H:\OraHome_1\BIN>SET ORACLE_SID = ATestDB
H:\OraHome_1\BIN>emctl
Environment variable ORACLE_SID not defined. Please define it.
It is my understanding the all nedd to enter is:
1. SET ORACLE_SID = myDatabaseName
2. Issue the infamous command emtcl start dbconsole.
Thanks Again,
GMann
-
no, remove the spaces from the set command and use sqlplus to see if it is started
forget enterprise manager for moment, check your database
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|