Hi,
I believe that you can change that in the INIT.ORA file (or its equivalent (I always have to qualify my Oracle answers because most everyone uses Oracle on a PC-type platform while I worked with it on mainframe using MVS, OS/390, z/OS and ofcourse there is no "init.ora" but we did have the equivalent))
secondly, if you are using TNSPROC (or its PC-type equivalent called SQLNET you may have changes to the listeners as well.
as always, back it up first ... just in case.
Last Wiki Answer Submitted: July 30, 2009 3:42 pm by Meandyou5,205 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.