Access Database home page - Oracle Database Express Edition (XE)

Hi,
I can't launch XE home page. Error message "Serveur introuvable" by browser
But Session SQL is OK.
Windows XP SP2 home family used.
Who can help me ? 

Hi,
(1) Try using http://<host>:<port>/htmldb instead of http://127.0.0.1:8080...
(2) Check if service "OracleXETNSListener" is in "started" state. If not, try starting it. You may have to wait for a couple of minutes before the TNS Listener starts servicing the HTTP requests at port 8080. 

Hi,
Sorry, No success. All Oracle Sevices OK.
Ports 8080, 1521 and 2030 opened on firewall
Anythings else ? 

I had a similar problem using Windows XP home. After reboot the webpage was not accessible anymore.
I connected to the database and realised that the database was started but not opened. Hence I restarted the database (Using: "shutdown immediate" and "startup open" in the sql window). Afterwards it worked.
Hope this helps. 

Hey even I've problem with this Oracle 10g expres edition. When I try to open the home page, it says "The page cannot be displayed". If i use SQL Command Line and login from there, it works fine. But the home page is not working.
My Computer: WIndows XP SP2 Pentium 4 with 384MB(133MHz) SDRAM
I had earlier tried to install Oracle 9i in my system but couldn't because of the incompatibility of Oracle 9i with Windows XP. But i uninstalled it and deleted all the files associated with it. I'm sure no service of Oracle 9i is running at the moment. All the data related to Oracle 9i has been deleted and I've also cleaned the registry with "RegSupreme" before installing Oracle 10g express edition.
I use Zone Alarm Firewall and I've given full access to all Oracle related programs. I don't know where the problem is. But a lot of people seem to have this problem. Is there no solution for this from Oracle corporation? 

Troubleshooting yours ... look for a line beginning with the string ***** ... (The preamble is a set of general observations and comments, which you will likely ignore anyway but may help someone who does a search.)
Comment about the origial poster's use of XP Home ... people who want to use XP Home should realize that XP Home does not contain all the internals that XP Pro contains. My experience is that Oracle products which work well in XP Pro may not even work in XP Home because of differences or stuff missing. Oracle takers responsibility for their poducts on XP Pro, but not XP Home - probably because the Oracle products are designed for a commercial environment and XP Home is not designed for a commercial environment.
Perhaps someone who has XP expertise would be willing to take the challenge of identifying the detailed differences, especially as relaed to Oracle.
A general observation ... A lot of people who have had an installation problem with Oracle XE have found they did not insdtall with local administrator privileges. This requirement is in the documentation, as is the XP Professional SP2 requirement.
A number of people also run into the problem that many PCs with integrated video actualy have a lot less RAM available to the operating system, as some of the RAM is diverted to video. Therefore an installed 384M RAM may really only be 256M RAM (or less) if the video card is set to use 128M - not uncommon in XP Home envoironments from what I've been told.
When people are installing Oracle XE as their Oracle product; use the correct operating system and have the firewall / anti-virus turned off during install; and have the correct local administration privs (not domain administrator priv), they seem to succeed reasonably consistently.
This finding is supported by a number of unregistered local installs which my customers have done on their own and for which I've offered help. (Now if I could only get them to register ...)
***********
Now, since you used RegSupreme ... did you look for all occurances of TNS_ADMIN or tnsnames as well as ora? There is something diverting your listener's attention.
So let's trace this, shall we ...
at a command line, enter (and post the response to)
tnsping XE
and
lsnrctl status 

In investigating this problem for a student I found that:
Using Windows Pro XP SP2 with all updates todate
1) Install Oracle XE
This works OK
2) Remove Oracle XE
All services and directories removed
3) Install Oracle XE (no reboot)
Services running ok
http://127.0.0.1:8080/htmldb gave Page not found
Also "lsnrctl status" did not report the entry
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=8080))(Presentation=HTTP)(Session=RAW))
nor did "netstat -a" report
TCP <hostname>:8080 arthurdent.ics.mq.edu.au:0 LISTENING
So fixed problem by:
1) Remove Oracle XE
All services and directories removed
2) Reboot
3) Install Oracle XE
Services running ok
http://127.0.0.1:8080/htmldb gave login page.
My suggestion would be that there is some process still hanging around preventing the HTTP service from installing or running.
Ian Cowell
--------------- 

