zzhang2006
asked on
Oracle 10g server installed on XP, sometimes down and sometime up ..
I installed the 10g v2 server on a laptop, just to learn the concepts related to Oracle systems.
I know it's too big a task to run for tha labtop, however it seem "working". I mean from the interprice manager I saw everthing is up and was able to use iSQLPlus as well as SQL*PLUS in both remote and local clients.
But it seems not stable or some configuration to be done or there should be a sequence of booting the service/listener processes. The sympton is: half of the time sthe system shows up in the EM as "Database instance is down" and "the Agent cannot connect to the instance, because it "currently" does not know the SID " Here is the exact copy from EM
Agent Connection to Instance
Status Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
However the listern on port 1521 is up:
Listener
Status Up
Host SCIMAT11
Port 1521
Name LISTENER
Oracle Home C:\oracle\product\10.2.0\d b_1
Location C:\oracle\product\10.2.0\d b_1\networ k\admin
I don't really have an clear idea of which service is responsible for which listerners and agents, but I do see there are serveral Oracle named services started automatically in Windows XP. Is the Agent, the TNS Listener,actually listening on the port 1521? I would really appreciated some expert give me a quick drawing about the server/listerner/Agent architecture of Oracle and the sequence/logic they should boot up and their dependences, even if you can provide a quick answer to my problem.
Thanks in advance.
Ze
I know it's too big a task to run for tha labtop, however it seem "working". I mean from the interprice manager I saw everthing is up and was able to use iSQLPlus as well as SQL*PLUS in both remote and local clients.
But it seems not stable or some configuration to be done or there should be a sequence of booting the service/listener processes. The sympton is: half of the time sthe system shows up in the EM as "Database instance is down" and "the Agent cannot connect to the instance, because it "currently" does not know the SID " Here is the exact copy from EM
Agent Connection to Instance
Status Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
However the listern on port 1521 is up:
Listener
Status Up
Host SCIMAT11
Port 1521
Name LISTENER
Oracle Home C:\oracle\product\10.2.0\d
Location C:\oracle\product\10.2.0\d
I don't really have an clear idea of which service is responsible for which listerners and agents, but I do see there are serveral Oracle named services started automatically in Windows XP. Is the Agent, the TNS Listener,actually listening on the port 1521? I would really appreciated some expert give me a quick drawing about the server/listerner/Agent architecture of Oracle and the sequence/logic they should boot up and their dependences, even if you can provide a quick answer to my problem.
Thanks in advance.
Ze
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I got it working!