.profile不生效

yikaikai

贴出来看看

xiaohe21

listener.ora内容
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = intac>
      (ORACLE_HOME = /export/home/app/oracle/oraInventory)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.254)(PORT = 1521))
    )
  )



tnsnames.ora内容

# tnsnames.ora Network Configuration File: /export/home/app/oracle/oraInventor
network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INTAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.254)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = intac)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan 23 17:11:12 2007

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

SQL>
sqlplus /nolog没问题

这是怎么回事呢??

yikaikai

没问题啊？

yikaikai

你再用connect id/passwd 登陆看看

xiaohe21

已解决，
listener.ora内容
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = intac)
      (ORACLE_HOME = /export/home/app/oracle/oraInventory)
  #    (PROGRAM = extproc)  注释掉
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.254)(PORT = 1521))
    )
  )



tnsnames.ora内容

# tnsnames.ora Network Configuration File: /export/home/app/oracle/oraInventor
network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INTAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.254)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = intac)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = intac )
      (PRESENTATION = RO)
    )
  )

然后用bda启动数据库
sqlplus / as sysdba
startup
启动正常