After checking to ensure the listener was up and doing a tnsping to the instance via the cmd window, I was at a loss so proceeded to Google to try to find the answer. After some digging, it seemed to be a fairly common problem. However, none of the solutions worked for me. At least none of them individually. After piecing together several solutions that others posted I finally was able to get the installation to succeed. Hopefully this helps you if you are stuck in a similar situation.
Note that this installation is on a machine without a static ip or domain.
If you haven't done so already, make sure to add the <ORACLE_HOME>\bin directory to your path so that you can run the Oracle utilities without having to be within the <ORACLE_HOME>\bin directory itself.
Let's get started!
First, install the Microsoft Loopback Adapter. This will allow you to specify a dummy host/domain on the loopback ip. See the following Microsoft TechNet post for details:
https://social.technet.microsoft.com/Forums/windows/en-US/259c7ef2-3770-4212-8fca-c58936979851/how-to-install-microsoft-loopback-adapter
Once you have the loopback adapter created and have updated your hosts file, stop the Oracle listener via the command line using the command "LSNRCTL.EXE stop". Use the "Net Configuration Assistant" to remove the listener and add a new one with all the default values and the same name.
Next, you will need to update your listener.ora and tnsnames.ora files to set the host as the dummy host/domain you specified in the hosts file.
The listener.ora file located at <ORACLE_HOME>\network\admin will contain something similar to the following:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <YOUR HOSTNAME>)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
The tnsnames.ora file located at <ORACLE_HOME>\network\admin will contain something similar to the following:
<DB_SID> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <YOUR HOSTNAME>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <GLOBAL DB NAME>)
)
)
Now you will need to start the listener back up again using the command "LSNRCTL.EXE start".
Ensure the listener is up by using "tnsping <db sid>".
Next run the command "emca -config dbcontrol db -repos recreate" as Administrator and follow the configuration prompts displayed. If it completes successfully it will also list the URL you need to go to in order to view the Enterprise Manager page.
Being an entrepreneur doesn't imply that you know all the most recent news in the IT business or expertise to compose code in Python. This is the situation when organizations with experience help with re-appropriating versatile improvement administrations. They know precisely the number of individuals that are required in the group and why they ought to employ a web application designer. During the time spent employing an independent portable application engineer in 2023, in the event that your task includes a WordPress-based application, you may likewise require a WordPress module designer independent to make or modify modules custom-made to your application's particular necessities>> look what i found
ReplyDeleteIndependent vehicles. Creating AVs requires mastery in both PC vision (artificial intelligence area) and AI to empower the car to explore the climate.
ReplyDeleteCustomized medical services. Normal language handling and AI work with the advancement of custom-made clinical consideration frameworks for better tolerant information examination and altered treatment proposals.
Extortion recognition. Extortion recognition frameworks require simulated intelligence and ML to distinguish atypical way of behaving and banner likely trick>> ai and machine learning companies