RE: oracle installation problem
You have successfully install the software, but it fails during database creation. Finish your installation without creating a database, and perform the following steps: 1. Run Database wizard to create a database. 2. At the end of the Database Wizard choose the option to have the files created into an empty directory. 3. Make sure that the parameter file is located at the correct directory, or start the instance NOMOUNT with the pfile option. 4. From there onwards you can proceed with the database creation. You can edit the .bat file that is created with the database wizard, and run the commands line by line if the above is not the solution, in order to find where the problem lies. Regards Theodoros Demosthenous Manager, Product Services Edams Technology Ltd Tel.: +357 22 478300 (Main) Tel.: +357 22 478408 (Direct) Fax: +357 22 478578 E-mail: [EMAIL PROTECTED] www.edams.com -Original Message- Sent: 01 July 2002 11:18 To: Multiple recipients of list ORACLE-L Check that you have the right path for it. Also check that you have the directory created - Oracle does not create one for you. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 7:33 AM when we install oracle 8.1.6 on Windows NT following error occoured. ora-01503 : create control file failed after instalation following message desplayed - global db name :ghytwo database system identifier(sid);orcl internal account password:oracle sys acc pas. :change_on_install system account password :manager Also listener.ora file not genereted(empty) Please suggest solution. It is urgent. Atul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i R2 not automatically starting up after upgrade
Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i R2 not automatically starting up after upgrade
The parameter to look in the registry is ORA_ORA9I_PFILE and points to the parameter file. Make sure that it is located there. Regards -Original Message- Sent: Friday, June 14, 2002 6:16 PM To: '[EMAIL PROTECTED]' Check whether the service finds your initsid.ora file. The parameter in the registry might point to a different location for the service. You can find the parameter file and copy paste it to the location that the service is looking for it. I hope that this will help. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i R2 not automatically starting up after upgrade
Check whether the service finds your initsid.ora file. The parameter in the registry might point to a different location for the service. You can find the parameter file and copy paste it to the location that the service is looking for it. I hope that this will help. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:44 PM To: Multiple recipients of list ORACLE-L I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though. _YEX_ ))) -Original Message- Sent: Friday, June 14, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Are you using a domain to connect to your PC. You should go into services and OracleServiceSID --- Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain. Stop and restart the service, and check that the memory is reserved for the instance. Regards Theodoros -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:22 PM To: Multiple recipients of list ORACLE-L I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is ORA-27101: shared memory realm does not exist. If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks. _YEX_ /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D Contr Det 1 AFRL/WSI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command?
My apologies for excluding the list from my email. Regards Theo -Original Message- Sent: 04 June 2002 09:21 To: '[EMAIL PROTECTED]' corresponding datafile thru operating system command? Sorry for the delay, but this is to our time difference. Please find a more detailed explanation below: Dropping Datafiles and Tempfiles Unlike files that are not Oracle managed, when an Oracle-managed datafile or tempfile is dropped, the filename is removed from the control file and the file is automatically deleted from the file system. The statements that delete Oracle-managed files when they are dropped are: DROP TABLESPACE ALTER DATABASE TEMPFILE ... DROP Dropping Online Redo Log Files When an Oracle-managed online redo log file is dropped its Oracle-managed files are deleted. You specify the group or members to be dropped. The following statements drop and delete online redo log files: ALTER DATABASE DROP LOGFILE ALTER DATABASE DROP LOGFILE MEMBER In Oracle9i Rel.2 you can use the following: AND DATAFILES clause When you specify INCLUDING CONTENTS, the AND DATAFILES clause lets you instruct Oracle to delete the associated operating system files as well. Oracle writes a message to the alert log for each operating system file deleted. This clause is not needed for Oracle-managed files. The following example drops the tbs_02 tablespace and deletes all associated operating system datafiles: DROP TABLESPACE tbs_02 INCLUDING CONTENTS AND DATAFILES; I hope that this was more helpful. Regards Theodoros -Original Message- Sent: 04 June 2002 06:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Theodoros Demosthenous corresponding datafile thru operating system command? Dear Mr Theo, Thanks for your enclosed mail. You mean to say if it is some earlier version, then we need to drop the tablespace, delete corresponding dbf file thru operating system command and recreate the tablespace the corresponding dbf datafile thru create tablespace command? Please elaborate. Regards Kamal Mutneja --- Theodoros Demosthenous [EMAIL PROTECTED] wrote: Only in Oracle9i Rel.2 this can be done. Regards Theo -Original Message- Sent: 03 June 2002 09:53 To: Multiple recipients of list ODTUG-SQLPLUS-L corresponding datafile thru operating system command? Hi Can we drop and re-create tablespace without deleting the corresponding datafile thru operating system command? Regards Kamal Mutneja __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Kamal Mutneja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).