initializing oracle 8.1.7 ; control.sql

[Former Member]

im trying to re-initialize oracle 8.1.7 and run @control.qsl

i made:

sqlplus /nologs

connect /as sysdba

its comes error:

ERROR: ORA-12560: TNS: protocol adapter error

then i tried: connect internal@crd //it is a perfect way for start??

msg: Connected to an idle instance

// i want to load CONTROL FILE, the path is correct

then i put: @control.sql

error:

ERROR: ORA-12560: TNS: protocol adapter error

SPA-0640: Not Connected

how can I resolve this and then load the system.

thanks

regards

pheno

[Former Member · Accepted solution]

Hi,

check Note 441518 - ORA-12560 composite SAP Note

Note 384839 - ora-12540, tns-12560, tns-12500, tns-12546

regards,

kaushal

[Former Member · Accepted solution]

still not working.

i did tnsping, and its ok.

the problem i think the database is down.

and i did sqlplus /nologs

conn user/password@CRD.World

and its comes ORA-1034: Oracle not available

and ORA-27101: shared momenry realms do not exist

how can i make it up?

i went to foruns and stuffs but i dont find anything help it..

any1 can help me?

thnaks

[Former Member · Accepted solution]

HI Pheno,

Please try restart your server and try again.

Some time its help to clean the share memory.

And if its running on windows, please check the service is running.

Regard,

Fendi

[Former Member]

Is it a duplicate thread with the other one called "initializing oracle" ?

Stéphan