I can confirm that you can run Oracle 10gXE on Windows XP Home SP2 because I am currently doing this (AMD3200/1GB Ram/80GB disk). Initially had problems with beta install because it did not start the listener process to allow rest of install to complete. Had no problems with production release of 10gXE. There are enough services in XP Home to run the database ok 

Hello Mr.forbrich,
All what is there in your mind is Oracle XE works well and those who are having problems with the home page are having problems with their computers. Thats what you think.
Firstly, let me tell you that I've installed Oracle XE with admin privileges as I'm myself the administrator. My OS is Windows XP Professional and my video card uses only 64Mb of the RAM.
The following is the response for the command tnsping XE
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-JUN-2
006 14:18:34
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
G:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = home-qim
8ufczt5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE))
)
TNS-12541: TNS:no listener
The following is the output for the command lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Beta on 02-JUN-2006 14:20:20
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Beta
Start Date 02-JUN-2006 13:00:56
Uptime 0 days 1 hr. 19 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File G:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File G:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=home-qim8ufczt5)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully 

What I think is irrelevant. What is relevant to me is that a majority of people who I have discussed this with in person who follow the instructions seems to have minimum - or no - problem. And a majority of people with difficulties have not followed the instructions. Again, based on the people whith whom I've personally discussed this.
So flush the vinegar and let's troubleshoot your environment, shall we? I will simply write out my 'stream of consciousness' troubleshooting thoughts ... take it or leave it
1) You in fact have 320M available to Windows, of the 384M RAM installed. Should be sufficient. You also have local administrator privs, not just domain privs or regular user.
2) Please confirm that the database seems to be up at all. Services should show the XE and the XE Listener are both running. And logging in to Oracle using sqlplus at command line shows the service is up and you are not connected to an 'idle' instance.
3) You have provided output to tnsping and lsnrctl:
A) tnsping XE tells me
i) you have a reasonable TNSNAMES.ORA config;
ii) you are using some form of DNS or host name translation;
iii) there is no listener up an running on the host that translates to home-qim8ufczt5
This could imply that you are using DHCP and the IP address has changed since you installed XE. That, in turn, has other implications. (Perhaps \WINDOWS\system32\drivers\etc\hosts. file that does hostname-to-IP mapping has an impact here?)
This could also imply that there is no host name resolution pointing to your host.
So what happens when you 'ping home-qim8ufczt5'? If you do get a response, we know that it is finding 'a' host and that
B) lsnrctl status tells me that the listener does not know of your database. This can happen if
i) the database is not up;
ii) the database is not willing to register to the listener;
iii) the listener is not listening on the same host and port as the database is sending;
First is obvious. Second implies someone has been changing database parameters. Third may be a result of the same host-to-IP issues identified above.
4) If you can, in fact, ping the host, then the problem may be at the port level. That usually points to an anti-virus or a firewall issue. Confirm that ALL firewalls and anti-virus have been turned off. (I've gone thru this troubleshooting with customers - they've cursed me, only to find in the end that they forgot one of the firewalls.)
5) At this point we have verified that the database is up, we can get to it using sqlplus, the listener is up, there is no TCP/IP DNS-or-other-host-to-IP resolution problem, all ports are open, and yet the database is not registering to the listener.
A) We could try to force registration and see whether a message or error occurs - in sqlplus as sysdba, user the 'alter system register' command;
B) We could look in the alert_xe.log and listener.log and se whether there are messages that help understand why - perhaps after the initial glance, we could rename the files and try a reboor to see what data is entered into them from a clean start;
C) We could turn on various levels of listener logging and try to trace from there;
D) We could set the listener to always listen for the database - which means the listener will always listen for the database, whether it is up or not (and never teel the users when the database is down.) 

Hans and anonymous-user-with-problem-reluctant-to-take-advice-from-friendly-people:
One thing I noticed in the above lsnrctl status output is that it says Beta. Looks like the database is Production software.
Sergio

Related

I Have Problem with Oracle Database 11g Express Edition

