installtion problem pl/sql v11g xe [message #672284] |
Wed, 10 October 2018 05:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/fc098d340029421f663a5b41a229afcb?s=64&d=mm&r=g) |
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 #672343 is a reply to message #672336] |
Fri, 12 October 2018 02:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/fc098d340029421f663a5b41a229afcb?s=64&d=mm&r=g) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
[ Code ] tags would help too ![Smile](/forum/images/smiley_icons/icon_smile.gif)
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 #672353 is a reply to message #672351] |
Fri, 12 October 2018 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #672359 is a reply to message #672357] |
Fri, 12 October 2018 04:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #672366 is a reply to message #672284] |
Fri, 12 October 2018 07:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
saj1011 wrote on Wed, 10 October 2018 11:21hello,
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
saj1011 wrote on Fri, 12 October 2018 05:05any 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.
|
|
|