Home » RDBMS Server » Server Administration » installtion problem pl/sql v11g xe (pl/sql v11g xe)
installtion problem pl/sql v11g xe [message #672284] Wed, 10 October 2018 05:21 Go to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
hello,

i downloaded the v11g xe for testing purposes, however it will not log in to the new database upon loading the "start database", it brings up the small black screen and simply says C:\Windows\system32>


i am running windows 10 and downloaded the 64 bit version,


so please tell me how to launch the database on the initial msdos command screen.

thanks
Re: installtion problem pl/sql v11g xe [message #672286 is a reply to message #672284] Wed, 10 October 2018 07:01 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
I've approved your post, and moved it to a more suitable forum.

Re: installtion problem pl/sql v11g xe [message #672294 is a reply to message #672286] Wed, 10 October 2018 09:00 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member

i am runnng win10, with laptop that supports all the min requirements i reckon, 300+ gb hd free, 4gb ram and intel n3540 duo cpu's, compaq 15 notebook. this is an older laptop i am aware but is just for testing and training, but the pl/sql version is the version requested from the course i am doing.

under programs when i select the start database, it only brings up the command prompt, i was then thinking that the GUI is launched from the sqlplus cmd...so i am currently stuck.


further it would appear the "get started" link will not connect via mz browser also for address 127.0.0.1:8080/apex/f

i get msg in opera saying this site cannot be reached.
Re: installtion problem pl/sql v11g xe [message #672295 is a reply to message #672294] Wed, 10 October 2018 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
consider to obtain a working Oracle database via different route
First install Virtualbox
https://www.virtualbox.org/
Then load into preconfigured VM
https://www.oracle.com/technetwork/community/developer-vm/index.html

HTH & YMMV!
Re: installtion problem pl/sql v11g xe [message #672315 is a reply to message #672284] Wed, 10 October 2018 16:05 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Can you confirm that you have installed XE correctly? According to the installation guide?
https://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm
Re: installtion problem pl/sql v11g xe [message #672325 is a reply to message #672315] Thu, 11 October 2018 08:15 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
so basically i want to do this course to run scripts and practice dba type role. from udemy.com "learn oracle pl/sql - a comprehensive guide", is 11gxe not suitable?


thanks
Re: installtion problem pl/sql v11g xe [message #672326 is a reply to message #672325] Thu, 11 October 2018 08:27 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
saj1011 wrote on Thu, 11 October 2018 06:15
so basically i want to do this course to run scripts and practice dba type role. from udemy.com "learn oracle pl/sql - a comprehensive guide", is 11gxe not suitable?


thanks

11gxe is suitable.
For novice, it can be a challenge to correctly install & get operational.
We only know what you post here.
If you diligently follow the XE Installation Guide you have a chance to get XE online.
If you just blindly start pointing & clicking, the result will be a long & arduous task to debug.

Can you post COPY & PASTE proof that Oracle XE database has been properly installed?
Re: installtion problem pl/sql v11g xe [message #672333 is a reply to message #672326] Thu, 11 October 2018 09:36 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
here are folders on my laptop.
so it looks like i can get the online version finally working. but still very basic understanding.

how to get GUI version working on laptop?

thanks

  • Attachment: oxe11g.jpg
    (Size: 24.72KB, Downloaded 30 times)
Re: installtion problem pl/sql v11g xe [message #672335 is a reply to message #672333] Thu, 11 October 2018 10:23 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
Can you post COPY & PASTE proof that Oracle XE database is online & operational?

COPY the results from OS commands below

lsnrctl status
lsnrctl service

PASTE the results from OS commands above back here.
Re: installtion problem pl/sql v11g xe [message #672336 is a reply to message #672333] Thu, 11 October 2018 10:28 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
so, this is what i want to achievem to run the app on my laptop so i can follow the course.

see attached.

how do i get this running?
thanks

  • Attachment: o1.jpg
    (Size: 46.26KB, Downloaded 31 times)
Re: installtion problem pl/sql v11g xe [message #672337 is a reply to message #672336] Thu, 11 October 2018 10:55 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
Please do as Blackswan asked and use Cut & Paste your session for us to see. Attachments could contain a malicious payload so people don't like to click on them.
Re: installtion problem pl/sql v11g xe [message #672343 is a reply to message #672336] Fri, 12 October 2018 02:51 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
hello, i reinstalled as admin last night...here are cmd prompt details as requested:


C:\WINDOWS\system32>lsnrctl service

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2018 09:48:15

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: MEDIA-LAPTOP, pid: 3696>
(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=52280))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully

C:\WINDOWS\system32>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2018 09:48:38

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 11-OCT-2018 23:17:12
Uptime 0 days 10 hr. 31 min. 26 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\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\Media-Laptop\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
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...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\WINDOWS\system32>
Re: installtion problem pl/sql v11g xe [message #672344 is a reply to message #672343] Fri, 12 October 2018 02:53 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
[ Code ] tags would help too Smile
C:\WINDOWS\system32>lsnrctl service

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2018 09:48:15

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: MEDIA-LAPTOP, pid: 3696>
(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=52280))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully

C:\WINDOWS\system32>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 12-OCT-2018 09:48:38

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 11-OCT-2018 23:17:12
Uptime 0 days 10 hr. 31 min. 26 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\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\Media-Laptop\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Media-Laptop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
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...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\WINDOWS\system32>
Re: installtion problem pl/sql v11g xe [message #672345 is a reply to message #672343] Fri, 12 October 2018 03:11 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
That looks fine (well, the look is fine now that gazzag has formatted it correctly) you should be able to connect with SQL Developer no problem. What happens hen you try?
Re: installtion problem pl/sql v11g xe [message #672347 is a reply to message #672345] Fri, 12 October 2018 03:20 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
i dont know how to start it. there is no option on my start menu or button or shortcut.
Re: installtion problem pl/sql v11g xe [message #672348 is a reply to message #672347] Fri, 12 October 2018 03:24 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Have you installed SQL Developer?
https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Re: installtion problem pl/sql v11g xe [message #672351 is a reply to message #672348] Fri, 12 October 2018 03:46 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
i installed this

Oracle Database Express Edition 11g Release 2 for Windows x64

, like the guy on my course told me to:

https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Re: installtion problem pl/sql v11g xe [message #672352 is a reply to message #672351] Fri, 12 October 2018 03:47 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
from udemy.com "learn oracle pl/sql - a comprehensive guide"
Re: installtion problem pl/sql v11g xe [message #672353 is a reply to message #672351] Fri, 12 October 2018 03:49 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
Well, that was very nice of the guy on your course. Did he also tell you to install SQL Developer? You have to develop your problem solving skills, man! You said you wanted to run Sql Dev. SQL Dev is not installed on your PC. Now, what might the appropriate action be?

[Updated on: Fri, 12 October 2018 03:49]

Report message to a moderator

Re: installtion problem pl/sql v11g xe [message #672354 is a reply to message #672352] Fri, 12 October 2018 03:50 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
also, the place i work at only has the 11g r11.2 v12.1 enterprise version.

[Updated on: Fri, 12 October 2018 03:52]

Report message to a moderator

Re: installtion problem pl/sql v11g xe [message #672357 is a reply to message #672353] Fri, 12 October 2018 04:02 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
download the developer version...which i already thought i had as guy on course said to download 11g xe....

i figured out yesterday i had the wrong version possibly on my laptop, but had to wait until i got home after work to download and run as administrator, hoping that might give me some more options - but it did not...

so anywyay, i will have to wait until tonight after work again to download

why wait until after work you might ask if i need it for work...well i am not allowed to download third party software to my work pc for testing purposes!
and i have to download it all via hotpsot via phone if choose to do it during office hours, which would cost a fortune on mobile data or i wait until i get home and do it for free!

lovely story...

Re: installtion problem pl/sql v11g xe [message #672358 is a reply to message #672357] Fri, 12 October 2018 04:28 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
Get back to us when you've installed SQL Developer Razz
Re: installtion problem pl/sql v11g xe [message #672359 is a reply to message #672357] Fri, 12 October 2018 04:49 Go to previous messageGo to next message
John Watson
Messages: 7619
Registered: January 2010
Location: Global Village
Senior Member
I think I understand. You have missed a fundamental point: Oracle is a client-server database. You need both an Oracle server (in your case, database XE edition) and an Oracle client (in your case, SQL Developer). One is useless without the other. If you google "client-server architecture" or similar you can do some some pre-requisite studying.
Re: installtion problem pl/sql v11g xe [message #672360 is a reply to message #672359] Fri, 12 October 2018 05:01 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
yes i did miss that, but my online course did not explain that. i am innocent! lol

it shows how to install, then some login stuff on sqlplus, then yer man jumps straight into this gui and i am like where did this come from?

ok, so all being well i can start the blooming course in next days as i wil have the right platform!

thanks for your help.
Re: installtion problem pl/sql v11g xe [message #672361 is a reply to message #672360] Fri, 12 October 2018 05:05 Go to previous messageGo to next message
saj1011
Messages: 13
Registered: October 2018
Junior Member
any recommndations for beginners for easy to follow pl/sql courses would be very welcome...
literally learning it from scratch.
thanks

[Updated on: Fri, 12 October 2018 05:05]

Report message to a moderator

Re: installtion problem pl/sql v11g xe [message #672365 is a reply to message #672284] Fri, 12 October 2018 07:38 Go to previous messageGo to next message
EdStevens
Messages: 983
Registered: September 2013
Senior Member
saj1011 wrote on Wed, 10 October 2018 05:21
hello,

i downloaded the v11g xe for testing purposes, however it will not log in to the new database upon loading the "start database", it brings up the small black screen and simply says C:\Windows\system32>


i am running windows 10 and downloaded the 64 bit version,


so please tell me how to launch the database on the initial msdos command screen.

thanks

I see you also have a thread on this at OTN .. https://community.oracle.com/thread/4177367
Re: installtion problem pl/sql v11g xe [message #672366 is a reply to message #672284] Fri, 12 October 2018 07:44 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
saj1011 wrote on Wed, 10 October 2018 11:21
hello,
so please tell me how to launch the database on the initial msdos command screen.
The command-line tool supplied with Oracle versions that you can use to interact with the database is called SQL*Plus. You will find the file "sqlplus.exe" in the %ORACLE_HOME%\bin directory but the installer would have added it to your PATH. You could do worse than start here.
Re: installtion problem pl/sql v11g xe [message #672378 is a reply to message #672361] Fri, 12 October 2018 15:38 Go to previous message
EdStevens
Messages: 983
Registered: September 2013
Senior Member
saj1011 wrote on Fri, 12 October 2018 05:05
any recommndations for beginners for easy to follow pl/sql courses would be very welcome...
literally learning it from scratch.
thanks
So what background/training/experience DO you have? Any educational process, whether it be in a university classroom, an online course, or even asking for help on a forum such as this (and OTN, where you are also working this same issue, with a lot of the same participants) assumes a certain level of knowledge. It appears that people on this forum (and OTN) have assumed too much on your part, so perhaps you should reset our expectations by explaining your background and training, and why you think that is sufficient to prepare you for DBA level work. I will say that DBA is not an entry level position.
Previous Topic: Migrations and replications
Next Topic: Archiving redo log on standby
Goto Forum:
  


Current Time: Fri Oct 19 22:59:16 CDT 2018