-
I am at a showstopper ...cannot get the Enterprise Manager up on the local machine. When attempting to start emctl I still get errors ORA-27101. And even though I define the ORACLE_SID, somehow it always comes back to the error "The ORACLE _SID is not defined."
When I try to start the listener I get error
"No message file for product=network, etc."
Anybody?
-
your ORACLE_HOME and or ORACLE_SID arent defined correctly
-
Originally Posted by davey23uk
your ORACLE_HOME and or ORACLE_SID arent defined correctly
Hardcode them in the oracle user .profile.
-
OK. Back at it everybody! To this point I am close to accessing the isqlplus from my web browser. From web browser I type:
http://192.xxx.x.xx:5560/isqlplus
and get the following error messagge:
ORA-12162 - TNS - net service name is incorrectly specified.
Here's what's currently in my tnsnames.ora file:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jacob) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
---------------------------------------
Here's my listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=jacob.aspsftwre)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=jacob.aspsftwre)
(ORACLE_HOME=/export/ORACLE_HOME)
(SID_NAME=jacob)))
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp) (HOST=jacob) (PORT = 1521))
)
)
So, what do you think?
-
you are trying to connect to a database called ORCL - you dont have a database called ORCL do you
-
OK I modified my tnsnames.ora file to read as follows:
jacob.aspsftwre =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jacob) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jacob)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
I tried to start isqlplus again, but still get the TNS error #12543.
In my /etc/hosts file this is what I have:
127.0.0.1 localhost
10.10.10.10 jacob loghost
Could this be a problem? I think the correct IP address needs to be written here for the server, right? If so, how do I modify this file? I'm unable to write directly to it. Is there a shell script that makes the changes to this file?
-
do you not have a dba or SA around to help you with these things
-
Yeah I'm flyin this baby alone. Hey, I'm trying to start the LISTENER. When I'm logged in as oracle user, it denies me permission. If I switch to root I get alot of missing Message errors and it too fails to start it. I think I need to add the oracle user to the dba group, but I can't find any documentation on exactly how you do that. I'm thinkin this might be what's preventing me from starting the listener. Can you give me a hint ...anyone?
Bill
-
post the exact command and errors and details about the user
-
As oracle user:
$ /export/ORACLE_HOME/bin/lsnrctl start LISTENER
ld.so.1: /export/ORACLE_HOME/bin/lsnrctl: fatal: /export/ORACLE_HOME/lib/libclntsh.so.10.1: Permission denied
Killed
$
------------------------------------------------------------------------
As root:
-bash-3.00# /export/ORACLE_HOME/bin/lsnrctl start LISTENER
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-OCT-2006 09:42:19
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
Solaris Error: 2: No such file or directory
-bash-3.00#
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|