OraFAQ Forum: Linux » startup problem in oracle database on Linux as4 platform

Home » Infrastructure » Linux » startup problem in oracle database on Linux as4 platform

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

startup problem in oracle database on Linux as4 platform [message #302843]

Wed, 27 February 2008 02:42

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302897 is a reply to message #302843]

Wed, 27 February 2008 05:10

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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302917 is a reply to message #302897]

Wed, 27 February 2008 06:05

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302926 is a reply to message #302917]

Wed, 27 February 2008 06:29

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302931 is a reply to message #302926]

Wed, 27 February 2008 06:46

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302933 is a reply to message #302931]

Wed, 27 February 2008 06:55

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

$ cd /u01/app/oracle/product/9.2.0/dbs/
$ ls -lart

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302939 is a reply to message #302933]

Wed, 27 February 2008 07:10

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 ?????

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302942 is a reply to message #302939]

Wed, 27 February 2008 07:14

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302949 is a reply to message #302942]

Wed, 27 February 2008 07:23

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302956 is a reply to message #302931]

Wed, 27 February 2008 07:28

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302960 is a reply to message #302949]

Wed, 27 February 2008 07:44

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302972 is a reply to message #302960]

Wed, 27 February 2008 08:16

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302980 is a reply to message #302843]

Wed, 27 February 2008 08:46

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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302983 is a reply to message #302980]

Wed, 27 February 2008 08:52

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302992 is a reply to message #302972]

Wed, 27 February 2008 09:15

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302996 is a reply to message #302992]

Wed, 27 February 2008 09:29

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)

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #302997 is a reply to message #302996]

Wed, 27 February 2008 09:36

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303000 is a reply to message #302997]

Wed, 27 February 2008 09:45

jrlm
Messages: 17
Registered: February 2008

Junior Member

after commenting the contents no change

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303001 is a reply to message #303000]

Wed, 27 February 2008 09:53

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303011 is a reply to message #303001]

Wed, 27 February 2008 10:20

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

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303013 is a reply to message #303011]

Wed, 27 February 2008 10:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quote:

3) Did you configure your tnsnames.ora (from client). Post the contents.

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303014 is a reply to message #303011]

Wed, 27 February 2008 10:26

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))
)

Report message to a moderator

Re: startup problem in oracle database on Linux as4 platform [message #303021 is a reply to message #303014]

Wed, 27 February 2008 11:03

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 10:35:10 CST 2025