I wish I knew what happenned....
1) There are 3 Oracle Dbs on the server. Yesterday, I was trying to create a new database using DBASSIST. I could not do it because evidently my username for the system did not have permission to create files and directories. I exited DBASSIST without doing anything more. I did not touch any of the databases or delete/modify any files.
2) That afternoon,no one was able to access the Dbs. We get the following when we try to log on,connect,find the problem....
Enter user-name: elizabet
Enter password:
ERROR:
ORA-01034: ORACLE not available
<other 2 attempts deleted here>
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
bash-2.03$ lsnrctl
LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 14-MAR-2001 11:54:12
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production
Start Date 27-FEB-2001 10:31:02
Uptime 15 days 1 hr. 23 min. 14 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /orahome/app/oracle/product/8.1.6/network/log/listener.log
Services Summary...
<Db1 name> has 1 service handler(s)
<Db2 name> has 2 service handler(s)
<Db3 name> has 2 service handler(s)
The command completed successfully
bash-2.03$ svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal@<db2 name>
ORA-12154: TNS:could not resolve service name
SVRMGR> exit
I looked around tried to find a tsnames.ora file. Evidently, this was set up using SQL*net and uses the names.ora file. I accessed this file and it only listed the name of one of the DBs as follows....
(CONNECT_DATA =
(SID = <Db1 name>)
(SRVR = DEDICATED)
)
I tried connecting to this Db and could not connect to it either.
I tried adding a second parameter to the names.ora file as follows...
(CONNECT_DATA =
(SID = <DB1 name>)
(SRVR = DEDICATED)
)
(CONNECT_DATA =
(SID = <Db2 name>)
(SRVR = DEDICATED)
)
There was no change.
What is wrong? How can I fix it so we can get into the Dbs?
1) There are 3 Oracle Dbs on the server. Yesterday, I was trying to create a new database using DBASSIST. I could not do it because evidently my username for the system did not have permission to create files and directories. I exited DBASSIST without doing anything more. I did not touch any of the databases or delete/modify any files.
2) That afternoon,no one was able to access the Dbs. We get the following when we try to log on,connect,find the problem....
Enter user-name: elizabet
Enter password:
ERROR:
ORA-01034: ORACLE not available
<other 2 attempts deleted here>
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
bash-2.03$ lsnrctl
LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 14-MAR-2001 11:54:12
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production
Start Date 27-FEB-2001 10:31:02
Uptime 15 days 1 hr. 23 min. 14 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /orahome/app/oracle/product/8.1.6/network/log/listener.log
Services Summary...
<Db1 name> has 1 service handler(s)
<Db2 name> has 2 service handler(s)
<Db3 name> has 2 service handler(s)
The command completed successfully
bash-2.03$ svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal@<db2 name>
ORA-12154: TNS:could not resolve service name
SVRMGR> exit
I looked around tried to find a tsnames.ora file. Evidently, this was set up using SQL*net and uses the names.ora file. I accessed this file and it only listed the name of one of the DBs as follows....
(CONNECT_DATA =
(SID = <Db1 name>)
(SRVR = DEDICATED)
)
I tried connecting to this Db and could not connect to it either.
I tried adding a second parameter to the names.ora file as follows...
(CONNECT_DATA =
(SID = <DB1 name>)
(SRVR = DEDICATED)
)
(CONNECT_DATA =
(SID = <Db2 name>)
(SRVR = DEDICATED)
)
There was no change.
What is wrong? How can I fix it so we can get into the Dbs?