Hi,
I have a problem with Oracle Database 11g Express Edition. After installing it and whenever I click the "getting started" icon, I get the following error:
Can't connect to 127.0.0.1:8080
Note that the URL is: http://127.0.0.1:8080/apex/f?p=4950
I have windows 7 Home Premium Service Pack 1
The system type is 64-bit OS
-------------------------------------
The output of the command : lsnrctl stat
is below
----------------------------------
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\AAA> lsnrctl stat
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 20-FEB-2013 01:54
:12
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 19-FEB-2013 14:42:32
Uptime 0 days 11 hr. 11 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\Abdulmajeed-PC2\li
stener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Abdulmajeed-PC2)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-------------------------
Need help
Thanks
Edited by: 989122 on Feb 19, 2013 11:07 PM 
Hi, and welcome to the OTN forums!
First, please note that XE is not supported on any Windows 64bit release yet. So it is likely, that some parts of your installation didn't work as expected.
The issue you encounter is very common and you'll find tons of posts with lots of useful hints.
I recommend you to check your installation logs, the state of your firewall, and possibly the health of your database (though it seems the database is up).
For the latter, please execute
sqlplus / as sysdba-Udo 
I'm a student. So I have very basic info about DBs. It worked with some of my friends in class even though they have the same OS. I have checked many posts and that is how I come up with the command listen. But it is not working yet :(
Here is the output of the command sqlplus / as sysdba
-----------------------------------------------------
C:\Users\AAA>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 20 02:59:32 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
-------------------------------------------------- 
The ora-12560 indicates two possible problems.
1) The Windows service for the database is not running.
Run the services applet (Start/Run/services.msc) and make sure the OracleServiceXE service shows Running. There are four or five oracle entries, only the ...ServiceXE and ...XETNSListener ones are relevant in an XE install. For the Windows OS, services not running are a frequent cause of that particular error. Fairly certain services.msc works for win7 as it does for WinXP.
Another symptom of the service not running ... you won't be able to connect to the database without using a sysdba connection, because the database instance is down.
2) The registry settings for the client are not correct.
If the registry settings are incorrect or absent, that is not an easy fix. Try the sqlplus in a command box started with the "run as Administrator" privilege and that might fix the registry problem, if there is one.
Also verify your windows user is a member of the ORA_DBA group. Other errors, like a '... access denied' can occur with the connect / attempt, but you'll have to get past the -12560 error first. In the command box:
net localgroups ora_dba
...
user1
user2 ...
NT Authority\SYSTEM 
I checked the services and I found only one service that start with Oracle. It is OracleXETNSListener, and it is started!
Does that mean that I have a problem with the installation? 
a problem with the installation?Yes. It will require an uninstall, per the steps in the XE documentation, see http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#CIHDDHJD
With win x64, as mentioned by others there is no XE installer for the 64 bit OS.
It might succeed by setting up an Administrator command box and running the installer from there. Note the Requirements section in the Windows install guide shows "System architecture Intel (x86)". So it might work, but the installer was not meant for x64.
And note the requirement for membership in the Administrators group in Windows, I think a Start/Run/lusrmgr.msc works for Win7 same as for XP to get to the local users and groups applet- check the admin group in the applet. Or try the net command, I'm not positive win7 works same-same or almost same as XP ...
net localgroup administrators
Administrators
<domain>\<user1>
<user2>
... 
Windows XP. I can't use UTL_FILE package. Statment "DECLARE descrip UTL_FILE.TYPE;" -> compile ->error:
PLS-00201 UTL_FILE must be declared. 
PLS-00201 UTL_FILE must be declared.The utl_file is an older package, 11g uses directories to accomplish what used to require the utl_file utilities.
Please start a new question and post as much detail on what you're trying to accomplish. Could be what ever package/stored procedure you're running expects execute rights for the utility, might be fixed with a sysdba connection and `grant execute on utl_file to <user>;`.
But then again, depends on what you want to do. The full 11g docs can also be helpful, see http://docs.oracle.com/cd/E11882_01/win.112/e10845/apps.htm#sthref741 
11g docs are not helpul. not at all. completely disagree.
1.- sqlplus connect user/pwd
2.- grant execute on utl_file to user;
access appears to be granted but still unable to use utl_file! 
Welcome to the forums!
Please start a new thread for your specific issue. As you should see, this thread is about a problem accessing XE homme page via "getting started" icon.
When you do, please describe your specific issue carefully. E.g "unable to use" is likely not a real error message. Also include full version number ("11g" is just a marketing label and useless here).
Docs may take some time to learn how to navigate, and so on, but they are necessary and very useful for perhaps 99% of common Oracle related activities.
Edited by: orafad on Apr 11, 2013 11:52 AM

