Hello,

I receive an ORA-12560: TNSrotocol adapter error when I try the
following:
sqlplus /nolog
conn / as sysdba

I currently have 8i installed and working properly on the same
machine. I used DBCA to install the new 9i software. I am now trying
to connect to sqlplus so I can create the Database. I am using Remote
Administrator to work on the machine. I think I set all of the
correct parameters on the machine, but is there a document somewhere
to determine the specific parameters that are necessary?

Any assistance that you can give me would be greatly appreciated.

Thank you - Brett

Brett Baloun wrote:

> Hello,
>
> I receive an ORA-12560: TNSrotocol adapter error when I try the
> following:
> sqlplus /nolog
> conn / as sysdba
>
> I currently have 8i installed and working properly on the same
> machine. I used DBCA to install the new 9i software. I am now trying
> to connect to sqlplus so I can create the Database. I am using Remote
> Administrator to work on the machine. I think I set all of the
> correct parameters on the machine, but is there a document somewhere
> to determine the specific parameters that are necessary?
>
> Any assistance that you can give me would be greatly appreciated.
>
> Thank you - Brett

You've got me confused. 8i and 9i or a typo? How did you do it?
What is the value of the ORACLE_SID environment variable?
What is the value of the ORACLE_HOME environment variable?
Is the service started? Which one? How verified?
Is the listener started? Which one? How verified?
When you say "Remote Administrator" what exactly do you mean? What software?

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

In your DOS window, type the following:

set ORACLE_SID=sid
set ORACLE_HOME=C:\directory_where_Oracle_was_installe d

Then try your SQL*Plus stuff.

HTH,
Brian

Brett Baloun wrote:
>
> Hello,
>
> I receive an ORA-12560: TNSrotocol adapter error when I try the
> following:
> sqlplus /nolog
> conn / as sysdba
>
> I currently have 8i installed and working properly on the same
> machine. I used DBCA to install the new 9i software. I am now trying
> to connect to sqlplus so I can create the Database. I am using Remote
> Administrator to work on the machine. I think I set all of the
> correct parameters on the machine, but is there a document somewhere
> to determine the specific parameters that are necessary?
>
> Any assistance that you can give me would be greatly appreciated.
>
> Thank you - Brett

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Brian Peasland <dba@remove_spam.peasland.com> wrote in message news:<4018397C.5ED27102@remove_spam.peasland.com>. ..
> In your DOS window, type the following:
>
> set ORACLE_SID=sid
> set ORACLE_HOME=C:\directory_where_Oracle_was_installe d
>
> Then try your SQL*Plus stuff.
>
> HTH,
> Brian
>
> Brett Baloun wrote:
> >
> > Hello,
> >
> > I receive an ORA-12560: TNSrotocol adapter error when I try the
> > following:
> > sqlplus /nolog
> > conn / as sysdba
> >
> > I currently have 8i installed and working properly on the same
> > machine. I used DBCA to install the new 9i software. I am now trying
> > to connect to sqlplus so I can create the Database. I am using Remote
> > Administrator to work on the machine. I think I set all of the
> > correct parameters on the machine, but is there a document somewhere
> > to determine the specific parameters that are necessary?
> >
> > Any assistance that you can give me would be greatly appreciated.
> >
> > Thank you - Brett
>
> --
> ================================================== =================
>
> Brian Peasland
> dba@remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"


Hi Brian - Thank you for your assistance.

When I set those parameters:
set ORACLE_HOME=d:\oracle\products\9i
set ORACLE_SID=ed11tst

I still get the same error when:
sqlplus /nolog
conn / as sysdba
ORA-12560

I believe all the services are started correctly. However, I am
working w/another DBA who is responsible for the startup - I am just
trying to help her trouble shoot. That being said - please do not
hesitate to mention something that you feel should be basic to Oracle
installations.

Thank you - Brett

Hello -

This issue has been resolved. Everything was set up properly - the
machine just needed to be re-booted.

Thank you for those who helped.

blbaloun@yahoo.com (Brett Baloun) wrote in message news:<a47e0938.0401290746.56759b68@posting.google. com>...
> Brian Peasland <dba@remove_spam.peasland.com> wrote in message news:<4018397C.5ED27102@remove_spam.peasland.com>. ..
> > In your DOS window, type the following:
> >
> > set ORACLE_SID=sid
> > set ORACLE_HOME=C:\directory_where_Oracle_was_installe d
> >
> > Then try your SQL*Plus stuff.
> >
> > HTH,
> > Brian
> >
> > Brett Baloun wrote:
> > >
> > > Hello,
> > >
> > > I receive an ORA-12560: TNSrotocol adapter error when I try the
> > > following:
> > > sqlplus /nolog
> > > conn / as sysdba
> > >
> > > I currently have 8i installed and working properly on the same
> > > machine. I used DBCA to install the new 9i software. I am now trying
> > > to connect to sqlplus so I can create the Database. I am using Remote
> > > Administrator to work on the machine. I think I set all of the
> > > correct parameters on the machine, but is there a document somewhere
> > > to determine the specific parameters that are necessary?
> > >
> > > Any assistance that you can give me would be greatly appreciated.
> > >
> > > Thank you - Brett
> >
> > --
> > ================================================== =================
> >
> > Brian Peasland
> > dba@remove_spam.peasland.com
> >
> > Remove the "remove_spam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good. Now pick two out of
> > the three"
>
>
> Hi Brian - Thank you for your assistance.
>
> When I set those parameters:
> set ORACLE_HOME=d:\oracle\products\9i
> set ORACLE_SID=ed11tst
>
> I still get the same error when:
> sqlplus /nolog
> conn / as sysdba
> ORA-12560
>
> I believe all the services are started correctly. However, I am
> working w/another DBA who is responsible for the startup - I am just
> trying to help her trouble shoot. That being said - please do not
> hesitate to mention something that you feel should be basic to Oracle
> installations.
>
> Thank you - Brett