Oracle 8..1.7 creating a database from clean install

[exrational]

I am trying to create a database from a clean install. I select typical settings etc throughout the install.however i did not create a default database.

I am trying to create a db now but at 90% of install i get this message

ORA-12560 TNS protocal adapter error
ignore or abort.

what does this mean>? what should I do?>? do i have to do anything after installation before creating a database TNS lister is running in services

[Yogeeraj_1]

hi,

could be a problem with the SID you have used during the installation.

Make sure that the database's SID does not have any spaces or special characters in the name, such as "ORCL_8.1.7.4"

revert.

regards
yogeeraj

[Cheryl Griffin]

If you google this error you will find lots of troubleshooting tips for this error:
http://www.google.com

here are a couple:
http://www.cryer.co.uk/brian/oracle/ORA12560.htm
http://www.orafaq.com/error/ora-12560.htm
Cheryl

[Brian Crabtree]

This will depend on the system. If you are doing this on Windows, and are using Terminal Services to access the system, then you need to "set LOCAL=", which will allow an 'internal' connection to work normally. If you are on UNIX, make sure that your ORACLE_SID is set correctly, and that you have a listener running.

Brian

[Alex Ung]

I got this problem before.

In your tnsnames.ora file check that your ORACLE_SID db name setting is exactly the same as your database instance name. If you are using a non-Oracle business application together with the database then you should remove the ".WORLD" extension from the entry.

Also, your listener process *must* be up before you create, start up or shut down a database. Similarly all your databases should be shut down first before shutting off the listener.

HTH,
Alex