RE: Oracle_In_NT !!!
Did you set the default oracle_sid? Is the database running when you try to connect? -Original Message- Dumas Sent: Friday, March 23, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Hi there I have a problem when I install Oracle 816 on NT. I have done it twice before amd it worked, that was Oracle 805 and 806. Now I am trying to install and create database on NT, Oracle 8i version, 816. I get the error ORA-12560, which protocol adapter error, whenever I try connect to server manager. At first I thought it's because I created the database with the option during installation. I tried to install software only and then use scripts to create the database manually, but I get the same error. Can somebody help me? ___ http://www.webmail.co.za the South-African free email service WIN R10 000 by registering for free online options for EasyMoney in http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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: Kevin Kostyszyn 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: Oracle_In_NT !!!
To use svrmgrl, the following conditions must be met: 1. the NT Service must be started. (use the "net start" command or "srvinfo" to display service info) 2. the environment variable ORACLE_SID must be defined C:\>set oracle_sid=DEV C:\>svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-12560: TNS:protocol adapter error SVRMGR> quit Server Manager complete. C:\>net start oracleservicedev The OracleServiceDEV service is starting ... The OracleServiceDEV service was started successfully. C:\>net start oracleorahome81tnslistener The OracleOraHome81TNSListener service was started successfully. C:\>set oracle_sid=DEV C:\>set oracle_sid oracle_sid=DEV C:\>svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR> quit Server Manager complete. hth, Paul Jackson Dumas wrote: > > Hi there > > I have a problem when I install Oracle 816 on NT. I have done it twice > before amd it worked, that was Oracle 805 and 806. Now I am trying to > install and create database on NT, Oracle 8i version, 816. > I get the error ORA-12560, which protocol adapter error, whenever I > try connect to server manager. At first I thought it's because I > created the database with the option during installation. I tried to > install software only and then use scripts to create the database > manually, but I get the same error. Can somebody help me? > ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Oracle_In_NT !!!
Here is an excerpt from Metalink 2.- Starting database via SVRMGRL or SQL*PLUS Problem: Launching svrmgr, or attempting a connection in sqlplus to start up the database, you get an ORA-12560 Solution: - If the drive is NTFS then check the permissions on the drive or oracle home to be sure SYSTEM has full control on all subdirectories and files. - Be sure the instance is started Goto Start-->Settings-->Control Panel-->Services and check if the database service is started. - Be sure the ORACLE_SID is set in the registry correctly. Goto Start button-->RUN-->type regedt32--> Goto the following directory tree within the registry - HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE - highlight ORACLE - look on the left side look for ORACLE_SID = To change you can highlight ORACLE_SID - right click on your mouse and select modify. Enter the SID. The above is only valid when using DEFAULT_HOME, when you have another home then you need to highlight that HOME under ORACLE key usually HOME1-HOMEx - No spaces can be entered after the = when setting ORACLE_SID at the DOS Prompt, set oracle_sid=xyz should be used and not set oracle_sid = xyz. - If you have verified that ORACLE_SID is properly set, and the service is running, yet you still get an ORA-12560, then it is possible that you have created an instance with a non-alphanumeric character. The Getting Started Guide for Oracle8i on Windows NT documents that SID names can contain only alphanumerics, however if you attempt to create a SID with an underscore or a dash on Oracle8i you are not prevented from doing so. The service will be created and started successfully, but attempts to connect will fail with an ORA-12560. - If doing the above and the error still occurs on a new instance creation then the createdb scripts did not run correctly. Explanation: An ORA-12560 using svrmgrl on WinNT is usually an indication that the OS system/environment is not set up correctly. Don Bricker Information Systems Analyst Illinois Environmental Protection Agency 1021 North Grand Avenue East Mail Code #32 Springfield, IL 62794-9276 [EMAIL PROTECTED] (217) 558-2290 >>> "Jackson Dumas" <[EMAIL PROTECTED]> 03/23/01 03:50AM >>> Hi there I have a problem when I install Oracle 816 on NT. I have done it twice before amd it worked, that was Oracle 805 and 806. Now I am trying to install and create database on NT, Oracle 8i version, 816. I get the error ORA-12560, which protocol adapter error, whenever I try connect to server manager. At first I thought it's because I created the database with the option during installation. I tried to install software only and then use scripts to create the database manually, but I get the same error. Can somebody help me? ___ http://www.webmail.co.za the South-African free email service WIN R10 000 by registering for free online options for EasyMoney in http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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: Oracle_In_NT !!!
1. Make sure thay your service 'OracleService???' (??? is your db name) is up. 2. On DOS prompt, enter 'set ORACLE_SID=???' 3. Then connect to svrmgrl HTH! Prakash -Original Message- Sent: Friday, March 23, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Hi there I have a problem when I install Oracle 816 on NT. I have done it twice before amd it worked, that was Oracle 805 and 806. Now I am trying to install and create database on NT, Oracle 8i version, 816. I get the error ORA-12560, which protocol adapter error, whenever I try connect to server manager. At first I thought it's because I created the database with the option during installation. I tried to install software only and then use scripts to create the database manually, but I get the same error. Can somebody help me? ___ http://www.webmail.co.za the South-African free email service WIN R10 000 by registering for free online options for EasyMoney in http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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: Bala, Prakash 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: Oracle_In_NT !!!
I might be wrong on this but I think you have to create and start the oracle service first. --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Did you set the default oracle_sid? Is the database running when you > try to > connect? > > -Original Message- > Dumas > Sent: Friday, March 23, 2001 4:50 AM > To: Multiple recipients of list ORACLE-L > > > Hi there > > I have a problem when I install Oracle 816 on NT. I have done it > twice > before amd it worked, that was Oracle 805 and 806. Now I am trying to > install and create database on NT, Oracle 8i version, 816. > I get the error ORA-12560, which protocol adapter error, whenever I > try connect to server manager. At first I thought it's because I > created the database with the option during installation. I tried to > install software only and then use scripts to create the database > manually, but I get the same error. Can somebody help me? > ___ > http://www.webmail.co.za the South-African free email service > WIN R10 000 by registering for free online options for EasyMoney in > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - > Now!!! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jackson Dumas > 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: Kevin Kostyszyn > 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuck Hamilton 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: Oracle_In_NT !!!
Well of course, maybe I was assuming too much, my apologies. Kev -Original Message- Hamilton Sent: Friday, March 23, 2001 11:36 AM To: Multiple recipients of list ORACLE-L I might be wrong on this but I think you have to create and start the oracle service first. --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Did you set the default oracle_sid? Is the database running when you > try to > connect? > > -Original Message- > Dumas > Sent: Friday, March 23, 2001 4:50 AM > To: Multiple recipients of list ORACLE-L > > > Hi there > > I have a problem when I install Oracle 816 on NT. I have done it > twice > before amd it worked, that was Oracle 805 and 806. Now I am trying to > install and create database on NT, Oracle 8i version, 816. > I get the error ORA-12560, which protocol adapter error, whenever I > try connect to server manager. At first I thought it's because I > created the database with the option during installation. I tried to > install software only and then use scripts to create the database > manually, but I get the same error. Can somebody help me? > ___ > http://www.webmail.co.za the South-African free email service > WIN R10 000 by registering for free online options for EasyMoney in > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - > Now!!! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jackson Dumas > 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: Kevin Kostyszyn > 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuck Hamilton 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: Kevin Kostyszyn 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: Oracle_In_NT !!!
Chuck is correct. You need to run the oradim.exe utility to create the Oracle_Server service. -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation On Friday 23 March 2001 10:36, Chuck Hamilton <[EMAIL PROTECTED]> wrote: > I might be wrong on this but I think you have to create and start the > oracle service first. > > --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > > Did you set the default oracle_sid? Is the database running when you > > try to > > connect? > > > > -Original Message- > > Dumas > > Sent: Friday, March 23, 2001 4:50 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi there > > > > I have a problem when I install Oracle 816 on NT. I have done it > > twice > > before amd it worked, that was Oracle 805 and 806. Now I am trying to > > install and create database on NT, Oracle 8i version, 816. > > I get the error ORA-12560, which protocol adapter error, whenever I > > try connect to server manager. At first I thought it's because I > > created the database with the option during installation. I tried to > > install software only and then use scripts to create the database > > manually, but I get the same error. Can somebody help me? > > ___ > > http://www.webmail.co.za the South-African free email service > > WIN R10 000 by registering for free online options for EasyMoney in > > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - > > Now!!! > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jackson Dumas > > 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: Kevin Kostyszyn > > 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). > > __ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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: Oracle_In_NT !!!
hi guys what i found is you can stop the oracle service called "oraclecmadmin".In most of the cases this service takes around 99% of cpu. - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -Original Message- Hamilton Sent: Friday, March 23, 2001 10:06 PM To: Multiple recipients of list ORACLE-L I might be wrong on this but I think you have to create and start the oracle service first. --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Did you set the default oracle_sid? Is the database running when you > try to > connect? > > -Original Message- > Dumas > Sent: Friday, March 23, 2001 4:50 AM > To: Multiple recipients of list ORACLE-L > > > Hi there > > I have a problem when I install Oracle 816 on NT. I have done it > twice > before amd it worked, that was Oracle 805 and 806. Now I am trying to > install and create database on NT, Oracle 8i version, 816. > I get the error ORA-12560, which protocol adapter error, whenever I > try connect to server manager. At first I thought it's because I > created the database with the option during installation. I tried to > install software only and then use scripts to create the database > manually, but I get the same error. Can somebody help me? > ___ > http://www.webmail.co.za the South-African free email service > WIN R10 000 by registering for free online options for EasyMoney in > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - > Now!!! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jackson Dumas > 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: Kevin Kostyszyn > 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuck Hamilton 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: Nihar 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).