Tagged Questions

-1
votes
0answers
28 views

Oracle Connection Manager cman.ora startup

I can't startup the cman.ora file Here is the file cman.ora contents CMAN_Saf1-PC = (CONFIGURATION= (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.0.206)(PORT=1821) ) (parameter_list = ...
0
votes
0answers
65 views

Oracle Connection Manager Configuration [closed]

I've a problem with Oracle Connection Manager and I've read the Oracle topic about it at OCM but it doesn't work well An image Inside Diagram describes the diagram I want to configure The IP for ...
0
votes
2answers
58 views

Oracle database uses wrong parameter file

When I try to startup my Oracle database I get the following error: LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora' The /dbs directory in my ...
2
votes
1answer
282 views

Oracle: Long delay opening connections

I am getting a very long delay (about 2 minutes) opening initial connections on my 11g2 development server. Sometimes I get ORA-28547: connection to server failed, probable Oracle Net admin error and ...
0
votes
2answers
1k views

sqlnet.ora or tnsnames.ora changes require reboot?

Anytime you change Oracle's sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of ...
1
vote
1answer
3k views

Oracle DBCA utility: “Listener is not up or database service is not registered with it”

I'm a software engineer with some experience on SQL Server but a newbie on Oracle. I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
3
votes
2answers
887 views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...
1
vote
1answer
252 views

Oracle change initialization parameter with “deferred” keyword

The description of deferred and scope keyword is listed below (extracted from Oracle documentation). The meaning of them gives me an indication that deferred can just use the memory scope. Is my ...
2
votes
1answer
1k views

How do I create a database+tablespace+user in Oracle 11gR2?

Good evening, I'm trying to figure out how to create a database+tablespace+user in Oracle 11g. I've tried some tutorials, but nothing seems to work. I cannot find Database Configuration Assistant ...