Oracle 9i problem [message #98748] |
Wed, 09 October 2002 01:37 |
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 |
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|N> 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 |
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 |
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 |
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
|
|
|