Printable View
Hello friends,
RDBMS Version: 9.2.1.0
Operating System and Version: Windows 2000Pro
Error Number (if applicable): TNS 12571
I am Installing oracle 9i database release2 on windows 2k Professional and i m using preconfigured database it was installing perfectly but as soon as it start DBCA for creating database after 46% installation it is saying ORA-12571 : TNS : Packet writer failure.
Please suggest what should i do?
thanks
Abhishek
Hi,
During the installation , in NET8 CONFIGURATION ASSISTANCE step, it would have asked you for SERVICE NAME, HOST NAME, and once u give this info, it will ask you to connect to DB, the username and password you provided might not be correct.Please try this giving sys username and password and your installtion will work.
regards
anandkl
S/W install is done, only DB creation has probs.
Check if Alert.log/install_logs say any thing.
You usually get this error if you are connected to instance & instance goes down (due many reasons) & then you try to execute some
query/process or so.
Check if Pwd file is getting created.
Ya u r right ABHAYSK s/w is installed but problem with DBCA thats why it is unable to create DB .
Now tell me what are the othe ways to connect to SQL plus ? or do i have to create the database manually.
Abhi
Using DBCA, just save the DB creation script.
run the batch file generated, you will know where is the problem.
Hi Friends
still i am facing the same problem, i am trying to create manual database, after connecting to idle instance (sqlplus /nolog) when
i tried to connect as internal or sys i get the same packet failure error.
pls advise
Abhishek
Abhisek
Oracle 9i doesnot support svrmgr!
set Oracle_sid=
sqlplus /nolog
connect sys/sys as sysdba -- if this doesnot work then
connect sys/change_on_install as sysdba
connect sys/oracle as sysdba < if this too doesnot work then
connect system/manager
connected.
alter user sys identified by xxx;
connect sys/xxx as sysdba
then startup nomount pfile='.....'
create database command...
if you have any problems do let me know..
i can send you step by step installation document..
Sanjay
Hi friends
i have already mentioned that i am able to connect to idle instance (usine sqlplus /nolog) but after that i m unable to connect because it gives packet failure error, i have tried all the users suggested by sanjay then it gives
ora-03113 end of file on communication channel.
so i am still at the square?
please advise
Abhishek
Hi ofcourse i did all this things even i tried soln provided by oracle , and i am not using terminal server
i m using windows 2000 professional.
is there the problem with WIN2k pro or problem is something else
Pls advise what should i do?
Should I change my operating system to NT/Win2K(Server), Or should I wait for oracle assistance.
because i am in diehard situaion.
Abhishek
Can you breif me what all the steps you followed.
and also try send me a mail on sanjaygk at hotmail.com so that i can send you a step by step installtaion document both on solaris and windows 2000 professional.
don't worry you can create, i will help you
Hello!
Are all the oracle services running on the OS.
if not try to create the oracle service for which you want create the database manually using ORADIM
then set oracle_sid=sid_name
sqlplus /nolog
connect sys/change_on_install@sid_name as sysdba
try this option..
still you have any problems post your email address i will send you the document how to install the oracle on w2k..
please mention your hardware configuration..
oracle recomends min 256 MB ram for 9i..
Hello Friends
i have no choice except changing the operating system to NT ot 2000 Server. I di not get any soln from either from dba click forum or dba support or even from oracle support.
but any way guys you all doing a good job, so keep doing that.
best of luck
Abhishek
Jus for TNS packet writer failure, you wana change OS? -- thas crazy
What's that it gotta do with your error?
Well now coming to your quote
You aint providing enough info & you expect help, how do we know where your goin worng...Quote:
I di not get any soln from either from dba click forum or dba support or even from oracle support.
Jus post what ever you did till you gotta this error, then you can expect help...
Abhay.
Hi Abhayk
thanks for your concern.
i am still alive and still fighing . s/w is installed but as soon as you start DBCA after compleing 46% installation it says packet failure error
oracle told me go to /program file/oracle/inventory/locks/writer.lock then delete the file writer0.lock.
but the problem is when i check in the locks directory at the time of installation the directory was writer0.lock was there , but as soon as S/w installation done it convert to reader0.lock.
then oracle told me to delete reader0.lock .
i did that.
then i tried manual database creation i am still able to connect to idle instace but after when you try to connect as sysdba it gives error again.i ahve checked every thing (password file also) is there.
pls advice
Abhishek
Can you copy and paste the outputs here for the following.
1. The errors thats thrown when you run the scripts manually.
2. The entries in alertlog files. (ORACLE_BASE/admin/sid/bdump)
3. The entries in the trace files. (ORACLE_BASE/admin/sid/udump)
Have you created the Oracle Services before manually running the database creation script and did you set ORACLE_SID on the command prompt.
Also can you paste your dbca scripts.