|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 ERROR ORA-01034 and ORA-12560 not-available/protocol error [message #66882 is a reply to message #66552] |
Thu, 27 February 2003 04:03   |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
CONNECTION PROBLEMS- 8i STANDARD EDITION (ora-01034 / ora-12560)
I GOT ORACLE 8i STANDARD EDITION TO WORK ON WINDOWS XP (COULDN'T GET PERSONAL EDITION TO WORK ON IT, TRIED EVERYTHING) BUT WHEN YOU RESTART THE COMPUTER & THEN TRY TO GO INTO SQL, FORMS OR REPORTS IT WON'T LET YOU CONNECT. THE REASON IS THAT ON THE PERSONAL EDITION YOU HAVE A "START DATABASE" OPTION THAT STARTS THE DATABASE FIRST & THEN YOU WON'T GET THE ora-01034 ERROR, BUT ON THE STANDARD EDITION YOU DON'T HAVE THIS "START DATABASE" OPTION. THEREFORE.........TWO OPTIONS WHEN YOU START/REBOOT (I PREFER OPTION 1)......
1. GO TO THE "svrmgrl" file (in a 'BIN' file - do a search for files if not sure where it is). Double-click on it and a dos_style prompt will open. Type "connect internal" (without the quotes!) and press enter. Then type "startup open". Then wait a short while and the database will be opened. You will then be able to connect to sql, etc without getting this error. It is a good idea to copy this file onto your desktop as a shortcut so that when you boot/restart you can access it straight away.
2. Via the start menu, programs, go to "Database Configuration Assistant" via 'Database Administration' - Choose 'Change Database Configuration', click next - click next again - after a short wait choose one of the options & click next - Then click Finish. Again if using this method it might be better to have it as a shortcut on the desktop.
BY THE WAY IF YOU ARE GETTING THE ora-12560 "PROTOCOL ADAPTER ERROR" THIS IS PROB DUE TO THAT YOU HAVENT GOT THE ORACLESERVICEORCL SET TO START AS "AUTOMATIC". GO TO YOUR "SERVICE FOLDER" (IN WINDOWS XP, RIGHT-CLICK ON THE 'MY COMPUTER' FILE AND CHOOSE 'MANAGE', THEN GO INTO 'SERVICES AND APPLICATIONS' AND THE GO INTO 'SERVICES' & SCROLL DOWN TO THE 'OracleServiceORCL' (That's what it's called on mine), DOUBLE-CLICK ON IT/CHOOSE IT AND CHANGE THE 'STARTUP TYPE' TO "AUTOMATIC". THEN WHEN REBOOTING YOU'LL PRBABLY GET THE ABOVE ERROR WHICH MEANS YOU NEED TO CONNECT YOURSELF ONTO THE DATABASE VIA ONE OF THE OPTIONS.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
) 2 Votes
] 
Blog
Search
Help
Members
Register
Login
Home
