Fw: Re: Oracle 8.1.7 ORA-12545 problem

[Michopoulos Harry]

Êáôáñ÷Þí íá óáò åõ÷áñéóôÞóù ãéá ôéò áðáíôÞóåéò êáé ôï Üìåóï åíäéáöÝñïí óáò. 
Ðáñ' üë' áõôÜ ôï ðñüâëçìá äåí ëýèçêå, åíþ êÜðïéá ðñÜãìáôá ðïõ Ý÷ù 
ðáñáôçñÞóåé ìå êÜíïõí íá ðéóôåýù ðùò ç åãêáôÜóôáóç íáé ìåí ïëïêëçñþèçêå áëëÜ 
äåí Ýãéíå óùóôÜ. Êáé ãßíïìáé ðéï óõãêåêñéìÝíïò. 
ôï áñ÷åßï listener.ora ðåñéÝ÷åé ôá åîÞò: 
 
# LISTENER.ORA Network Configuration 
File: /home/db8i/OraHome1/network/admin/listener.ora 
# Generated by Oracle configuration tools. 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
      ) 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 
      ) 
    ) 
    (DESCRIPTION = 
      (PROTOCOL_STACK = 
        (PRESENTATION = GIOP) 
        (SESSION = RAW) 
      ) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481)) 
    ) 
  ) 
 
#SID_LIST_LISTENER = 
 # (SID_LIST = 
  #  (SID_DESC = 
   #   (SID_NAME = PLSExtProc) 
    #  (ORACLE_HOME = /home/db8i/OraHome1) 
     # (PROGRAM = extproc) 
 #   ) 
#  ) 
### ÔÝëïò áñ÷åßïõ 
Ðñéí âÜëù óå ó÷üëéá ôéò ôåëåõôáßåò ãñáììÝò, üôáí ðÞãáéíá íá îåêéíÞóù ôï 
listener 
lsnrctl start 
åðáéñíá ôï ìÞíõìá ðùò äåí âñßóêåé ôï áñ÷åßï extproc ôï ïðïßï üíôùò äåí 
õðÜñ÷åé ðïõèåíÜ êáé ï listener äåí îåêéíïýóå. 
¸ôóé áíáãêÜóôçêá íá âÜëù óå ó÷üëéá ôéò ãñáììÝò áõôÝò êáé íá îåêéíÞóù ôï 
listener. ¼íôùò îåêßíçóå áëëÜ ôï 12545 ðáñáìÝíåé. 
Åðßóçò, ó÷åôéêÜ ìå ôéò äéåñãáóßåò. Äåí õðÜñ÷åé êáìßá äéåñãáóßá ìå üíïìá 
ora_<êÜôé>, üìùò ðÜëé äåí âñßóêù áñ÷åßá ìå ôá ïíüìáôá ðïõ äßíïíôáé óôï 
ìÞíõìá ôïõ ê. ÄáóêáëÜêç. 
Åðßóçò, ßóùò ðñÝðåé íá áíáöÝñù ðùò ôï ìÞíõìá ôï ðáßñíù áêüìá êáé êáôÜ ôç 
äçìéïõñãßá íÝáò âÜóçò áðü ôïí assistant. 
ÔÝëïò, ðáñÜ ôá áñ÷åßá ðïõ ëåßðïõí ôá åñãáëåßá ôçò oracle, net configuration 
assistan, database assistan, dbastudio ôñÝ÷ïõí êáíïíéêÜ. 
Èá Þèåëá ëïéðüí, åáí äåí åßíáé êüðïò íá ìÜèù åáí ôá áñ÷åßá ðïõ ìïõ ëåßðïõí 
õðÜñ÷ïõí óôï äéêü óáò óýóôçìá, êáèþò êáé ôç ãíþìç óáò åÜí ç åãêáôÜóôáóç 
ãßíåôáé óùóôÜ Þ ü÷é êáé ôé ìðïñåß íá öôáßåé ãé áõôü. 
 
