Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Publish to Apex

kgambleJan 14 2016 — edited Jan 14 2016

When I use right-click, Publish to Apex and fill in the fields required, I get an error for invalid Theme id regardless of which theme I choose.

When I use the wwv_flow_create_app_from_query package there is no such error unless I use theme id > 22

How do I get the right click action to work?

Tried on oracle 12 and oracle 11g, using apex 5 and apex 4.2

sqldeveloper version : 4.1.0.19

Thanks

kathryn

Comments

Christian.Shay -Oracle

That error is very generic that just means "things are really messed up!"

If you do not see OracleServiceXE, then you have your answer - the install failed.

Did you set ORACLE_HOME? Don't set that on Windows. You shouldn't have to set any environment variable after install.

Possibly the PATH did not get set to the new Oracle home.

SullivanK

Thanks for your reply Christian,

Yeah I figured something went wrong :-) , but I don't even know where to start looking. I didn't set any environment variables, but I was expecting to see it already set, which was not the case.

So we have services missing and an incorrect path set? Mind giving me some debugging tips? i have no idea what to check and can't really find anything.

Christian.Shay -Oracle

If you do not see OracleServiceXE, there is no hope for it working in the current state. That is the Oracle database software.

When you installed it, did you use the user interface version of the install (as opposed to command line)? If so, did it show you a final screen with connection strings (similar to what is shown in chapter 5 of the documentation)?

Is there anything unusual about your Windows 10? Are the drives involved local drives? Is it an up to date version of windows 10?

If you are using a domain user, can you try creating a local administrator user and log in and install with that?

SullivanK

Do you mean this?

Capture.PNG

Then yes.

Local drive yes, I have only one, no partitions, if thats an issue too. Also up to date version of windows.

Tried with no differing results:

- creating another admin and installing with that one

- installing 11 xe, uninstalling that one and then reinstalling 18

- downloading 18xe again and installing that version.

Do you think installing from command line would make a difference?

Gaz in Oz

That screenshot suggests it did install.

What user did you use for the install, Adminsistrator?

What user are you looged in as when you try and view Services?

...when you say "I installed 18 XE on windows 10, but get this error when I try to login via cmd." show how you tried to login via cmd.

SullivanK

Thanks Gaz, I do realize that the screenshot suggests it did install... It's the first line on screen after all.

Yes I installed it as an administrator, even tried making another admin as Christian suggested. When i view Services, I tried logging in as the administrators (both of them, only two users on my laptop).

logging in via cmd is done via the usual:

"sqlplus /nolog" and then conn sys as sysdba

or "sqlplus / as sysdba"

or all other ways of logging in I could find on google, but I sure can reinstall it and paste a screenshot.

Christian.Shay -Oracle

Just to confirm again, you do NOT have OracleServiceXE in the services Window?

If not, the installation failed and we will need to find out why. I am talking to some of the engineers to see what the next step is.

SullivanK

yeah exactly, I do NOT have it.

Services.jpeg

Maybe this screenshot helps?

Christian.Shay -Oracle

Ok, thanks for your patience. Stand by.. we will probably have to look at your log files to figure out what is going wrong. I will get back soon.

SullivanK

Thanks Christan. It's for personal tinkering at home and I can't really get to my laptop right now so no absolute hurry. Asked my DBA friend to take a whack at it after work too, hopefully he will get it working. If so, I will post update and solution ofcourse.

SullivanK
Answer

Guess we found it.

My home laptop is Win Home edition.

https://docs.oracle.com/en/database/oracle/oracle-database/18/ntdbi/oracle-database-software-requirements.html#GUID-CEF2…  says that is not supported, only Pro, Enterprise, and Education editions so I'm out of luck.

Would be nice if the installer could check this as well.

Thanks for your help Christian.

Marked as Answer by SullivanK · Sep 27 2020
SBiedrzycki

I'm not entirely sure that the Windows edition is related.  I've actually spent the day wrestling with installing the XE with no luck.  I get the same error but I'm on Win 10 Pro.  Notable difference in my case is that I don't even have the recovery service even.  Only service running is the TNS listener. 

I also tried working around the problem by directly configuring a new DB with DBCA but have brickwalled at another issue with error [DBT-50000] Unable to check for available memory. 

Otherwise, my installation approach was the same.  Ran Setup as Administrator from my normal user account which is part of the Administrators group.  Installation completed successfully.  Same error when attempting to login through sqlplus.  I had no prior Oracle installations on the system.  Problem was reproducible through uninstall, reinstall with restarts in between to ensure cleanup.

1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 11 2016
Added on Jan 14 2016
1 comment
521 views