OracleStartORCL could not find specified path

[edgarv]

HELP PLEASE!!!!!!!

I know nothing about Oracle, this is in an OLD NT 4.0 server.
Let me explain the senario. We had our main server go down, had to rebuild the domain from scratch, we have an old ERP system still installed in what used to be a BDC, everything was working well. I had to demote the BDC to join the new domain and now I users cannot connect to the old erp ( they only use this as a reference, and I know, I know that is bad practice but... very long story)
Anyhow I get an OracleStartORCL Could not find specified path my TNSNAMES.ORA looks like this

#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your SQL*Net Easy Configuration may not function properly.

Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Beq-Local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
DAVIES.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.1.1.254)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.1.1.254)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

Help Please!!

thank you

 

[SantaMufasa]

Ed,

Since OracleStartORCL is throwing this error, tnsnames.ora is causing your problem. The "...Could not find specified path..." usually results from the service not being able to locate a path which you reference in your init<SID>.ora file. Look at all of your init<SID>.ora entries that specify files or paths (example: background_dump_dest, user_dump_dest, et cetera) and using Windows Explorer (for example) ensure that the paths all pre-exist.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[edgarv]

thank you Mufasa, I got it. You were right. All I did was to find the right path and voila.

appreciate it.

 

[SantaMufasa]

Ed (and anyone else reading this thread)...I am so sorry for not carefully re-reading my post before hitting the [Submit] button: My Post erroneously said:

Since OracleStartORCL is throwing this error, tnsnames.ora is causing your problem.

I guarantee that, in my head, I used the word not, but my fingers didn't hear my head.. My assertion should have read:

Since OracleStartORCL is throwing this error, tnsnames.ora is NOT causing your problem.

. Sorry for the oversight and I hope this didn't cause anyone any inconvenience.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.