| the oracle can't work now in linux [message #52341] |
Tue, 16 July 2002 17:43  |
irix
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
when I install the oracle in linux,I setup the ip which is the 10.10.1.24,now I update the ip ,but the oralce can't work now.
I use the sqlplus command in the oracle server,type system/manager ,and print the error
ORA-01034: ORACLE not available
I view the log,find the database and lister is start,but when I use the command netstat|grep 1521,no message display.
who can tell me the reason and how to resolve it?
thanks
|
|
|
|
| Re: the oracle can't work now in linux [message #52349 is a reply to message #52341] |
Tue, 16 July 2002 22:36  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Your post is very confusing. The IP address it setup only in the listener.ora file, no where else.
If you have up to 8i, then don't use SQL*Plus to start the database - use:
$svrmgrl
svrmgrl>connect internal
svrmgrl>startup
For 9i -
$sqlplus /
sqlplus>conn /as sysdba
sqlplus>startup
You will not see any output from netstat, until someone opens a connection from a client to the server. The fact that the listener is running doesn't mean that the connection is open.
Hope that helps,
clio_usa
OCP DBA
Visit our Web Site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
