|
-
ORA-00119 during upgradation
Hi,
I am doing db upgradation from 9.2.0.7 to 10.2.0.3 on windows
While running dbca, the upgradation is fails, with the error
ORA-00119 invalide specification for system parameter.
LOCAL_LISTENER
failure in processing system parameters.
My source ie 9.2.0.7 init.ora also doesn't have this parameter.
I am not sure why it is taking this value and from where.
If i say Ignore, then it says oracle not available and forces me to exit.
can somebody guide me.
thx
sunil
-
You probably have to add local_listener parameter to your init.ora file pointing to the same service you want to upgrade.
By the way, there is not such a word as "upgradation".
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
 Originally Posted by PAVB
You probably have to add local_listener parameter to your init.ora file pointing to the same service you want to upgrade.
By the way, there is not such a word as "upgradation".
Pavb,
Thanx. I will try to add the parameter.
Here is the excerpt from the WordWeb dictionary
Noun: upgradation
Usage: Asia
Act or process of upgrading a computer network, hardware, software, etc; upgrade
May be not used in your part of the world, but i guess it is Ok to use in Asia...
-
...and that's why we French people keep our language under control, not to let it turn into such a mess 
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
...and that's why we French people keep our language under control, not to let it turn into such a mess
May be; but who cares....
I never asked you whether your language is under control or not.
Try your lecture in some french forum....
-
Originally Posted by sunidba
May be; but who cares....
I never asked you whether your language is under control or not.
Try your lecture in some french forum....
You are not polite, actually it doesn't surprises me 
no soup for you, one year!!!
...and not help either 
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote