Home » Infrastructure » Windows » After 2 days I'm fed up and need help thank you !
After 2 days I'm fed up and need help thank you ! [message #112311] Thu, 24 March 2005 06:17 Go to next message
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 528 times)
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10704
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10704
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10704
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.
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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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
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 Go to previous message
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 Laughing Laughing


B.Regards
Previous Topic: oracle9i odbc help
Next Topic: Io exception: The Network Adapter could not establish the connection : Installation error
Goto Forum:
  


Current Time: Mon Aug 15 08:06:17 CDT 2022