Changing to a shared server

To change your Oracle 9i release 2 database from a dedicated server to a shared server, you must change the number of dispatchers to at least one. To do this you can enter the following command:

This statement is supposed to change the server for the current instance and when the instance is shut down and restarted. But, there is one small problem. If you run this statement you will receive the following error message:

The alter system statement is an apparent bug. This statement works without the "scope=" parameter.

The workaround for the alter system statement is as follows:

1. Create a pfile from your current spfile. Execute the following statement as sys user:
2. Edit the just created pfile 'init2test1.ora' by changing the line:
3. Create an spfile -- spfile2test1.ora, from the just edited pfile -- init2test1.ora as a sys user:
4. Shut down the database.
5. Copy the just created spfile -- spfile2test1.ora to the current spfile -- spfiletest1.ora
6. Start up the database.

Reader ...

To continue reading for free, register below or login

Requires Membership to View

To gain access to this and all member only content, please provide the following information:

Email Address:

By joining SearchOracle.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy

To read more you must become a member of SearchOracle.com

As an existing member of the TechTarget network please activate your SearchOracle.com account 

By joining SearchOracle.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database administrator Understanding SQL string functions What is the difference between a database engineer, architect and administrator? Import on one table from dump file Error during RMAN backup Can I drop a column in SYS schema? STATSPACK tool: transaction vs. execution measurement Should I port from Microsoft Access? How can I find statistics on total memory usage and database connections? Installing multiple Oracle homes Modifying SYS password in a RAC environment Oracle database design and architecture Why am I receiving Oracle memory allocation errors? How to join two tables with unique keys in Oracle Can I check an Oracle instance without logging into the Oracle server? How does the Oracle LGWR write to online redo log files? How to determine your SQL database through needs analysis Breaking down the contenders in the SQL database market The MySQL open source database in the enterprise Diving deeper into the SQL database features What managers should consider when starting a database scaling project How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table Oracle error messages Why am I receiving Oracle memory allocation errors? Oracle tutorial library: SearchOracle.com's learning guides Oracle error 6550 may mean incorrect Oracle export version Why does the archive log in Oracle give me the ORA-16032 error? Are we getting the ORA-00382 error because we're at maximum block size? How do I solve the ORA-00257 error in Oracle? Solving common Oracle errors guide Error during RMAN backup ORA-12560 error with Oracle 10g Instant Client Unable to view Oracle tables in NetBeans

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary E. F. Codd  (SearchOracle.com) extent  (SearchOracle.com) flexfield  (SearchOracle.com) foreign key  (SearchOracle.com) multidimensional database  (SearchOracle.com) object-oriented database management system  (SearchOracle.com) quad tree  (SearchOracle.com) relational online analytical processing  (SearchOracle.com) row  (SearchOracle.com) splay tree  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

feedback:

Ofer H. writes: To change any static parameter enter the database "as sysdba" and type: then type:

The database will restart using the new spfile parameters.

Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.