1752770 Members
4945 Online
108789 Solutions
New Discussion юеВ

install oracle

 
afshin
Occasional Contributor

install oracle

hi,
i have a problem with
./dbstart. i want to install oracle 9 under radhat. i install that but i can`t start the database oracle.
the error is:
SQL> ERROR:
ORA-12162: TNS:service name is incorrectly specified

SQL> ORA-12162: TNS:service name is incorrectly specified
SQL>
Database "" warm started.

Can't find init file for Database "clary".
Database "clary" NOT started.

How can I start the oracle? and how can i make connection from client to my oracle server?
Any suggestions anyone?

Regards,

Afshin
2 REPLIES 2
Michael Steele_2
Honored Contributor

Re: install oracle

Check your services file for TNS:

tns-server 3308/tcp TNS Server
tns-cml 590/tcp TNS CML
tns-cml 590/udp TNS CML

Here are some guidelines:

The Well Known Ports are those from 0 through 1023.

The Registered Ports are those from 1024 through 49151

The Dynamic and/or Private Ports are those from 49152 through 65535

Here are some guidelines from Red Hat about TNS service:

"...you need to make sure that the client has the appropriate entries for the datasource in question to your TNS service; generally a tnsnames.ora file..."

http://www.europe.redhat.com/documentation/HOWTO/Tango-HOWTO-6.php3

Regarding "...Can't find init file for Database "clary"..."

How is /etc/rc.d/init.d/oracle configured? Can you attach?
Support Fatherhood - Stop Family Law
afshin
Occasional Contributor

Re: install oracle

hi,

I can't find the configuration file but I saw it on the website of RedHat. and I copied the content of the script on it.

http://www.europe.redhat.com/documentation/HOWTO/Oracle-7-HOWTO-6.php3#ss6.1

Regards