Home » Infrastructure » Windows » oracle sqlplus error ora-24324 and ora-01041?
oracle sqlplus error ora-24324 and ora-01041? [message #100752] Fri, 01 August 2003 01:19 Go to next message
eagletian
Messages: 1
Registered: August 2003
Junior Member
when I run following statement in sqlplus:
sql>startupp file=c:oracleadmintixipipfile
inittixipi.ora.6312003235543
These error occur:
ora-24324: service handle not initialized
ora-01041: internal error. hostdef extension doesn't exist

what can i do?
Re: oracle sqlplus error ora-24324 and ora-01041? [message #100755 is a reply to message #100752] Fri, 01 August 2003 06:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your database is not started.
first start the database and listeners(if any).
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101173 is a reply to message #100755] Thu, 03 June 2004 03:56 Go to previous messageGo to next message
Patrick David
Messages: 1
Registered: June 2004
Junior Member
Hi Mahesh,

It seems that I have the same problem as yours. I'm using Oracle 9i R2, 9204, and when I start my database using the same command "startup pfile=...", I get the same errors. But no any ideas on how fix it.

Did you find a solution? If so could you tell me how to do?

Thanks in advance

Patrick
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101274 is a reply to message #101173] Fri, 16 July 2004 01:36 Go to previous messageGo to next message
Michael
Messages: 61
Registered: October 1999
Member
maybe some directory you haven't create
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101318 is a reply to message #101274] Wed, 04 August 2004 06:08 Go to previous messageGo to next message
Loïc
Messages: 2
Registered: August 2004
Junior Member
looks like these error messages don't mean anything at all.

log in as root and execute command "ipcs". should you see ipcs owned by the oracle user, delete them using the "ipcrm" command, and everything will work fine again.
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101360 is a reply to message #100752] Thu, 26 August 2004 22:13 Go to previous messageGo to next message
Ravi Kumar .C
Messages: 1
Registered: August 2004
Junior Member
The problem is that the oracle is unable to create the background process,You should check whether the path specified for all backround process are correct and create folders if not. Then reload the listener
and issue the command again in a new session.

Rgds
C.Ravi Kumar
DBA
INDIA
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101458 is a reply to message #101360] Fri, 08 October 2004 22:59 Go to previous messageGo to next message
pallavi
Messages: 14
Registered: April 2001
Junior Member
Hi ravi
i m not able to startup
pls expalin in detail wht i do.
i m frsher in DBA activity.
Thanks
pallavi
Re: oracle sqlplus error ora-24324 and ora-01041? [message #101675 is a reply to message #101458] Thu, 17 February 2005 11:50 Go to previous messageGo to next message
longani
Messages: 1
Registered: February 2005
Junior Member
for i in `ipcs|grep oracle|awk '{print $2}'`

> do

> ipcrm shm $i

> done
Re: oracle sqlplus error ora-24324 and ora-01041? [message #329694 is a reply to message #100752] Thu, 26 June 2008 04:54 Go to previous messageGo to next message
sunildasar
Messages: 1
Registered: June 2008
Location: Bangalore
Junior Member


Hi,
Even I faced the following issue.The issue can be solved in the following way

When you are creating Spfile form pfile,give the full path of the pfile that U have modified

create spfile from pfile='<pfile-location>'

and then Start the Database

This should resolve the issue

The reason for the issue might be because the pfile is not present in the default directory
i.e ORACLEHOME\database for Windows and ORACLEHOME/dbs for Linux/Solaris

So When you are creating spfile U need to provide the full location for the pfile

Hope this helps U resolve the issue.Please let me know if U need any help regarding this


Re: oracle sqlplus error ora-24324 and ora-01041? [message #329776 is a reply to message #100752] Thu, 26 June 2008 08:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Responding to a 3+ year old post is a waste of electrons & typing!
Re: oracle sqlplus error ora-24324 and ora-01041? [message #335094 is a reply to message #329776] Mon, 21 July 2008 00:15 Go to previous message
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
Member

I also got the problem ORA-24324 and understood that we are using Authentication server.ini where connection string is given like:
DB_CONN_STRING=teskhi/testkhi@testdb
PORT=8123
ENCRYPT=NO

LOG_FILE_NAME=Log/AuthenticationServer
LOG_FILE_SIZE=4194304
NO_OF_LOG_FILES=2
The application is routed through a file:
HOST_NAME=191.1.16.247:7123
WEB_BASED=NO
PRODUCT_ONLY=YES
MARGIN_INTERVAL=30
ENCRYPT=NO
This hostname is my client machine where all users are using the application. This hostname was given the server ip. When I changed that ip with 247, the problem resolved.
Previous Topic: Cannot access Oracle 9 Database after Oracle 10 Client is installed
Next Topic: spool file to file with the date as suffix
Goto Forum:
  


Current Time: Thu Mar 28 10:26:27 CDT 2024