General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8..1.7 creating a database from clean install

exrational
Occasional Advisor

Oracle 8..1.7 creating a database from clean install

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
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: Oracle 8..1.7 creating a database from clean install

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Cheryl Griffin
Honored Contributor

Re: Oracle 8..1.7 creating a database from clean install

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
"Downtime is a Crime."
Steven E. Protter
Exalted Contributor

Re: Oracle 8..1.7 creating a database from clean install

 
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Oracle 8..1.7 creating a database from clean install

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
Occasional Visitor

Re: Oracle 8..1.7 creating a database from clean install

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