gyans
asked on
10g connection manager
Hi I have installed 10g base software and want to run connection manager.
I have creates a cman.ora file and trying to start the cmctl process and get the following error:
TNS-04010: Command cannot be issued before the ADMINISTER command.
Any clues what should I do next.
I have not set any rules in my cman.ora file.
I have creates a cman.ora file and trying to start the cmctl process and get the following error:
TNS-04010: Command cannot be issued before the ADMINISTER command.
Any clues what should I do next.
I have not set any rules in my cman.ora file.
What exactly did you type that gave the error?
It appears you're almost there but you may have taken a small wrong step.
R.
It appears you're almost there but you may have taken a small wrong step.
R.
ASKER
all I typed was cmctl start
and it gave me the error
thanks
and it gave me the error
thanks
simply type cmctl (without the start)
Try
cmctl startup
or
cmctl
Then
cmctl>startup
R.
cmctl startup
or
cmctl
Then
cmctl>startup
R.
ASKER
will try and let you know thanks.
ASKER
Hi,
its giving me the following error:
TNS-12535: TNS:operation timed out
Please help.
thanks
its giving me the following error:
TNS-12535: TNS:operation timed out
Please help.
thanks
ASKER
Hi,
I al really looking for help here.
I installed now 10g Net services on unix server.
Put in a entry in cman.ora and put it at /oracle/product/cman_home/ network/ad min
Not sure what else needs to be configured.
thanks in advance .
I al really looking for help here.
I installed now 10g Net services on unix server.
Put in a entry in cman.ora and put it at /oracle/product/cman_home/
Not sure what else needs to be configured.
thanks in advance .
You may be having firewall problems.
Have you tried tnsping to ensure traffic reaches the server?
R.
Have you tried tnsping to ensure traffic reaches the server?
R.
ASKER
I can do a tnsping and sqlplus too.
Only when I try to start the connection manager it gives me the error.
thanks
Only when I try to start the connection manager it gives me the error.
thanks
Show content of cman.ora
What is the CONNECT_TIMEOUT value in listener.ora?
Are you doing sqlplus/tnsping successfully from this same machine?
Any firewall rules between this machine and the server?
R.
What is the CONNECT_TIMEOUT value in listener.ora?
Are you doing sqlplus/tnsping successfully from this same machine?
Any firewall rules between this machine and the server?
R.
ASKER
Contents of cman.ora :
cmanprod = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HO ST=prodmac hine)(PORT =1630)(QUE UESIZE=32) )
)
cman_admin = (ADDRESS=(PROTOCOL=tcp)(HO ST=prodmac hine )(PORT=1830))
#
# cman's configurable params
#
# MAXIMUM_RELAYS defaults to 128
# LOG_LEVEL defaults to 0
# TRACING defaults to no
# TRACE_DIRECTORY defaults to .../network/trace
# RELAY_STATISTICS defaults to no
# SHOW_TNS_INFO defaults to no
# USE_ASYNC_CALL defaults to yes
# AUTHENTICATION_LEVEL defaults to 0
# MAXIMUM_CONNECT_DATA defaults to 1024
# ANSWER_TIMEOUT defaults to 0
# MAX_FREELIST_BUFFERS defaults to 2048
#
cman_profile = (parameter_list=
(MAXIMUM_RELAYS=1024)
(LOG_LEVEL=1)
(TRACING=no)
(RELAY_STATISTICS=yes)
(SHOW_TNS_INFO=yes)
(USE_ASYNC_CALL=yes)
(AUTHENTICATION_LEVEL=0)
(REMOTE_ADMIN=FALSE)
)
The database is on a different server called test machine and 10GOCM has been installed on a different server.
The cman.ora is from the test server machine.
Is there anything else we need to configure.
There are no firewall issues between the two servers.
I can tnsping from test server to database server.
thanks a lot for your help.
cmanprod = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HO
)
cman_admin = (ADDRESS=(PROTOCOL=tcp)(HO
#
# cman's configurable params
#
# MAXIMUM_RELAYS defaults to 128
# LOG_LEVEL defaults to 0
# TRACING defaults to no
# TRACE_DIRECTORY defaults to .../network/trace
# RELAY_STATISTICS defaults to no
# SHOW_TNS_INFO defaults to no
# USE_ASYNC_CALL defaults to yes
# AUTHENTICATION_LEVEL defaults to 0
# MAXIMUM_CONNECT_DATA defaults to 1024
# ANSWER_TIMEOUT defaults to 0
# MAX_FREELIST_BUFFERS defaults to 2048
#
cman_profile = (parameter_list=
(MAXIMUM_RELAYS=1024)
(LOG_LEVEL=1)
(TRACING=no)
(RELAY_STATISTICS=yes)
(SHOW_TNS_INFO=yes)
(USE_ASYNC_CALL=yes)
(AUTHENTICATION_LEVEL=0)
(REMOTE_ADMIN=FALSE)
)
The database is on a different server called test machine and 10GOCM has been installed on a different server.
The cman.ora is from the test server machine.
Is there anything else we need to configure.
There are no firewall issues between the two servers.
I can tnsping from test server to database server.
thanks a lot for your help.
>> cman_admin = (ADDRESS=(PROTOCOL=tcp)(HO ST=prodmac hine )(PORT=1830))
Can you remove extra space between "HOST=prodmachine )" and retry.
While working with Oracle XE, I got TNS related problem and that problem resolve after removing extra spaces beteen host_name and ")"
Can you remove extra space between "HOST=prodmachine )" and retry.
While working with Oracle XE, I got TNS related problem and that problem resolve after removing extra spaces beteen host_name and ")"
ASKER
In the cman.ora file there is no space between the host and prodmachine name.
thx
thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The space is only when I cut/paste the entry from my actual file to this forum and replace the hostname that the space is shown.
In the actual cman.ora file there is no space between the HOST=prodmachine and the closing bracket.
cmanprod = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HO ST=prodmac hine)(PORT =1630)(QUE UESIZE=32) )
)
cman_admin = (ADDRESS=(PROTOCOL=tcp)(HO ST=prodmac hine)(PORT =1830))
thats a typo only while while editing for posting the question in the forum.
My parameters do seem correct though:)
thanks
In the actual cman.ora file there is no space between the HOST=prodmachine and the closing bracket.
cmanprod = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HO
)
cman_admin = (ADDRESS=(PROTOCOL=tcp)(HO
thats a typo only while while editing for posting the question in the forum.
My parameters do seem correct though:)
thanks
What is the CONNECT_TIMEOUT value in listener.ora?
R.
R.
ASKER
This is on the database server -listener.ora file.
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
thx
STARTUP_WAIT_TIME_LISTENER
CONNECT_TIMEOUT_LISTENER = 10
thx
Increase it from the default 10 to something like 60 and try again.
R.
R.
ASKER
I found out the 10g OCM is very different from all the other lower versions and configuration requires listener.ora and init.ora file modifications.
ASKER
Would appreciate a response,thanks