« Oracle 11gで改善された統計収集における自動サンプリング機能
実行計画の表示と解析について »


3月

21

ORA-12547:TNS:lost contactが発生する

ここ数日、dbcaで最後の「完了」ボタンをクリックしスクリプトが作成された後に、以下のエラーが発生しデータベースが作成できず頭を悩ませていました。

ORA-12547:TNS:lost contact

使用環境
DB:Oracle 10g(10.2)
OS:CentOS4.6

最初はOUIでソフトウェアのインストールのみ行い、あとからdbcaでデータベースの作成をしようとして発生していたので、一旦、Oracleを削除してからソフトウェアのインストールとデータベースの作成を同時に行う方法でやり直してみるも結果は同じ。

エラーメッセージでググってみたところ、下記のページにヒントがありました。(一番下のエントリ参照)

これを見てピンと来ました。
“libaio-0.3.105-2.i386.rpm”って、OUIのパッケージチェックで「見つからない」と言われてたんですが、インストールマニュアルのソフトウェア要件に含まれてないんで、そのまま続行していたのでした。あの時、確認していれば・・・。

“libaio-0.3.105-2.i386.rpm”をyumでインストールしてdbcaを実行したところ、いつもエラーが出ていたところはすんなりクリア。
OEMのURLなんかも表示されて無事終了かと思いきや、またしてもエラーが。

OUI-25031: 一部のコンフィグレーション・アシスタントが失敗しました。

“/opt/app/oracle/product/10.2.0/db_1/cfgtoollogs/configToolFailedCommands”に失敗したコマンドが書かれているということなのでそちらを見てみると、

# Copyright (c) 1999, 2005, Oracle. All rights reserved.
/opt/app/oracle/product/10.2.0/db_1/bin/dbca   -customCreate
-createDatabase -templateName New_Database.dbt -gdbName orcl
-sid orcl -datafileJarLocation /opt/app/oracle/product/10.2.0/
db_1/assistants/dbca/templates -responseFile NO_VALUE
-obfuscatedPasswords false  -sampleSchema true -oratabLocation
/opt/app/oracle/product/10.2.0/db_1/install/oratab
-recoveryAreaDestination NO_VALUE

/opt/app/oracle/product/10.2.0/db_1/bin/isqlplusctl start

dbcaのパラメータが2箇所ほど”NO_VALUE”になっているのがアヤシイ。しかも”-gdbName”とか”-sid”に設定されている値が、画面で入力した値とちがうし。
問題を解決するには”configToolFailedCommands”のファイル名を”configToolFailedCommands.sh“に変更して実行する、とマニュアルのほうに書いてあるものの、このまま実行して成功するとは思えないので、dbcaを起動して一度データベースを削除してから、もう一度データベースを作成してみたところ、今度はエラーなしで作成できました。

