- 论坛徽章:
- 0
|
TRU64,ORACLE9I的DATABASE创建不了,谁帮个忙啊!!!
1. try to ping your box by hostname from AIX server first to see if UNIX knows your box.
2. I only use Solaris, I don't know if the directory name is the same or not, but the concept should O.K.
On AXI, go to /var/opt/oracle, create a symbolic link to your listener.ora file.
3. Sort out your Oracle environment, run this command:
echo $HOME
echo $PATH
echo $ORACLE_HOME
echo $ORACLE_SID
to see if they're correct or not.
4. compare your listener.ora file with this one:
-------------------
# LISTENER.ORA Network Configuration File: /export/home/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 0
LOG_DIRECTORY_LISTENER = /export/home/oracle/product/8.1.7.4/network/log
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = unixserver)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = unixserver)(PORT = 2481))
)
)
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = testdb)
(ORACLE_HOME = /export/home/oracle/product/8.1.7.4)
(SID_NAME = testdb)
)
)
-----------------------
5. in most case it should be "the wrong IP address of your database server in listener.ora file" or Oracle environment problem. Do you have a "dba" group" Is user oracle in dba groups? |
|