Skip to Main Content
Forums

Oracle Database Discussions

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!

Datafiles are outside the Oracle_Base

Hi, Oracle community,
Is there any impact on the normal function of the database when/if the datafiles are outside the $ORACLE_BASE. This is due to the fact that I had a space constraint on the directories holding the ORACLE_HOME and ORACLE_BASE ,

Kindly advise
This post has been answered by saratpvv on Sep 8 2021
Jump to Answer

Comments

User_OOTEX

OracleExpressInstall.PNG
Will the TNS-04415: File i/o error cause the XE Database installation to hang indefinitely?
Oracle Net Services Configuration:
ProfileException: Could not save Profile: TNS-04415: File i/o error
ListenerException: Could not save listener: TNS-04415: File i/o error
ServiceAliasException: Could not save Service Alias: TNS-04415: File i/o error

Prior to my failed installation attempt the
System > System Properties > Advanced> System Variable
TNS_ADMIN
was already set to a directory that I do not have write access to.
\\AUP-USFFS02.forest.usf.edu\Azure$\IT-DM\oracle\network\admin
will this prevent the XE database from installing?
Do i need to temporarily un-set this system variable for XE to install?

User_OOTEX
Answer

un-setting the TNS_ADMIN system variable was not enough.
Manually removed the entire original failed oracle express installation by following rebellion rider's outstanding video tutorial http://www.rebellionrider.com/how-to-uninstall-oracle-database-18c-by-manish-sharma/
Delete the Environment Variable
Delete the Oracle Database 18c Windows registries
Restart Your System
Delete the Oracle Home User and Groups
Delete The Oracle Database 18c
Re-ran the Oracle Express setup.exe successfully this time. The XE database installed without further issue

Marked as Answer by User_OOTEX · Mar 10 2021
User_IRLFL

Someone has spent more than 4 hours waiting for installer finishes?
Additionally, How heavy is the installation folder? My folder is up to 15 GB and installation does not finish yet

1 - 3

Post Details

Added on Sep 7 2021
#database, #general-database-discussions
2 comments
93 views