Homepage is not available after renaming of XE

Hallo,
I have renamed SID and DB_NAME of Oracle XE to "TEST" (according to Note 61590.1 Renaming an existing Windows NT database) and can't start homepage anymore.
During renaming i have changed "XE" in folders
C:\oraclexe\\app\oracle\admin\XE
C:\oraclexe\wbpx11\app\oracle\flash_recovery_area\XE
C:\oraclexe\wbpx11\oradata\XE
to "TEST".
I can start a database and I can access http://127.0.0.1:8081/ (XE license agreement, http port is 8081), but XE homepage http://127.0.0.1:8081/apex/apex is not available.
Schould be any files customized in order to adjust Application Express?
OS: Windows XP Pro SP2
Thanks
P.S.: Renaming of database is important (as far as I know) if you want to setup a downstream capture of changes from 2 or more XE databases at the same EE Database. 
Hi
If your query isn't solved yet then Log in to the Oracle Database XE host computer as the user who installed Oracle Database TEST(earlier XE), and then open a command window.
Enter the following command:
LSNRCTL STATUS
The result should have the following components:
(PORT=1521) shows that the listener is listening for database connections through Oracle Net on port 1521.
(PORT=8080))(Presentation=HTTP) shows that the listener is listening for database connections through HTTP on port 8080.
Service "XE" has 1 instance(s) and Instance "XE", status READY Oracle Database TEST(earlier XE) is properly registered with the listener and is ready to accept connections.
If the above mentioned ports and service status doesnt show up then it means that listener isn't listening for the XE service after you renamed it to test.
-Priya 
Just curious whether you can still access the database using SQLPlus from a regular (not sysdba) user, both ways - with and without the '#TEST' alias. 
The url you should be accessing is http://127.0.0.1:8081/apex.
On the other hand, verify the contents of the alert.log to look for any issue from around the time you attempt the connection
. . . 
Apart from above mentioned advise , also make changes in listener.ora and rnsnames.ora.
Use oradim to unregister service XE and register service TEST.
Virag

Cannot access http://127.0.0.1:8080/apex on Windows 7 64 bit

