Home » Infrastructure » Linux » startup problem in oracle database on Linux as4 platform
startup problem in oracle database on Linux as4 platform [message #302843] Wed, 27 February 2008 02:42 Go to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
i have install oracle 9i on Linux as4 give by selecting Oracle database enterprise edition and general purpose and giving Global databse name - SSDB and SID = SSDB ; installation was done successfully , but i am suprised that at that time of installation it asked for only Disk-3 of Oracle not for DISK-2 , after installation it is asked for change of password for sys and system. i have entered with sys user in sqlplus , try to connect the database using "CONN /as SYSDBA" . i got connected , now i had tried to start the database using "STARTUP " command but i am getting the error "ora-01078 failure in processing system parameters and LRM-00109 ; could not open parameter file '/u01/app/oracle/product/9.2.0/dbs/initest.ora'
i couldn't understood that why it is asking for "initest.ora" whereas i have already set the other SID =SSDB " i think it should ask for initssdb.ora file am i correct? please suggest the solution i will be grateful to you
Re: startup problem in oracle database on Linux as4 platform [message #302897 is a reply to message #302843] Wed, 27 February 2008 05:10 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Seems like ORACLE_SID is not set.

What do you see when you enter this command at Linux shell

$ env | grep ORA

you should see something like

ORACLE_SID=SSDB

if not ...you have to set the ORACLE_SID variable

$ export ORACLE_SID=SSDB

Then try to connect to the database.






Re: startup problem in oracle database on Linux as4 platform [message #302917 is a reply to message #302897] Wed, 27 February 2008 06:05 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
thanks nand kumar
by running the said command i am getting oracle_sid=test so i have run the export command again i am getting the same error but at this time file is initssdb.ora .
waiting for your kind reply

Re: startup problem in oracle database on Linux as4 platform [message #302926 is a reply to message #302917] Wed, 27 February 2008 06:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post what you did. Do not describe what you did. It helps us little. Just copy and paste the session within CODE tags.
Check whether you have initssdb.ora in your $ORACLE_HOME/dbs.
Post the output of
ls -lart

from $ORACLE_HOME/dbs.
Make sure you have set
ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin




Re: startup problem in oracle database on Linux as4 platform [message #302931 is a reply to message #302926] Wed, 27 February 2008 06:46 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
Thanks Mahesh
I have run command given by you the output is given below.
-rwxr-xr-x 1 root root 1053 bash_profile~
-rw-r--r-- 1 oracle oinstall 658 .zshrc
drwxr-xr-x 2 oracle oinstall 4096 .xcmacs
drwxr-xr-x 3 oracle oinstall 4096 .kde
-rw-r--r-- 1 oracle oinstall 120 .gtkrc
-rw-r--r-- 1 oracle oinstall 383 .emacs
-rw-r--r-- 1 oracle oinstall 5619 .canna
-rw-r--r-- 1 oracle oinstall 124 .bashrc
-rw-r--r-- 1 oracle oinstall 304 .bash_logout
drwxr-xr-x 4 root root 4096 ..
-rw-r--r-- 1 oracle oinstall 1145 .bash_profile
-rw-r--r-- 1 oracle oinstall 39 afiedt.buf
-rw------- 1 oracle oinstall 8291 .bash_history

i have set the given path .
but error is same
waiting for your reply





Re: startup problem in oracle database on Linux as4 platform [message #302933 is a reply to message #302931] Wed, 27 February 2008 06:55 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
$ cd /u01/app/oracle/product/9.2.0/dbs/
$ ls -lart
Re: startup problem in oracle database on Linux as4 platform [message #302939 is a reply to message #302933] Wed, 27 February 2008 07:10 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member

thanks
at the time insttaling oracle it has asked to run /u01/app/oracle/product/9.2.0/root.sh after it asked "enter the full path name of local bin directry :/usr/local/bin" and we have given default path as it is

please suggest, the suggested path should be given here i.e. $ORACLE_HOME/bin here ?????
Re: startup problem in oracle database on Linux as4 platform [message #302942 is a reply to message #302939] Wed, 27 February 2008 07:14 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
hello mahendra
one thing more installation of the oracle on linux as4 completed successfully with only Disk-1 why it was not asked for Disk-2 and Disk-3

Re: startup problem in oracle database on Linux as4 platform [message #302949 is a reply to message #302942] Wed, 27 February 2008 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> why it was not asked for Disk-2 and Disk-3
Depends on the options you would have chosen.

>> please suggest, the suggested path should be given here i.e. $ORACLE_HOME/bin here ?????
Nope.
/usr/local/bin is the right one
Re: startup problem in oracle database on Linux as4 platform [message #302956 is a reply to message #302931] Wed, 27 February 2008 07:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote.
but error is same
waiting for your reply

Again,
Do not describe what you did.
Post what you did. Just copy and paste. Verbatim.
Re: startup problem in oracle database on Linux as4 platform [message #302960 is a reply to message #302949] Wed, 27 February 2008 07:44 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
Thanks Mahesh
I have run command given by you the output is given below $ORACLE_HOME/dbs
ls -lart .
Quote:
-rw-r--r-- 1 oracle oinstall 12920 initdw.ora
-rwxrwxrwx 1 oracle oinstall 8385 init.ora
-rwxrwxrwx 1 oracle oinstall 3584 spfiletest.ora
-rwSr-------- 1 oracle oinstall 1536 orapwtest
-rwSr-------- 1 oracle oinstall 1536 orapwSSDB
drwxr-xr-x 51 oracle oinstall 4096 ..
-rw-rw----- 1 oracle oinstall 24 LKDEFAULT
lrwxrwxrwx 1 root root 57 link to spfileSSDB.ora->/u01/app/oracle/product/9.2.0/dbs/spfileSSDB.ora
-rw-rw----- 1 oracle oinstall 24 lkSSANETDB
drwxr-xr-x 2 oracle oinstall 4096 ..

waiting for your reply


Re: startup problem in oracle database on Linux as4 platform [message #302972 is a reply to message #302960] Wed, 27 February 2008 08:16 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
after that we have dinstalloracle and again reintall we got the same problem then i export the ORACLE_UID=SSARLM
then we mount the database database successfully mounted we have started the listner also .
but from client machine if i am trying to TNSPING SSARLM we are getting 'tns protocol adapter error ;
why
please help

at that time after running ls -lart command i am getting following output
Quote:
-rw-r--r-- 1 oracle oinstall 12920 Mar 8 2002 initdw.ora
-rw-r--r-- 1 root root 8385 Mar 9 2002 init.ora~
-rw-r--r-- 1 oracle oinstall 8385 Mar 9 2002 init.ora
-rw-r----- 1 oracle oinstall 3584 Feb 27 12:27 spfiletest.ora
-rw-r----- 1 oracle oinstall 3584 Feb 27 12:27 spfileRATLAM.ora
-rw-r----- 1 oracle oinstall 3584 Feb 27 12:27 initest1.ora
-rwSr----- 1 oracle oinstall 1536 Feb 27 12:28 orapwtest
-rwSr----- 1 oracle oinstall 1536 Feb 27 12:28 orapwRATLAM
-rw-r--r-- 1 oracle oinstall 8384 Feb 27 13:08 initest.ora~
-rw-r--r-- 1 oracle oinstall 8384 Feb 27 13:08 initest.ora
-rw-r----- 1 oracle oinstall 24 Feb 27 16:16 lkRATLAM
drwxr-xr-x 51 oracle oinstall 4096 Feb 27 18:26 ..
drwxr-xr-x 2 oracle oinstall 4096 Feb 27 18:53 .
-rw-rw---- 1 oracle oinstall 3584 Feb 27 18:53 spfilessarlm.ora
-rwSr----- 1 oracle oinstall 1536 Feb 27 18:58 orapwssarlm
-rw-rw---- 1 oracle oinstall 24 Feb 27 19:03 lkSSARLM

here two ORACLE_SID one is RATLAM and one is SSARLM
Re: startup problem in oracle database on Linux as4 platform [message #302980 is a reply to message #302843] Wed, 27 February 2008 08:46 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
i have install oracle 9i on Linux as4 give by selecting Oracle database enterprise edition and general purpose


9i what?
9.0.0.1?

if you chose enterprise edition:general purpose, it should ask for the second cd immediatly after 18% of installation.

Re: startup problem in oracle database on Linux as4 platform [message #302983 is a reply to message #302980] Wed, 27 February 2008 08:52 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
no i am using 9.2 oracle but it is not asking for second CD ?
I have installed in two /three different PC i am getting the same problem as said earlier
Re: startup problem in oracle database on Linux as4 platform [message #302992 is a reply to message #302972] Wed, 27 February 2008 09:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> TNSPING SSARLM we are getting 'tns protocol adapter error ;
I reckon you have tried it after setting your clients local tnsnames.ora
In server side, comment the contents of sqlnet.ora and try again.
PS:
>>but from client machine if i am trying to TNSPING SSARLM we are getting 'tns protocol adapter error ;
This is the last time I am going to respond if you DO NOT POST THE EXACT ERROR MESSAGE and CONTINUE TO DESCRIBE your issue.
Re: startup problem in oracle database on Linux as4 platform [message #302996 is a reply to message #302992] Wed, 27 February 2008 09:29 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
thanks mahedra
sorry for inconvenience
Quote:
# SQLNET.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = localdomain

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


Re: startup problem in oracle database on Linux as4 platform [message #302997 is a reply to message #302996] Wed, 27 February 2008 09:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
quoting myself
>>I reckon you have tried it after setting your clients local tnsnames.ora
>>In server side, comment the contents of sqlnet.ora and try again.
Re: startup problem in oracle database on Linux as4 platform [message #303000 is a reply to message #302997] Wed, 27 February 2008 09:45 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
after commenting the contents no change
Re: startup problem in oracle database on Linux as4 platform [message #303001 is a reply to message #303000] Wed, 27 February 2008 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1) Is the database up and available?
From the server, login locally with sql*plus, check.
2) Did you configure the Listener?
Post the contents of listner.ora, lsnrctl your_listener_name status
3) Did you configure your tnsnames.ora (from client). Post the contents.
Re: startup problem in oracle database on Linux as4 platform [message #303011 is a reply to message #303001] Wed, 27 February 2008 10:20 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
1. database is already mounted and up
from server side it is working

2. listner.ora

Quote:
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = RATLAM)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = RATLAM)
)
(SID_DESC =
(GLOBAL_DBNAME = ssarlm)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = ssarlm)
)
)

3. Listner status on server side

Quote:
[oracle@localhost ~]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 27-FEB-2008 21:18:10

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 27-FEB-2008 20:58:24
Uptime 0 days 0 hr. 19 min. 45 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RATLAM" has 2 instance(s).
Instance "RATLAM", status UNKNOWN, has 1 handler(s) for this service...
Instance "RATLAM", status READY, has 1 handler(s) for this service...
Service "RATLAMXDB" has 1 instance(s).
Instance "RATLAM", status READY, has 1 handler(s) for this service...
Service "ssarlm" has 2 instance(s).
Instance "ssarlm", status UNKNOWN, has 1 handler(s) for this service...
Instance "ssarlm", status READY, has 1 handler(s) for this service...
Service "ssarlmXDB" has 1 instance(s).
Instance "ssarlm", status READY, has 1 handler(s) for this service...
The command completed successfully



Re: startup problem in oracle database on Linux as4 platform [message #303013 is a reply to message #303011] Wed, 27 February 2008 10:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
3) Did you configure your tnsnames.ora (from client). Post the contents.
Re: startup problem in oracle database on Linux as4 platform [message #303014 is a reply to message #303011] Wed, 27 February 2008 10:26 Go to previous messageGo to next message
jrlm
Messages: 17
Registered: February 2008
Junior Member
client side tnsnames.ora
Quote:
####################################
# TNSNAMES.ORA Configuration File:D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Wed Apr 18 11:32:41 GMT+05:30 2007
####################################



RATLAM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.96.40.36)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = RATLAM))
)

RATLAM_10.96.40.35 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.96.40.35)(PORT = 1521))
)
(CONNECT_DATA = (SID = test)(SERVER = DEDICATED))
)
ssarlm=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.96.40.36)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = ssarlm))
)
Re: startup problem in oracle database on Linux as4 platform [message #303021 is a reply to message #303014] Wed, 27 February 2008 11:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. copy the tnsnames.ora to server.
try tnsping locally, followed by sqlplus session using username/password@tnsservice_you_created.
If it works, problem is with your client.

2. Comment of contents of sqlnet.ora in client(if any) and try again.
3. Does the pinging to server work? Else, is there a firewall involved?

And post the complete error message, with last relevant messages from sqlnet.log

[Updated on: Wed, 27 February 2008 11:07]

Report message to a moderator

Previous Topic: Resource 'ora.rac2.ASM.asm' has placement error
Next Topic: MOST URGENT-----tnsping problem from client
Goto Forum:
  


Current Time: Thu Mar 28 10:04:38 CDT 2024