Expandmenu Shrunk


Oracle不能正常连接处理

[oracle@MSPDBServer ~]$ export ORACLE_SID=MSP
[oracle@MSPDBServer ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Mon Nov 14 16:30:16 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL>
环境变量正确,但是登陆不入数据库

 

[oracle@MSPDBServer ~]$ ps -ef|  grep oracle | grep -v LOCAL=NO
oracle    3957 30080  0 May23 ?        03:05:20 /home/oracle/product/10.2.0/MSP/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/home/oracle/product/10.2.0/MSP -Doracle.home=/home/oracle/product/10.2.0/MSP/oc4j -Doracle.oc4j.localhome=/home/oracle/product/10.2.0/MSP/MSPDBServer_MSP/sysman -DEMSTATE=/home/oracle/product/10.2.0/MSP/MSPDBServer_MSP -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/home/oracle/product/10.2.0/MSP/oc4j/j2ee/OC4J_DBConsole_MSPDBServer_MSP/config/jazn.xml -Djava.security.policy=/home/oracle/product/10.2.0/MSP/oc4j/j2ee/OC4J_DBConsole_MSPDBServer_MSP/config/java2.policy -Djava.security.properties=/home/oracle/product/10.2.0/MSP/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/home/oracle/product/10.2.0/MSP/MSPDBServer_MSP -Dsysman.md5password=true -Drepapi.oracle.home=/home/oracle/product/10.2.0/MSP -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /home/oracle/product/10.2.0/MSP/oc4j/j2ee/home/oc4j.jar -config /home/oracle/product/10.2.0/MSP/oc4j/j2ee/OC4J_DBConsole_MSPDBServer_MSP/config/server.xml
root     10548 10503  0 14:23 pts/1    00:00:00 su – oracle
oracle   10549 10548  0 14:23 pts/1    00:00:00 -bash
oracle   10647 30080  0  2010 ?        13:12:10 /home/oracle/product/10.2.0/MSP/bin/emagent
root     12347 12020  0 15:37 pts/3    00:00:00 su – oracle
oracle   12348 12347  0 15:37 pts/3    00:00:00 -bash
root     13222 12748  0 16:04 pts/5    00:00:00 su – oracle
oracle   13223 13222  0 16:04 pts/5    00:00:00 -bash
oracle   13743     1  0 16:17 ?        00:00:00 /usr/libexec/gconfd-2 13
root     13810 27852  0 16:18 ?        00:00:00 sshd: oracle [priv]
oracle   13821 13810  0 16:18 ?        00:00:04 sshd: oracle@notty
oracle   13822 13821  0 16:18 ?        00:00:00 /usr/bin/gnome-session –display localhost:11.0
oracle   13850     1  0 16:18 ?        00:00:00 /usr/bin/gnome-keyring-daemon
oracle   13852     1  0 16:18 ?        00:00:00 /usr/libexec/bonobo-activation-server –ac-activate –ior-output-fd=19
oracle   13858     1  0 16:18 ?        00:00:00 /usr/libexec/gnome-settings-daemon –oaf-activate-iid=OAFIID:GNOME_SettingsDaemon –oaf-ior-fd=23
oracle   13862     1  0 16:18 ?        00:00:00 /usr/libexec/gam_server
oracle   13879     1  0 16:18 ?        00:00:00 gnome-panel –sm-client-id default2
oracle   13881     1  0 16:18 ?        00:00:00 nautilus –no-default-window –sm-client-id default3
oracle   13883     1  0 16:18 ?        00:00:00 gnome-volume-manager –sm-client-id default6
oracle   13890     1  0 16:18 ?        00:00:00 /usr/libexec/gnome-vfs-daemon –oaf-activate-iid=OAFIID:GNOME_VFS_Daemon_Factory –oaf-ior-fd=29
oracle   13897     1  0 16:18 ?        00:00:00 /usr/libexec/mapping-daemon
root     13906 27852  0 16:19 ?        00:00:00 sshd: oracle [priv]
oracle   13909 13906  0 16:19 ?        00:00:00 sshd: oracle@pts/4
oracle   13910 13909  0 16:19 pts/4    00:00:00 -bash
oracle   14025     1  0 16:20 ?        00:00:00 pam-panel-icon –sm-client-id default0
oracle   14027     1  0 16:20 ?        00:00:01 /usr/bin/python /usr/bin/rhn-applet-gui –sm-client-id default4
oracle   14208 26556  0 16:27 ?        00:00:00 sleep 59
oracle   14216 12348  0 16:28 pts/3    00:00:00 ps -ef
oracle   14217 12348  0 16:28 pts/3    00:00:00 grep oracle
oracle   15937     1  0 Oct14 ?        00:01:11 ora_q001_MSP
oracle   22109     1  6 Oct13 ?        2-00:09:02 ora_j000_MSP
oracle   22517     1  6 Oct13 ?        1-23:54:55 ora_j001_MSP
oracle   22519     1  5 Oct13 ?        1-21:47:05 ora_j002_MSP
oracle   22521     1  5 Oct13 ?        1-20:09:08 ora_j003_MSP
oracle   22523     1  6 Oct13 ?        1-23:29:54 ora_j004_MSP
oracle   22581     1  5 Oct13 ?        1-21:11:45 ora_j005_MSP
oracle   22583     1  5 Oct13 ?        1-22:23:23 ora_j006_MSP
oracle   22585     1  6 Oct13 ?        1-23:28:49 ora_j007_MSP
oracle   22587     1  6 Oct13 ?        1-23:18:27 ora_j008_MSP
oracle   22589     1  6 Oct13 ?        2-00:32:12 ora_j009_MSP
oracle   26556     1  0 Sep05 ?        00:03:26 /bin/ksh ./jgetvmstat.sh
oracle   29339     1  0  2010 ?        00:40:32 /home/oracle//product/10.2.0/MSP//bin/tnslsnr LISTENER -inherit
注意监监听目录多了个//

因此链接不了,环境变量故障
SQL> select instance_name,to_char(startup_time,’yyyy-mm-dd hh24:mi:ss’) from v$instance;

INSTANCE_NAME    TO_CHAR(STARTUP_TIM
—————- ——————-
MSP              2010-12-24 11:13:32

 

 

[oracle@MSPDBServer /]$ ps -eo pid,tty,user,comm,stime,etime,stat,cmd,comm,command | grep lsn
15292 pts/3    oracle   grep             17:06       00:00 S+   grep lsn         grep             grep lsn
29339 ?        oracle   tnslsnr           2010 325-14:27:29 Ssl /home/oracle//pr tnslsnr          /home/oracle//product/10.2.0/MSP//bin/tnslsnr LISTENER -inh

时间是2010 第325天的14:27:29秒
2010-11月21号

比实例早启动

 

 

 

 

 
To see every process on the system using standard syntax:
   ps -e
   ps -ef
   ps -eF
   ps -ely

To see every process on the system using BSD syntax:
   ps ax
   ps axu

To print a process tree:
   ps -ejH
   ps axjf

To get info about threads:
   ps -eLf
   ps axms

To get security info:
   ps -eo euser,ruser,suser,fuser,f,comm,label
   ps axZ
   ps -eM

To see every process except those running as root (real & effective ID)
   ps -U root -u root -N

To see every process with a user-defined format:
   ps -eo pid,tid,class,rtprio,ni,pri,psr,pcpu,stat,wchan:14,comm
   ps axo stat,euid,ruid,tty,tpgid,sess,pgrp,ppid,pid,pcpu,comm
   ps -eopid,tt,user,fname,tmout,f,wchan

 

 

 


141 Responses to Oracle不能正常连接处理

  1. In the end, their particular goals and also involves. And even be sure you secure one thing great it is really. Additionally, you need to try numerous suppliers if you want to acquire distinctive services beneath it a single top..

  2. This individual worries gossip connected with KJQ’s probable formatting adjust typically are not the case. KSRR’s longawaited transmitter last but not least guides your stop inside of being attentive collection of Sodium Lk Nation. Marine corps.

  3. Almost all CLA in your body will be associated with nutritionary foundation, bought typically because of milk plus meats merchandise. Nonetheless, as a result of present day producing options, food items developing plus present day diet plan, plus the volume of CLA we’re able to get hold of because of food items is definitely minimal. Tea leaf: almost all green teas are actually created from precisely the same flower, Camellia Sinensis.

  4. One other practical mayoral challenger that has a wellknown file is certainly ex – councilmember Spork Nofziger. The info for this ethnic background as the grassroots prospect trying pertaining to plan financial change has become very helpful. Yet that will difficulty seriously isn’t ample.

  5. Just ghat my initially %anchor% Triple bailey button,brown shade..I really like them would like to acquire a lot more :-)))))))))

  6. Using the wireless computer, if I click on on “view workgroup computers” I’m able to see every one of the computer systems but cannot access them. Using the two wired computer systems, I constantly get the message, “MSHOME just isn’t obtainable,” and so forth. Humorous factor is, the network implemented to work.
    Canada Goose Facts http://www.darcvhal.com/canada-goose-facts
    Canada Goose Facts

  7. When my hair was completed, it had been more than to Bobbi Brown, where the lovely Terry produced me up completely. I asked for organic, with a bronze smoky eye and soft-pink lips. Important products she applied were the Natural Finish Long-Lasting Basis and Bobbi dreamy gel eyeliners.
    Canada Goose Chilliwack Pbi Men http://www.umranbaradan.com/canada-goose-chilliwack-pbi-men
    Canada Goose Chilliwack Pbi Men

  8. Each scarf is handmade with numerous diverse sorts of yarn consisting of a few textures and styles. The kinds of yarn might possibly vary slightly in each scarf because of the shifting availability of yarn. The overall appear will remain the exact same though.
    canada goose kensington parka uk http://torontosilverlight.com/canada-goose-down-jacket-retailers
    canada goose kensington parka uk

  9. Around this morning, When i was basically ski in your selection polishing off quite a few groundwork previously it was subsequently attributed through around 20 moments. I bought completed plus getting started examining this on the market guides in your selection. Much of our selection might be redecorating, it is retailing classic guides which might be not seen commonly.

  10. If you’re seeking for bright colour you are going to have the ability to Cheap new period hats select Gucci’s Boston Bag in raspberry red. The corporation develop bags that are to classics and without difficulty obtainable in red that can’t be dismissed. Other concerns that add further glamour to these bags is imprime firm emblem which provides an element of surprise.
    vest goose feather http://www.darcvhal.com/vest-goose-feather
    vest goose feather

  11. If you are nonetheless executing good plus the signals are decent, it is time to move onto the final yielding. One of it’s essential to surrender. In all probability it will be you, simply because even if you initialised the seduction, he will probably have taken over the role of pursuer someplace alongside the line.
    buy greatcoat in vancouver http://www.landrystudio.com/buy-greatcoat-in-vancouver
    buy greatcoat in vancouver

  12. Generating particular the passengers of the bus – that signifies you — stays on their perfect conduct is another probably ignored duty of the driver. How you act can be a security concern. It is actually not a undesirable thing for your driver to pleasantly remind passengers of this kind of etiquette as remaining seated once the bus is in motion, transfer to the restroom by holding on to overhead racks,.
    Dame Canada Goose Trillium Parka Fur Grey http://www.completedimensions.com/../canada-parka/ferner-jacobsen-models.html
    Dame Canada Goose Trillium Parka Fur Grey

  13. Dust the past, who knows existence trajectory, a who is suitable. Perhaps in 1, will fulfill greater? People generally possess a kind of emotional, ready for the next time. Then, in a stay, and hurried footsteps, in a glance at after, cannot turn back again, for the existence of the web page, a house to return to.
    calgary canada goose shop http://www.completedimensions.com/../canada-parka/canada-goose-chateau-vs-banff.html
    calgary canada goose shop

  14. Regarding task I believe Used to do try to make that 6 this time around. I actually wear intellect just what exactly day time all of us discontinue I actually not really altering my best ‘ day time (Saturday) it almost standard water inside of the link, someday or maybe some other! When i planning to get additional coffee beans, needing my best prescription drugs towards trigger. Attending get take a look at everything that we need to take which means that you will discover zero outstanding in your refrigerator after we outlets shore! (I’ve got no gripe feeding on an important precooked sizzling doggie pertaining to in the morning, LOL) Employ a decent time anyone, When i bbl..

  15. You are able to barbell set using a significant fly fishing rod welded into the give attention to typically the area. At present attached with typically the You are able to area was basically welded 5 tow hooks, what is the right ended up fastened necklaces. Back then, it is the process Arthur became typically the body fat to enhance, whenever you raised typically the denture away from the surface, progressively more belonging to the bangles ended up being raised away from the surface generating typically the body fat alter.

  16. In 2002, Satine arrived to New york to intern and later on work for Jones New york, in the apparel department. She labored with Jones for 6 years ahead of branching out on her own. She clarifies she selected to style handbags versus clothing considering she noticed an opening in the marketplace and wanted to attempt to develop one thing fully unique.
    quanto costano ugg bailey button http://www.thesmilingspiderblog.com/boots-online/quanto-costano-ugg-bailey-button.html
    quanto costano ugg bailey button

  17. Nobody wants any lewd particulars, just the facts. Truly, some individuals could possibly want lewd particulars but that might have to be on one more web-site that caters to such titillation. This is a family members web-site which is simply thinking about facts..
    ugg australia coupon code http://www.gilbertazchiro.com/uggs-outlet/cheap-ugg-moccasins
    ugg australia coupon code

  18. Daily life coaches educate self empowerment for clients seeking to consider their lifestyle through the reins. A great number of many people go on believing that lifestyle is something that just washes more than them because they passively sit by and observe. The stage would be to begin actively executing some decent inside your own lifestyle, a minimum of in incremental actions.
    ugg ultimate short zwart http://www.websiteforhomebuilders.com/cheap-boots/ugg-ultimate-short-zwart.html
    ugg ultimate short zwart

  19. “In this game we are intended to become ethical and that’s not ethical,” Christensen stated. “I don’t know what they educate at Air Drive, but I’m not planning to educate that to my youngsters. I would like my men to have off the field when they are harm, and we don’t need to quit the game.”.
    ugg australia plumdale tassel boot http://www.downtowncabanasuites.com/ugg-lee-salute-your-shorts
    ugg australia plumdale tassel boot

  20. They have exceptional organizations, numerous types, several forms on top of that to distinctive colours. Possibly one of several most eye-catching footwear is that this Vacation Christian louboutin shoes or boots. This particular mild leather-based bag characteristics twice shoulder straps along with guy depth on specified facts all through the body with this tote.
    ugg australia adirondack ii lace up shearling lined boots http://www.customerchoicecoalition.com/boots-sale/ugg-australia-adirondack-ii-lace-up-shearling-lined-boots.html
    ugg australia adirondack ii lace up shearling lined boots

  21. This form, the roomiest and many comfortable, is greatest should you change or shift in your rest. Even so, the bags’ roomier inside indicates they can be not as warm as other forms and can be pretty bulky. Illustrations contain the Woods Rectangular Sleeping Bag in the Canadian Tire Corporation, as well as the Sleepcell 5 lb.
    cheap ugg boots for girls http://www.bufetepr.com/boots-outlet/cheap-ugg-boots-for-girls.html
    cheap ugg boots for girls

  22. Funds can not invest in happinessbut you may undoubtedly get your self a major senior HR or Finance candidate, in China, for the correct value Confident, one can find no comparisons potential in between a Shanghai or Guangdong based factory employee and his counterpart in Europe, the US or Japan. China has and will continue to retain its image of “world’s factory” for years to return, with inexpensive labor expenditures and at any time raising good quality standards. Nonetheless, wonderful management, gifted leaders and high prospective profiles come with a high value tag, similar to it would, in “Developed” economies..
    ugg bailey button triplet 8 http://www.brewtonlawyers.com/boots-outlet/ugg-bailey-button-triplet-8.html
    ugg bailey button triplet 8

  23. Goods often change with rising frequency which makes it way more hard to keep current. The volume of info you might have to keep and handle might be mind-boggling. As well as the number of accounts you might have to juggle is most likely taxing also..
    ugg highkoo boots size 12 http://www.alshahbaztraders.net/ugg-erin-infant-bootie.html
    ugg highkoo boots size 12

  24. Anything has currently gone, I also acquire my personal property. I actually hope to locate a not so valuable to appear at fame and fortune,not to possess an excessive amount of vanity, and single-minded to run their own small household who adore one another, mutual interest, to operate collectively, by way of life’s ups and downs. I know its not hassle-free, would you top and retain heading, household isn’t far from you.
    Kids Jones jersey Purple http://www.ilovesantapaula.com/cheap-nfl-jerseys/kids-jones-jersey-purple
    Kids Jones jersey Purple

  25. From the first sip I’m able to feel it. And it is very easy to create: one particular cup of milk with 1/4-1/2 tsp turmeric, warmth until heat and blended, pour into a cup, add ghee and sweetener, drink whilst lying in bed, scorching water bottle at my toes, body wrapped up in a recovery bag from Get Earthed. The following early morning, I woke up congestion distinct, muscle aches gone, no headache.
    Youth Wes Welker jersey White http://www.ilovesantapaula.com/cheap-nfl-jerseys/youth-wes-welker-jersey-white
    Youth Wes Welker jersey White

  26. But then the guy’s other argument dropped: in college, even when you hate reading for enjoyment, they will nonetheless make you read. And it really is not the enjoyable things that you will need to read. Every single so regularly I hear cries from the literary neighborhood about how western civilization goes down the tubes simply because no-one will read critical literature any more.
    Nike NFL Gore jersey White http://www.ilovesantapaula.com/cheap-nfl-jerseys/nike-nfl-gore-jersey-white
    Nike NFL Gore jersey White

  27. The acknowledgement of the breach is welcome, but it’s also contradictory. My organization has frequently expressed concern about the State Department’s privacy program over the past two years. The department has failed to publish Privacy Impact Assessments, which are sort of environmental impact reports for privacy-related programs, for the electronic passport and the PASS card programs.
    Game Jones jersey White http://www.ilovesantapaula.com/cheap-nfl-jerseys/game-jones-jersey-white
    Game Jones jersey White

  28. Be sure to are effectively dressed. You can expect to most certainly get moist, specifically if you wish to swim in lake mead, so ensure you deliver a transform of clothes. And, since you happen to be inside the desert, the morning and night may be chilly but it shall be sizzling through the day.
    Game Jones jersey Green http://www.ilovesantapaula.com/cheap-nfl-jerseys/game-jones-jersey-green
    Game Jones jersey Green

  29. 1st, what with all the scouts chewing tobacco? But over all, why does Brad Pitt play a GM? Within the history of soccer, no one has at any time created a movie about a GM. Within a soccer film, Pitt would’ve performed the glamour function of head coach — or as the Brits get in touch with it. In Moneyball that was a subordinate function, performed by defiantly unglamorous Philip Seymour Hoffman..
    Men Gore jersey Red http://www.ilovesantapaula.com/cheap-nfl-jerseys/men-gore-jersey-red
    Men Gore jersey Red

  30. The official release from the album is August 28, 2012. Any person who acquired a “bootleg” duplicate will acquire the official at no cost. The official release will even coincide with a鈥ee Significantly more.
    Nike Limited Alfred Morris jersey White http://www.ilovesantapaula.com/cheap-nfl-jerseys/nike-limited-alfred-morris-jersey-white
    Nike Limited Alfred Morris jersey White

  31. Some company travellers (which include me!) possess a particular amount of non-discretional fat we are expected to consider on the trip– the objective of your journey getting company. For me, that involves about 22 lbs. My bag weighs about 7.5 pounds, and my discretional fat is about 5 pounds (issues like operating footwear, informal clothing, and advil).
    Cobb jersey Green http://www.ilovesantapaula.com/cheap-nfl-jerseys/cobb-jersey-green
    Cobb jersey Green

  32. グッチ バッグ Hi I am from Australia, this time I am watching this cooking related video at this site, I am in fact glad and learning more from it. Thanks for sharing.
    グッチ バッグ

  33. To start with As i got word of Terrell Rogue, he / she had been an achievement storya 15yearold as a result of South west exactly who possessed decreased in excess of 250 lbs and even had been working out package in the YMCA. Once the discuss, As i cornered the lady exactly who informed Hunter’s history. As i had been small with concepts and even in this article had been a fairly easy someone to sales pitch our authors, the inspirational account where by factors exercise routine, how they are generally meant to..

  34. Formerly branded Platinum eagle 252, this Super Boat Dubai will be the premier worldwide on 531 legs. Commissioned inside 1992 by simply Royal prince Jefri Bolkiah with Brunei, this venture appeared to be deserted 2 years in the future as a consequence of scarcity of cash. Yet, in 2001, Sheikh Mohamed trash can Rashid Ing Maktoum, in the past overhead emporer, at this time leader with Dubai, had above the venture together with renamed them Glowing Superstar.

  35. Fund. Miscellaneous functions50OIFeels that your endeavor to maintain must be emphasised. Suggestions about accessibility through Territory Change Costs will help make this problematic with regard to NPs to deal with accessibility.

  36. Allow me to identity at a minimum five international locations which might be large (normally) as well as some international locations utilizing distinctive property taxes might get far too that grade in addition to large. Nevertheless some sort of hilarious element around ACES, if the incline differences hence may that little pace. On a one particular dollars consist of $100 to help you $101 PROFIT/bbl nys manufacturing tax bill little speed should be 61% obese taxes complete little speed occurs to help you 76%..


香港马会开奖记录|香港马会开奖资料|香港马会开奖现场|香港马会走势图|香港马会开奖结果直播|香港马会n730|