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.
LVL 1
gyansAsked:
Who is Participating?
 
Richard OlutolaConnect With a Mentor ConsultantCommented:
I think virdi_ds is talking about the following line:

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

Notice the space between prodmachine and the closing bracket

Change it to the following:

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

Apparently this could cause a problem. I've never experienced this as I've entered my parameters perfectly :)

R.
0
 
gyansAuthor Commented:
Any reasons why this question has been neglected?
Would appreciate a response,thanks
0
 
Richard OlutolaConsultantCommented:
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.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
gyansAuthor Commented:
all I typed was cmctl start
and it gave me the error
thanks
0
 
Richard OlutolaConsultantCommented:
simply type cmctl (without the start)
0
 
Richard OlutolaConsultantCommented:
Try

cmctl startup

or

cmctl

Then

cmctl>startup

R.
0
 
gyansAuthor Commented:
will try and let you know thanks.
0
 
gyansAuthor Commented:
Hi,
its giving me the following error:
TNS-12535: TNS:operation timed out
Please help.
thanks
0
 
gyansAuthor Commented:
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 .
0
 
Richard OlutolaConsultantCommented:
You may be having firewall problems.

Have you tried tnsping to ensure traffic reaches the server?

R.
0
 
gyansAuthor Commented:
I can do a tnsping and sqlplus too.
Only when I try to start the connection manager it gives me the error.
thanks
0
 
Richard OlutolaConsultantCommented:
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.
0
 
gyansAuthor Commented:
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.
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
>> 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 ")"
0
 
gyansAuthor Commented:
In the cman.ora file there is no space between the host and prodmachine name.
thx
0
 
gyansAuthor Commented:
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
0
 
Richard OlutolaConsultantCommented:
What is the CONNECT_TIMEOUT value in listener.ora?

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

R.
0
 
gyansAuthor Commented:
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.
0
All Courses

From novice to tech pro — start learning today.