Home » Infrastructure » Linux » Oracle 9i problem
Oracle 9i problem [message #98748] Wed, 09 October 2002 01:37 Go to next message
Priya Gopal
Messages: 2
Registered: October 2002
Junior Member
I have redhat Advanced server in which i have installed oracle 9i. When I do dbshut or dbstart, it is giving me the following error message :

SQL*Plus: Release 9.0.1.0.0 - Production on Wed Oct 9 15:00:50 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-24314: service handle not initialized

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

Also, when I try to connect to my server using my W2K client, in which I have installed the oracle 8i client version, I am not able to configure NET8. I have a proxy IP. But in cases of system having a real IP, even with the above error in the server, I am able to connect to the server thru sqlplus.

Please help me and guide me as to what I can do.
Re: Oracle 9i problem [message #98770 is a reply to message #98748] Mon, 09 December 2002 14:42 Go to previous messageGo to next message
vgundala
Messages: 1
Registered: December 2002
Junior Member
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Oct 9 15:00:50 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-24314: service handle not initialized

SQL> ORA-12162: TNS:service name is incorrectly specified
SQL>
Database "" warm started.
--Hi,
--Please check your oratab file at /etc/oratab.
--ORACLE_SID:ORACLE_HOME:<Y&#124N> must be specified.
--set ORACLE_SID in environmental variables. If you --have * in place of ORACLE_SID, then change it to --whatever ORACLE_SID you would like to have. Finally --it should be ORACLE_SID:ORACLE_HOME:Y
--and it should be out of comments.
--Hope this helps
--Vinay.
Re: Oracle 9i problem [message #99072 is a reply to message #98770] Thu, 20 May 2004 19:49 Go to previous messageGo to next message
A. Durgaram
Messages: 1
Registered: May 2004
Junior Member
Hi,

I read your suggestion after chaning that oratab file for setting the sid to TSH1

then it gave the error like this

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

what shall i do next? Pl help me
Re: Oracle 9i problem [message #99123 is a reply to message #99072] Mon, 16 August 2004 09:54 Go to previous messageGo to next message
Jason Kirby
Messages: 1
Registered: August 2004
Junior Member
I believe when the product installed, it should have
created the file, /u01/app/oracle/product/9.2.0.1.0/dbs/init.ora as /u01/...../dbs/initTSH1.ora, but did not.

Follow the /etc/dbora script to $ORACLE_HOME/bin/dbstart and see the variable PFILE needs to be set to ../dbs/init${ORACLE_SID}.ora and ORACLE_SID comes directly from the TSH1 entry int the /etc/oratab file.

I issued the name change and it started fine on reboot after that.

I suppose you have gotten yours fixed by now but I just encountered this problem this week, did not find a solution on the web, and wanted to post this solution so that anyone else can fix it fast.
ORA-12162: TNS:service name is incorrectly specified [message #343823 is a reply to message #98748] Thu, 28 August 2008 05:14 Go to previous message
yeapmadhu
Messages: 2
Registered: August 2008
Junior Member


Hai

1) Open Terminal
2) Go to Oracle Home path eg: /home/dsdsd/oracle/product/10.2.0/db_2/bin
3) Type ./dbca
4) now One UI Screen(Database Configuration Assistance Opens) . Follow the Instructions given in that Screen
5) If u Not Already Created Database , create the Database And Finally Click the Finish
6) Now u try . . Username ; SYS, SYSMAN

Still any doubts mail me to yeapmadhu@gmail.com
regards
Madhu
Previous Topic: Oracle VM Manager Installation Problems
Next Topic: starting problem : ORA-24314 & ORA-12162
Goto Forum:
  


Current Time: Fri Mar 29 07:34:17 CDT 2024