16 Responses to “ORA-12547:TNS:lost contactが発生する”

  1. Added by wholesale nike air max on 10月 19th, 2013 at 17:55:46

    Great info. Lucky me I recently found your site by chance (stumbleupon).
    I’ve bookmarked it for later!

  2. Added by Calzoncillos Slip Calvin Klein on 1月 16th, 2014 at 21:08:18

    Hi, i read your blog from time to time and i own a
    similar one and i was just curious if you get a lot of spam feedback?
    If so how do you reduce it, any plugin or anything you can recommend?
    I get so much lately it’s driving me crazy so any help is
    very much appreciated.

  3. Added by Nike Free Run Trainer 3.0 on 2月 6th, 2014 at 13:23:41

    You have made some decent points there. I looked on the net for more information about the issue and found most individuals will go along with your
    views on this web site.

  4. Added by Nike AirMax Bw on 3月 5th, 2014 at 17:24:24

    Good day! I could have sworn I’ve visited your blog before
    but after looking at a few of the posts I realized it’s new to me.
    Anyways, I’m definitely delighted I discovered it and I’ll be
    book-marking it and checking back frequently!

  5. Added by sneakers Nike Air Max on 5月 3rd, 2014 at 14:44:03

    I am sure this paragraph has touched all the internet people, its really really good paragraph
    on building up new webpage.

  6. Added by dot Arena hack on 6月 4th, 2015 at 20:40:29

    Overall this mobile casino game disappoints a bit, when compared to what is promised, but with future updates should still be worth considering.

    There is a need to create extremely secure online gaming platforms, to protect
    users from the negative side of e-gaming. They lend the prospect to
    enjoy time with peers through using the same game.

  7. Added by http://www.ganharmassamuscular.net.br on 10月 27th, 2015 at 0:20:54

    Oi, adorei muito do seu website! gostei poiis o tema muito bem
    alinhado. Tenho um blog no mesmo tema e gostaria de ver se você tem alguma dica para quem está começando a
    escrever sobre esge tema. valeu!!

  8. Added by Video Enigma demo in action on 2月 1st, 2016 at 22:51:49

    Theree are so many things you can do with vide that makes it valuable So there you have it, eight reasons
    why yyou should start using video in your online business today.
    Should weeb designers be recommending video for all their clients.
    In business and market applications, creating a podcast program
    or advertisement can help dfaw visitors to a website, book or new products.

  9. Added by elektronik sigara ankara gimat on 6月 6th, 2016 at 5:28:52

    The Journal of Adolescent Health published a study conducted by L.
    E cigarettes are generally a response to help so many
    social difficulties ( space ) the actual non stop
    try to find meets long with lighters, burn off pckets inside top fronts, social rebukes, discolofed pearly white’s, smelly breath, smoker’s coughing,
    tarnished hands. A debatable drawback tto electronic cigaretges is the
    fact that a starter kit runs about $100.

    Feel ffree to visit my blog - elektronik sigara ankara gimat

  10. Added by gergedan on 7月 28th, 2016 at 15:02:20

    However, eve though dietary supplement proven safe and efficaccious to prevent the disease does not
    mean you caan avoid conventional medicine and only relying on regular food supplements.

    It can greatly reduce anxiety, help with insomnia,
    and relieve stress. The best veggetable sources of vitamin k2 aree thee
    leafy greens such as spinach, broccoli, cabbagbe
    and lettuce.

  11. Added by elektronik sigara bıraktırır mı on 9月 9th, 2016 at 1:54:32

    In the food industry, HCl is used for processing starch,
    glucose and protein. Secondly, when discussing health and safety, yyou have to take into account the health
    and safety of people who smoke traditional tobacco cigarettes.
    A debatable drawback to electronic cigarettes is the fact that a starter kit runs about $100.

    Here is mmy homepage :: elektronik sigara bıraktırır mı

  12. Added by gergedan tablet on 9月 14th, 2016 at 10:55:37

    When I look foor what supplements to take I have a feew points that
    I like to keep in mind. One of the most common supplements that people take to supplement their routine is simple protein powder.
    Other groups include those who have medical problems related to nutrient
    absorption.

  13. Added by gergedan sprey on 10月 5th, 2016 at 6:44:39

    Be sure and check out Mannatech’s two newest products in particular: Essential Source
    Omega-3 and Phyto - Burst. The both ingredients aare effective, safe andd easily absorbed because
    both are naturally occurring non-toxic biochemical constituents
    fund in connecting tissues. Almost all the ingredients
    included for the preplaration of herbal supplements have been used foor centuries for
    treating vivid reproductive disorders.

  14. Added by True CommissionBinary Secret SystemMake Over $4,000/Week OnlineMake Lots Of Money OnlineEasiest Way To Make Lots Of Cash OnlineMake Money Without Selling Anything OnlineMake Money Without A WebsiteWays To Make A Lot Of Money Without Having Your Own Websit on 4月 9th, 2017 at 11:26:36

    Good day very nice site!! Man .. Beautiful .. Wonderful ..
    I’ll bookmark your website and take the feeds additionally?

    I’m satisfied to seek out numerous helpful info here within the
    post, we want develop more techniques on this regard, thank you for sharing.
    . . . . .

  15. Added by Randy Lusher on 5月 2nd, 2017 at 22:28:58

    The things i have observed in terms of pc memory is that often there are specs such as SDRAM, DDR and many others, that must match the specifications of the motherboard. If the pc’s motherboard is rather current while there are no computer OS issues, replacing the memory literally takes under 1 hour. It’s one of the easiest personal computer upgrade processes one can visualize. Thanks for expressing your ideas.

  16. Added by Ami Billon on 5月 2nd, 2017 at 22:35:46

    Harika anlatmissiniz, ozellikle sigarayi birakmak isteyenler icin yol gosterici bir yazi olmus. Elektronik sigara da bu surecte yardimci olabilir.

Leave a Reply

Comment