Åõ÷áñéóôþ êáé ðÜëé êáé óõãìþìç ãéá ôï ìÝãåèïò ôïõ êåéìÝíïõ 
× Ìé÷üðïõëïò 
 
 
------------- Forwarded message ------------- 
At Wed, 26 May 2004 10:22:16 +0300, 
Stelios Daskalakis wrote: 
>  
Epipleon exeuis kataferei na sikoseis to Oracle instance (database 
server)? 
Ena aplo ps aux | grep ora_ 
tha se peisei. Tha prepei na deis kati san 
 
  oracle 12256     1  0   May 21 ?        0:06 ora_ckpt_<instance_name> 
  oracle 12258     1  0   May 21 ?        1:45 ora_smon_<instance_name> 
  oracle 12260     1  0   May 21 ?        0:00 ora_reco_<instance_name> 
  oracle 12252     1  0   May 21 ?        1:14 ora_dbw0_<instance_name> 
  oracle 12250     1  0   May 21 ?        0:00 ora_pmon_<instance_name> 
  oracle 12262     1  0   May 21 ?        2:15 ora_arc0_<instance_name> 
  oracle 12254     1  0   May 21 ?       23:11 ora_lgwr_<instance_name> 
 
An ta vlepeis i vasi exei sikothei kai den mporeis na syndetheis. Se 
ayti tin periptosi dokimase na ftiaxeis ta tnsnames.ora, sqlnet.ora 
kai listener.ora kai na sikoseis ton Oracle listener me 
lsnrctl start 
 
> tsekare an to output ths  entolhs hostname einai swsto.  
> To  ORA-12545 symfwna me thn oracle einai: 
> "Connect failed because target host or object does not exist." 
> episis, dokimase na allaxseis to hostname se ip mesa sto tnsnames.ora. 
> ena geniko install guide oracle se linux einai: 
> http://www.oracle-base.com/articles/Linux/ArticlesLinux.php 
> nomizw oti exei k gia 8i. 
>  
> hope this helps 
> s 
> ================================== 
> Stelios Daskalakis 
> PhD Candidate, Health Informatics 
> University of Athens 
> email: stdask at nurs.uoa.gr 
> ================================== 
>  
>  
> Áñ÷éêü ìÞíõìá áðü  Harry Michopoulos <p98018 at rainbow.cs.unipi.gr>: 
>  
> > ×áßñåôå, 
> >  
> > ðñïóðáèþ íá âÜëù ôçí Oracle 8.1.7 óå äýï ìç÷áíÞìáôá ðïõ ôñÝ÷ïõí ëßíïõî  
> > êáé Ý÷ù ôá åîÞò ðñïâëÞìáôá. 
> > Ôï ðñþôï ìç÷Üíçìá ôñÝ÷åé Mandrake 10 êáé ç åãêáôÜóôáóç äåí îåêéíÜåé ìå  
> > ôßðïôá. Áðü ðáëáéüôåñåò äéáíïìÝò RH,SuSE îÝñù êé Ý÷ù äïêéìÜóåé ìå  
> > äéáöïñåôéêïýò óõíäõáóìïýò ôá 
> > unset LANG 
> > êáé 
> > export LS_ASSUME_KERNEL=2.2.5 
> > ÷ùñßò üìùò áðïôÝëåóìá. 
> > Óôï äåýôåñï ìç÷Üíçìá Ý÷ù Debian 3.1 sarge. Ç åãêáôÜóôáóç ãßíåôáé  
> > êáíïíéêÜ, ìáæß ìå ôï stubs patch ðïõ äßíåé ç Oracle. ¼ìùò üôáí ðñïóðáèþ  
> > íá öôéÜîù ìéá âÜóç ìïõ âãÜæåé äéáñêþò ORA-12545. ¸÷ù ñõèìßóåé ôá  
> > ORACLE_HOME, NLS_LANG êáé TNS_ADMIN. ¼ìùò ôï ìÞíõìá ðáñáìÝíåé.  
> > ×áñáêôçñéóôéêÜ äåí ìðïñþ íá ìðù ïýôå óôï svrmgrl, áöïý ðáßñíù ôï ßäéï  
> > ìÞíõìá. 
> > ÂáóéêÜ ìå åíäéáöÝñåé ðåñéóóüôåñï íá äïõëÝøåé ôï äåýôåñï ìç÷Üíçìá. 
> > ÏðïéáäÞðïôå éäÝá Þ ðëçñïöïñßá åßíáé åõðñüóäåêôç 
> >  
> > Åõ÷áñéóôþ åê ôùí ðñïôÝñùí 
> >  
> >  
> > --  
> > linux-greek-users mailing list -- http://lists.hellug.gr 
> >  
>  
>  
>  
> --  
> linux-greek-users mailing list -- http://lists.hellug.gr 
--    
  Kostas Zorbadelos 
  Currently at: Otenet IT Department  
  mailto: kzorba at otenet.gr 
   
  Out there in the darkness, out there in the night 
  out there in the starlight, one soul burns brighter 
  than a thousand suns. 
 
-- 
H Michopoylos 
Uni.Pi. Inf. Dep.