OraFAQ Forum: Windows » After 2 days I'm fed up and need help thank you !

Home » Infrastructure » Windows » After 2 days I'm fed up and need help thank you !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

After 2 days I'm fed up and need help thank you ! [message #112311]

Thu, 24 March 2005 06:17

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

Hi,
Environement :
- Windows 2K 5.002195 /Oracle 8.1.7.1.0
- Install in the good user mode (install)
- ping telnet ipadress:1521 => answer Ok
- Installation and patching Ok
- Network configuration via Net8 Ok
(lsnrctl status Ok, tnsping Test Ok)
- Créating database file via dba studio failed !
- Same player shoot again but with backup files script failed again
- Destroying service for the aborted database and reboot
- lsnrctl status => Ok (no handler)
- Positionning de ORACLE_SID in environement variable with the value of my SID (TEST)
- Verify by "set" in a DOS box => Ok
- executing oradim command take from the .bat file => Ok
- service is created in service table Ok
- lsnrctl and tnsping ok again Razz

- svrmgrl failed ! TNS-12560 TNS adaptator error
- Activation of trace, mode Support . Nothing explicit
- suciding ?
Thank you for your help . I can send the listener.trc

B.R.

Merydine

Attachment: listener.trc
(Size: 34.77KB, Downloaded 1825 times)

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112349 is a reply to message #112311]

Thu, 24 March 2005 10:18

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

I forget,

I 've just test installation directly on computer because TSE may be a pb. Same result !!! Evil or Very Mad

Thank you for all of 17 people who 're message.
Any one has an idea ?

Thank you.

B.R.

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112350 is a reply to message #112311]

Thu, 24 March 2005 10:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Créating database file via dba studio failed !
You must be creating a database using dbca.
NOt dbastudio.
tnsping will check the status of listener only NOT the database.

>>svrmgrl failed ! TNS-12560 TNS adaptator error
check your sqlnet.ora
comment all entries.
try again

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112417 is a reply to message #112350]

Fri, 25 March 2005 01:50

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

Thank you,

Yes I've used DBCA because it failed with DBA Studio.
The pbs seems to be at a low level .
In a DOS box I set ORACLE_SID to TEST (declaration is made correctly in different files under ($ORACLE_HOME/network/ADMIN))
The oradim command is Ok
When I start listener, it answer Ok
When I tnsping TEST it answer Ok
When I start svrmgrl it failed with a TNS-12560 protocol error

I can 't connect internal to create database.

I've comment all lines in sqlnet.ora except NAMED_DIRECTORY_PATH
line failed too Sad

I've move the sqlnet.ora in .txt same result.

Do you see something interesting in trace file I've sent ?

Thank you.

Merydine

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112426 is a reply to message #112417]

Fri, 25 March 2005 05:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I said ,
COMMENT all entries in sqlnet.ora.
Did you create the database sucessfully using DBCA?

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112428 is a reply to message #112426]

Fri, 25 March 2005 05:41

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

Hi,

I've comment without success.
No, I can't create because when I start the svrmgrl prg I obtain the TNS-12560 message.
Strange because the oradim had work without error.

B.R.

Merydine

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112429 is a reply to message #112428]

Fri, 25 March 2005 05:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first create the database with DBCA.
then use oradim to create services for the database instance you have created.

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112433 is a reply to message #112428]

Fri, 25 March 2005 06:11

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

merydine wrote on Fri, 25 March 2005 08:41

Hi,

I've comment without success.
No, I can't create because when I start the svrmgrl prg I obtain the TNS-12560 message.
Strange because the oradim had work without error.
Now, I run namesctl command to go down.
Interesting, because when I set server, the service name and the host give the same name. It explain it can't run. Know, howto solve ?
B.R.

Merydine

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112495 is a reply to message #112433]

Fri, 25 March 2005 23:12

malikian
Messages: 6
Registered: March 2005

Junior Member

Try this;
1. open a CMD
2. set oarcle_sid=test
3. sqlplus /nolog
connect internal

Now you should be connected and could create your database...

Let me know how you get on.
Robert

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #112735 is a reply to message #112495]

Tue, 29 March 2005 00:34

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

Hi Robert,

I've tried :

sqlplus /nolog Ok
connect internal => ORA-24314 bad service descriptor

Do you know how to activate listener trace ?
Thank you.

Regards
Merydine.

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #113014 is a reply to message #112311]

Wed, 30 March 2005 10:01

TLegend33
Messages: 203
Registered: March 2005

Senior Member

At the command prompt:
>lsnrctl stat
is your database listed as having a service handler?
If not, add it using the Net8 Assistant. Select Listener, then database services from drop-down menu, enter in your database information...then cycle your listener.

also, try this if you haven't already:
set oracle_sid=test
svrmgrl
connect internal/<password you selected when creating service with oradim>@test

Report message to a moderator

Re: After 2 days I'm fed up and need help thank you ! [message #113180 is a reply to message #113014]

Thu, 31 March 2005 07:21

merydine
Messages: 7
Registered: March 2005
Location: France

Junior Member

Thank you for your help.
It seems that when we want to use oradim it create service but not user.
I close this folder because we had reinstalled the machine with Linux RedHat and it work fine !!! Laughing

B.Regards

Report message to a moderator

Previous Topic:	oracle9i odbc help
Next Topic:	Io exception: The Network Adapter could not establish the connection : Installation error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 03:39:03 CST 2024