Re: new to oracle

ron wrote:

> cut and paste of what I did
>
> D:\Documents and Settings\Ronald>set oracle_sid=orac
>
> D:\Documents and Settings\Ronald>sqlplus system/manager
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Sat Feb 7 15:46:54 2004
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
>
> Enter user-name: orac
> Enter password:
> ERROR:
> ORA-12560: TNS:protocol adapter error

Try this instead

1. Open a DOS window.
2. Navigate to d:\oracle\ora81\bin (or where-ever the bin directory is)
3. tnsping orac (did it ping successfully?)
4. lsnrctl status (is the listener started?)
5. if the listener is not started lsnrctl start
6. svrmgrl
7. connect internal
8. select count(*) from tab$; (did you get back a count?)
9. if not ... startup
10. Repeat the above after
11. oracle_home=d:\oracle\ora81 (use the correct Oracle home)
12. oracle_sid=orac

For each step post any errors.

Only if all of this works perfectly is the database open so that you can get in using SQL*Plus.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)