Hi Guys, Yes..yet another question on this issue!!..looked up endless forums..but none seems to have solved my problem..
Oracle XE (10g, of course) installation is not giving error, in fact it says "installation completed successfully". Then when I click on "Go To Database Home Page", Firefox says "The connection was reset".
I've been trying this since yesterday, but no luck.
Bit about my env:
OS : Windows 7 64 bit
Oracle: Oracle XE Release 10.2.0.1.0
I haven't touched anything in listener.ora, sqlnet.ora or tnsnames.ora
OracleServiceXE, OracleXETNSListener are running as normal.
telnet localhost 8080 is successful ( empty screen appears until I press a key )
tnsping XE seems to be fine
hostname in tnsnames.ora is something like 'myhostname.my.domain.com'. I've tried with my IP address as well, but no luck.
but this is what I'm getting when I tried to connect using sql plus,
sqlplus sysadmin
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
When tied this command,
sqlplus sysadmin/<pwd>#localhost:1521/XE
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
sqlplus / as sysdba
ERROR:
ORA-01041: internal error. hostdef extension doesn't exist
Windows firewall is turned off when I installed Oracle XE
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-JAN-2010 09:53:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 22-JAN-2010 09:31:26
Uptime 0 days 0 hr. 21 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhostname.my.domain.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
It used to work before, I needed to change my host name. So I've uninstalled Oracle XE after I changed the hostname and since then I can no longer access the homepage
I must be missing something obvious..Could you please let me know how I can fix this problem..
Edited by: user1729626 on Jan 21, 2010 4:03 PM 
Hi,
I am just curious, you have 64 bit OS, and Oracle XE is built as 32-bit. I guess it should not be working.
But since I do not have such Windows 7, I could not really test.
Could you please send complete listener.ora file ?
I guess now Oracle does not understand your HOST.
Could you try to change to localhost.localdomain instead of myhost.mydomain.com and restart listener
Also, you have shared realm problem that relates to your ORACLE_SID environment variable.
May be this article can help: http://www.dba-oracle.com/sf_ora_27101_shared_memory_realm_does_not_exist.htm
But I think this relates to the listener.ora
since you have not changed anything else except host
Regards,
Oleg
Edited by: oleg.lihvoinen on Jan 22, 2010 7:23 AM 
Windows stores all the environment settings for connecting to the instance in the registry- so when sqlplus / as sysdba doesn't connect to the instance (and it is indeed running) try stopping and starting the oracleXE service, have seen a restart fix sqlplus connect errors for Windows. Or try logging out and back into the host, that may fix the environment settings.
A tnsping XE will only tell you that
a) the client configuration (tnsnames.ora entry) knows of the XE service
b) A listener is running on the host at the port specified for the XE service
A tnsping does not verify the service_name nor actually connect to the database at all.
For connecting to the local database instance, just need to supply the username (and password, optionally) for sqlplus, the #host:port\service_name is only needed for remote connections- 
Hey Guys,
I managed to fix this issue myself..I can access the home page as normal.
This is what fixed the issue.
Step 1 : Un-installed Oracle XE while logged in to the domain. ( Made sure it cleaned all installation files and registry and env variables by cross checking registry as mentioned here .
Step 2 : Logged in as admin on the local machine ( not domain ) and reinstalled it. Now it works just fine. (Closed all programs - didn’t open any programs..just ran Oracle installation )
I did install oracle xe logged in as a domain user before ( and my domain is user is part of local administrators) and it all worked just fine. May be it’s a permissions issue ( though I ran oracle installation as admin ) or host name change issue.
Phew..anyhow..finally it works!!
Cheers. 
Hi,
Ok, good to know your troubles. Thanks.
I was also thinking that you had some unclean uninstall, because you had a problem with ORACLE_SID.
Regards,
Oleg

Oracle XE edition - Internet Explorer error when go to Database home page

I just installed Oracle XE 10g on my Windows XP (SP3) pc. Everything seemed to go well in the install. When I try to go to the Database Home Page with Internet Explorer I get an error "cannot display the webpage".
The Oracle services appear to be running on my system.
I can run "tnsping XE" and it returns:
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2
010 17:39:12
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)
I ran "lsnrctl status" and it returns:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2010 17:40:29
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 17-AUG-2010 17:21:55
Uptime 0 days 0 hr. 18 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Any help is appreciated. 
Hi,
Did you check if the installer created the default database ? i mean datafiles ? ,i think your problem is the same as mine. 
I found a web site that indicated the database files should be in C:\oraclexe\oradata\XE and the parameter files should be in C:\oraclexe\app\oracle\product\10.2.0\server\dbs ; however both of these dirs are empty on my pc. I've uninstalled and reinstalled twice now. I have not found anything in the documentation to help with this problem. 
I found a web site that indicated the database files should be in C:\oraclexe\oradata\XE and the parameter files should be in C:\oraclexe\app\oracle\product\10.2.0\server\dbs ; however both of these dirs are empty on my pc. I've uninstalled and reinstalled twice now. I have not found anything in the documentation to help with this problem.
Does anyone know how to create the databases manually?
Edited by: mcham7 on Aug 18, 2010 7:04 AM 
what does zour xe.bat says ? if you are facing the same error as iam facing ßsee mz thredß than some people says to log as a local administrator not on the domain ,others says to change language ,for me all these did not work.
Search for the error that you will find in xe.bat and css.log in this forum,let me know if you find a solution , i do not like to set updatabase manuallz because i might face problems later in apex functionality. 
Same problem here, on a Windows Vista PC. I've uninstalled and reinstalled, and installed APEX 4.0. No luck.
Odd thing is, when I first installed Oracle XE (about 10 days ago), I was able to get to the database home page. Can't now. 
I looked around in some of the scripts used to setup the initial XE environment and found the following error in the
C:\oraclexe\app\oracle\product\10.2.0\server\config\log\postDBCreation.log:
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
ERROR:
ORA-12638: Credential retrieval failed
This hosed up the remainder of the C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\postDBCreation.sql script.
I need to do further checking on this ORA-12638 error.
Thanks for the tip. 
I am having exactly the same problem. I installed and deleted XE Edition 4 times today, and then installed it again 5th time (including restarting my Windows XP PC twice). Nothing worked. Whenever I start or stop the database, the messages in DOS window clearly indicate that the database was "successfully" stopped or started. And, yes, I installed XE with 'Administrator' privilege on my PC.
I am actually shocked to see no help from the Oracle support people here at all. I also noticed that Oracle installation web page and PDF documentation "merely" mention the installation steps with a flawed assumption that the installation will succeed for everybody. There is simply no mention of troubleshooting tips anywhere. I could not find any help anywhere else online either.
Is someone there to help us users who just cannot get the installation work, or there is some bug in XE Edition? 
I am having this same problem being unable to logon to homepage,
and it is because the install is broken.
If you look in here:
C:\oraclexe\app\oracle\product\10.2.0\server\config\log\postDBCreation.log
Find this snippet:
-----------
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
ERROR:
ORA-12638: Credential retrieval failed
.
.
.
SQL> create spfile='C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora' FROM pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';
-----------
Notice the "/" in the path where it should be "\", because it is wrong in this script:
C:\oraclexe\app\oracle\product\10.2.0\server\config\scriptspostDBCreation.sql
And then you have this bad line:
SPFILE='C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora'
in
C:\oraclexe\app\oracle\product\10.2.0\server\database\initXE.ora
Would be great if you could manually fix these file separator issues in the middle
of the install by editing the files.
There is a thread from 2005 that deals with this:
http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/12/14/0979.htm
Why is a 2005 issue resurfacing now? 
I used to have the same problem when I installed oracle 10g express on my windows XP.
So I used to try reinstalling---> repair----> then start the database home page.
Today I tried
1.) All programs-->oracle10g express--->stop database.
2.) All programs---> oracle 10g express--->start/restart database-----> go to database home page .
It connected... I don't know if its is a permanent solution or temporary but I am glad it is working for now. 
Did anyone find a solution to the "Credential retrieval failed" symptom? 
I have the same problem too. Did any one manage to solve the issue? 
I have exactly the same problem 
I corrected the "/" problem in the spfile cmd line. That executes fine now, but I got an error about the control file missing.
connect "SYS"/sys as SYSDBA
create spfile='C:\oraclexe\app\oracle\product\10.2.0\server\dbs\spfileXE.ora' FROM pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';
shutdown immediate;
connect "SYS"/sys as SYSDBA
startup ;
ORA-00205: error in identifying control file, check alert log for more info
When I look in C:\oraclexe\app\oracle\admin\XE\bdump\alert_xe.log , I can see control_file =
C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
This CONTROL.DBF does not exist on my system. 
I had the same problem.
1. No Database files where installed <path to Orcale files>\oradata\XE.
2. I could not connect to http://127.0.01:8080/apex
3.i got the error ora-12638: credential retrieval failed when i tried to login through sql plus
Windows XP SP3
SOLUTION:
1. I uninstalled completely and then restarted my computer.
2. I logging into my local machine with my local admin account instead of domain
3. ran installation again and it worked. Database files were created in the \oradata\XE folder.
The installer seems to complete successfully even if there are errors. I believe the error i ran into has to do with the fact i was logged into my companies domain.
Good luck

