Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle database 10.2 installation on mac os 10.5. server

694593May 25 2009 — edited Jun 4 2009
Hi.,

Any how I managed to install oracle software and database with two attempt on mac server.
but it did not create listener.ora and tnsnames.ora file in admin directory.
I created both files and put it into /network/admin folder and configure it. it looks like:

tnsname.ora
RSG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rsg)
)
)


listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = rsg)
(ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
)
)
LISTENER =rsg
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.133)(PORT = 1521))
)
)


but when login through oracle and type lsnrctl status it shows:
LSNRCTL for MacOS X Server: Version 10.2.0.4.0 - Production on 25-MAY-2009 12:33:37

Copyright (c) 1991, 2007, Oracle. All rights reserved.

TNS-01150: The address of the specified listener name is incorrect
NL-00303: syntax error in NV string


2. when try to start database is shows:-


oracle:~ oracle$ dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: //Users/oracle/oracle/product/10.2.0/db_1/bin/dbstart ORACLE_HOME
touch: /Users/admin/oracle/product/10.2.0/db_1/startup.log: Permission denied
chmod: /Users/admin/oracle/product/10.2.0/db_1/startup.log: Permission denied
Processing Database instance "rsg": log file /Users/admin/oracle/product/10.2.0/db_1/startup.log
//Users/oracle/oracle/product/10.2.0/db_1/bin/dbstart: line 361: /Users/admin/oracle/product/10.2.0/db_1/startup.log: Permission denied


where my ORACLE_Home= /Users/oracle/oracle/product/10.2.0/db_1/bin/

here what is
touch: /Users/admin/oracle/product/10.2.0/db_1/startup.log: Permission denied

I tried to give permission like
chmod 777 /Users/admin/oracle/product/10.2.0/db_1/

but doesnot help.??


where is the problem ??
chmod: /Users/admin/oracle/product/10.2.0/db_1/startup.log: Permission denied
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2009
Added on May 25 2009
14 comments
2,808 views