Skip to Main Content
Forums

Oracle Database Express Edition (XE)

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!

OracleXE-Server-Install-Message: The 8081 port is in use.

user7698480Jun 7 2013
Dear all,

I've a problem installing in a Windows System Operational with MCAfee anti-virus that uses the 8081 port number.

OracleXE-Server-Install-Message: The 8081 port is in use.

I need to install Oracle XE in the silent mode.

I'm using the following command line for it:
setup.exe /verbose /s /f1"C:\DISK1\response\OracleXE-install.iss" /f2"C:\oracle_log.txt" /V"/l*v "C:\DISK1\oracle_msi_log.txt""

I already had changed the HTTPPort number in the OracleXE-install.iss file, but the installation error didn't stoped.

How can I change the HTTPPort number in a installation of the "Oracle Database 11g Release 2 Express Edition Windows - 32bits"?

Best regards,

Jener Garcia Menezes
System Architect at Prosegur S/A

11g apex error xe windows

Comments

Hi Jon,
there is a setting for this when using the new Data Load Definitions in APEX 21.1.
After creating the data load, navigate to Shared Components, Data Load Definitions
Edit your very Data Load Definition
Click the button to edit the Data Profile, which contains all information about the format, columns or data types
Scroll down towards the bottom and you'll see an attribute named Skip Rows.
Does that help?
regards
-Carsten

Jon Finke

Alas, it appears too late - I need to skip the rows when defining the columns to match. It looks like while I can skip the rows, I have to go in and manually define each of the columns.
But perhaps I can edit the original spreadsheet to make the data definition...

Answer

Hi Jon,
ah - that's right. At design time there is no attribute to specify the amount of rows to skip. But the column mapping is only done once; so for the sample file you're uploading, you can also manually remove the rows in question, then create the data load definition, add the "Rows to Skip" attribute and save. Then you should be good, right?
But this is a good heads-up: We might have the Skip Rows attribute in the wizard ...
best regards
-Carsten

Marked as Answer by Jon Finke · Jul 29 2021
Jon Finke

Carsten,
If I edit the excel file ahead of time, delete the header rows, use that to create the data load template, I can then use that to load the spreadsheet. That will work for my application.
But it would be really nice to have the SKIP_ROWS available as an option the wizard when defining the load sources.

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

Post Details

Locked on Jul 5 2013
Added on Jun 7 2013
#11g, #apex, #error, #windows, #xe
0 comments
658 views