RATE THIS ANSWER
+1
Click to Vote:
1
0
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 Answered:
Jul 30 2009 3:42 PM GMT by Meandyou 
1795 pts.