ÎÒÏëÔÚLINUXÏÂÁ¬WINDOWSÉϵÄORACLEÊý¾Ý¿â£¬²»ÖªµÀÄÄλÓÐʵÏÖ¹ý¡£Çë¸æÖªÒ»ÏÂÏêϸµÄʵÏÖ·½·¨£¡
˼·£º
1¡£ÄãÒªÔõôÁ¬½Ó,ÓÃSQLPLUS¾ø¶ÔûÓÐÎÊÌâ!
2¡£Äã¿ÉÔÚlinuxÅäÖÃÍø··þÎñnetmgrÀï±ßÓÐ
3¡£Õâ¸öºÍosÓÐʲô¹Øϵ£¬ÅäÖÃÄãµÄtsnames.ora¼´¿É£¡
4¡£ÎÒÏÖÔÚÔÚRADHAT9ÏÂÒѾװÉÏORACLEÁË£¬µ«¿âËÀ»î½¨²»ÉÏ£¬ÒѾ¿ÉÒÔÆô¶¯ sqlplusºÍ¼àÌý¡£µ«ÎÒ½«¼àÌýÉè³É¾ÖÓòÍøÄÚÁíһ̨WINDOWSµÄORACLEÊý¾Ý¿â£¬È´Á¬²»ÉÏ¡£ËùÒÔÎÒÏëÓÐûÓбðµÄ°ì·¨¿ÉÒÔLINUX²»×°Êý¾Ý¿â¿ÉÒÔÖ±½ÓÓÃÏñORACLEÖÕ¶ËÄÇÑù·ÃÎÊORACLEÊý¾Ý¿â¡£
5¡£oracle 10g does not need any client configuration
just run
sqlplus scott/tiger@database_host:listener_port/service_name
to connect to oracle
where the services name can be obtained on the database host by running
lsnrctl services