Link to home
Start Free TrialLog in
Avatar of gyans
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.
Avatar of gyans
gyans

ASKER

Any reasons why this question has been neglected?
Would appreciate a response,thanks
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.
Avatar of gyans

ASKER

all I typed was cmctl start
and it gave me the error
thanks
simply type cmctl (without the start)
Try

cmctl startup

or

cmctl

Then

cmctl>startup

R.
Avatar of gyans

ASKER

will try and let you know thanks.
Avatar of gyans

ASKER

Hi,
its giving me the following error:
TNS-12535: TNS:operation timed out
Please help.
thanks
Avatar of gyans

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/admin
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.
Avatar of gyans

ASKER

I can do a tnsping and sqlplus too.
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.
Avatar of gyans

ASKER

Contents of cman.ora :
cmanprod = (ADDRESS_LIST=
           (ADDRESS=(PROTOCOL=tcp)(HOST=prodmachine)(PORT=1630)(QUEUESIZE=32))
       )

cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=prodmachine )(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.
>> cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=prodmachine )(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 ")"
Avatar of gyans

ASKER

In the cman.ora file there is no space between the host and prodmachine name.
thx
ASKER CERTIFIED SOLUTION
Avatar of Rich Olu
Rich Olu
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gyans

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)(HOST=prodmachine)(PORT=1630)(QUEUESIZE=32))
       )

cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=prodmachine)(PORT=1830))

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.
Avatar of gyans

ASKER

This is on the database server -listener.ora file.
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
thx
Increase it from the default 10 to something like 60 and try again.

R.
Avatar of gyans

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.