TNSLSNR.EXE Application Error

I keep getting an error that I can't figure out how to resolve. The problem is that TNSLSNR keeps blowing up with an application error. Anything I try to do that attempts to connect to my database causes the following application error:
TNSLSNR.exe Application Error
The instruction at "0x61915732" referenced memory at "0x00000578". The memory could not be "read"
and the listener service terminates. I have to stop the database service and restart it otherwise additional restarts of the listener cause the database to go crazy.
I have Oracle 9i on my Dell Latitude C840 running Windows XP Pro. I could have sworn this was working before, but now I'm not sure. I recently installed the latest Oracle JDeveloper to tinker with and I also recently went through and "trimmed" down my system by disabling all unnecessary services.
For troubleshooting, I have tried to manually start the listener and got the following:
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is c:\oracle\ora92\network\admin\listener.ora
Log messages written to c:\oracle\ora92\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 30-APR-2003 20:08:14
Uptime 0 days 0 hr. 0 min. 7 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\oracle\ora92\network\admin\listener.ora
Listener Log File c:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "BIBLES.world" has 1 instance(s).
Instance "BIBLES", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
This works fine, then when I try to do a TNSPING, I get the application error. I also get the error when I try to connect using AllAround Automations PL/SQL Developer 5.1 and also when I try to connect using SQLPLUS.
I have captured a trace file but I don't speak TRC. Can anyone offer any help or suggestions or tips or anything? 
I am having the same problem on Windows 2000 Server (SP3), and I really hope someone is able to help solve it.
I loaded 9i (9.0.2, I believe) onto my laptop several months ago, and I'm pretty sure all was working fine at that point. I remember creating a listener and a test database instance at that point, and that I had connected successfully. I believe I was probably running SP2 of Windows 2000 at that point.
A week or so ago I had to demo something on my laptop while disconnected from the network, and the listener would crash every time I simply tried to connect. I deleted the listener and recreated it, and it crashed at the very end of that process. Interestingly, it created the listener service, and I was able to restart the listener service just fine. But at the instant I tried to connect to a database, BAM....
Sooo... I uninstalled 9.0.2 and installed the latest 9.0.3. Still had the same problem. Then I installed it on another Windows 2000 Server machine (SP3 as well), and it has the same problem.
However... I have been working with a client who uilt a brand new Windows 2000 server a few weeks ago. He told me it was running SP3. He installed 9i database and 9iAS, and we have used it successfully for several weeks. Out of curiousity, I just terminalled into the server just to verify the Windows SP it was running, and the magical My Computer icon doesn't show ANY SP! I'm not sure how to verify this, but I am assuming that it's accurate.
All that said, I am now suspecting that it might be an issue caused by SP3. I'm not sure what SP of Windows XP you're running, but perhaps there's some component in common with Win2K SP3 that might be the cause.
As you did, I had turned off a few services on my machines as well. I'm not sure what other services might be used by Oracle, so it would be helpful if an Oracle techie can shed some light on that. I also upgraded to the latest JDeveloper maintenance release, but was already having the problem before that.
Ergo, I second your call for help. 
I FIGURED IT OUT!!!! YIPPEEE!!!!
Man, this took so long and it's really something I'm just doing with my "spare time", I've been dealing with this for weeks now!
In my case, the problem was a product that I installed to enable my computer to use my cell phone to connect to the internet. The product came with some Verizon software that lets you manage your phone numbers. I installed it and it added two additional network adapters to my Network Connections. I had already removed these because I didn't feel it was worth $0.40 / minute to use the internet. However, there was a service provider called Venturi Personal Client which serves as some sort of network accelleration. This was the true cause of my problem.
Once I actually uninstalled the Venturi Personal Client, my problem went away!!!! Now I can go back to tinkering with Oracle and JDeveloper.
How did I figure this out? I already had a call stack from the Application Error and the last thing on the stack was VLSP.DLL. I did some searches in Google and only found a couple of entries. I looked at the DLL in my Windows Explorer and it was created by a company called Fourelle Systems, which is now Venturi Wireless. When I went to their website and read about their products, it slapped me right between the eyes that the Verizon software aske me something about using an accellerated connection option. I checked and I had already removed the Network Connections that it created, so then I went to my Add/Remove Programs control panel and saw that the Venturi Personal Client was still installed. I was fairly positive that this was only there because of the Verizon software so I removed it, rebooted, and BAM, everything is back to normal!!!
I hope this helps someone! 
I also meet this error in winXP.
My DB service and TNSLSNR can auto-start.
However , After tnsping ok one times, this error is show to me. and TNSLSNR shutdown automatically.
Have someone help me ?
thanks 
Thanks a lot .. gave me a hint to solve my similar issue as well. In my case, it was the Cingular Communications Manager V5 which was causing the problem. It installs a service called Bytemobile Web Configurator, which was the cause. Uninstalling (and rebooting) solved the issue.

Categories

Resources