Home » RDBMS Server » Server Administration » Problem In Starting Oracle.....
Problem In Starting Oracle..... [message #203451] Wed, 15 November 2006 03:07 Go to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
i installed oracle 9i in linux . which has two user root as well as oracle . but oracle runs gud in oracle user with sqlplus .but i doesn't run on root user .
it says error TNS lost contact
so anybody plz help me
Re: Problem In Starting Oracle..... [message #203455 is a reply to message #203451] Wed, 15 November 2006 03:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

you get ora- TNS 12547 err

this is bcoz of ( may be) ur listener.log file reached 2 GB size.

go through below link
http://forums.oracle.com/forums/thread.jspa?threadID=68702&tstart=0



hope this helps
Mohammad Taj.
Re: Problem In Starting Oracle..... [message #203477 is a reply to message #203451] Wed, 15 November 2006 04:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
.but i doesn't run on root user .

You are not supposed to use root for any other purposes.
Re: Problem In Starting Oracle..... [message #203489 is a reply to message #203477] Wed, 15 November 2006 04:56 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
ya u r wright i doesnt run on root . but have one more problem i have installed java,jboss only on root user which iam able to access on other user . so without any option iam trying to run oracle in root user , suggestion plz . my listener.log file size is just 750kb ....

bye
Re: Problem In Starting Oracle..... [message #203494 is a reply to message #203489] Wed, 15 November 2006 05:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Again.
>>i have installed java,jboss only on root user
Do not use root for any normal application level operations.
In this case, you need to create another user (jboss user or some xyz), grant access to read oracle directories.
set the profile to read ORACLE_HOME and have $ORACLE_HOME/bin in PATH

Re: Problem In Starting Oracle..... [message #203498 is a reply to message #203494] Wed, 15 November 2006 05:33 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
oh ..... ok then i must log in as oracle user and then once again install java,jboss....etc ..and give permissions wright

bye
Re: Problem In Starting Oracle..... [message #203541 is a reply to message #203489] Wed, 15 November 2006 08:12 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
mnrnjn wrote on Wed, 15 November 2006 05:56
ya u r wright i doesnt run on root .



67% of this sentence is invalid.
Re: Problem In Starting Oracle..... [message #203542 is a reply to message #203541] Wed, 15 November 2006 08:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi joy

how can you measure exact 67%.
Cool

regards
taj

[Updated on: Wed, 15 November 2006 08:16]

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203557 is a reply to message #203542] Wed, 15 November 2006 09:15 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
9 words, 6 of which contain txt speak or gramatical errors.

To be fair, 66.66.. % of the sentence is invalid.
Re: Problem In Starting Oracle..... [message #203561 is a reply to message #203557] Wed, 15 November 2006 09:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi JRowbottom

exactly right...

regards
taj
Re: Problem In Starting Oracle..... [message #203643 is a reply to message #203541] Wed, 15 November 2006 23:01 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi gud mrng
thanks for ur idea it workd , i once again installed evry in oracle user. it worked . But i do face one more prob . i cant create a new database in oracle , iam able to manupulate only with the existing one ... can anybody help me out.

thanks

regards
mnrnjn
Re: Problem In Starting Oracle..... [message #203645 is a reply to message #203643] Wed, 15 November 2006 23:04 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
i once again installed evry in oracle user ?

you create new user in ur existing database. ?

But i do face one more prob . i cant create a new database in oracle


what error you getting.
and how are you create new db.
Create New DB through DBCA tools.
start>run>dbca (database configuration assistant).


hope this helps.
taj.
Re: Problem In Starting Oracle..... [message #203648 is a reply to message #203645] Wed, 15 November 2006 23:29 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
SQL> create database test;
create database test
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'TEST' does not match parameter db_name 'oramtxm'

this is the error iam getting..

how to create using dbca tools in linux .......


thanks
Re: Problem In Starting Oracle..... [message #203652 is a reply to message #203648] Wed, 15 November 2006 23:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
this is not a proper way to create new database in Oracle.

SQL> create database test;
create database test
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'TEST' does not match parameter db_name 'oramtxm'


before given above cmd. you create init.ora file. or create services.

if you want to create database manually then go through below link
http://dbataj.blogspot.com/2006/11/manually-database-creation.html

or using DBCA you can create new database.

for DBCA

start>program>oraclehome>configuration and migration > database configuration assistant ( DBCA)

hope this helps
Mohammad Taj.
Re: Problem In Starting Oracle..... [message #203656 is a reply to message #203652] Thu, 16 November 2006 00:03 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
before given above cmd. you create init.ora file. or create services.

thanks tat dbca worked .... but tell me the another way using init.ora or services . how to use this method of creating db in oracle...


thanks

bye
Re: Problem In Starting Oracle..... [message #203661 is a reply to message #203656] Thu, 16 November 2006 00:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
go through posted link in my previous post.

regards
taj
Re: Problem In Starting Oracle..... [message #203670 is a reply to message #203661] Thu, 16 November 2006 00:24 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
its only abt windows not in linux . ya dbca worked the database got created . tell me how to access it in sqlplus....

thanks
mnrnjn Laughing
Re: Problem In Starting Oracle..... [message #203672 is a reply to message #203670] Thu, 16 November 2006 00:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
yes i know it is windows . but dear oracle tools DBCA working on both pathform...

why ur not read my post clearly...
i already mention how can ur access / open DBCA.
DBCA is tools. is not a sqlplus cmd so you cann't access in sqlpluls. it is separate tools.

hope this helps
Mohammad Taj.
Re: Problem In Starting Oracle..... [message #203675 is a reply to message #203672] Thu, 16 November 2006 00:31 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi

ya it worked and database(test) got created .. but i do face prob in accessing tat test database now.. Is my prob clear r not

bye
Re: Problem In Starting Oracle..... [message #203678 is a reply to message #203675] Thu, 16 November 2006 00:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

plz. write clearly don't use short text forms.

and also post error with ur question..
which error you getting when you trying to access ur test database.

M.taj.
Re: Problem In Starting Oracle..... [message #203682 is a reply to message #203678] Thu, 16 November 2006 00:41 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
Sorry to disturb u . As u said the database(test) got created using dbca tool . It shows database(test) created . But i dont know
how to use the test database and create tables in test database.
How to check wheather test database has been created are not and how to acess tat test database......

bye
mnrnjn
Re: Problem In Starting Oracle..... [message #203693 is a reply to message #203682] Thu, 16 November 2006 01:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

through DBCA welcome windows there 4 option.
1.create database
2.configure database
3.delete database
4.template database.

check configure database.

and simple.

start>command> enter.

on command prompt.

cmd> set oracle_sid = test
cmd> sqlplus "sys as sysdba" enter

btw what is real name ?

hope this helps.
Mohammad Taj.

[Updated on: Thu, 16 November 2006 01:15]

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203720 is a reply to message #203693] Thu, 16 November 2006 02:22 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member

[oracle@localhost ~]$ set oracle_sid=test
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Nov 16 13:50:12 2006

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

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL>



I got this output after logging in . How to check that iam using
test database . .... and how to create,insert and manupulate in test database

bye
mnrnjn
Re: Problem In Starting Oracle..... [message #203721 is a reply to message #203720] Thu, 16 November 2006 02:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi


How to check that iam using
test database .


sql>show parameter db_name


how to create,insert and manupulate in test database


http://www.oracle.com/pls/db92/db92.homepage


any way what is ur name...?

hope this helps
Mohammad Taj.

[Updated on: Thu, 16 November 2006 02:25]

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203727 is a reply to message #203721] Thu, 16 November 2006 02:36 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
this is mano..... see this is the output iam getting

SQL> show user
USER is "SYS"
SQL> show parameters test;
SQL> show parameter test;
SQL>


Nothing is shown to me.... anything wrong done by me,
plz check the html file i have attached with this
bye
mano
Re: Problem In Starting Oracle..... [message #203730 is a reply to message #203727] Thu, 16 November 2006 02:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

sql>show parameter test
wrong
right is
sql>show parameter db_name
or
sql>select name from v$database;

Re: Problem In Starting Oracle..... [message #203736 is a reply to message #203730] Thu, 16 November 2006 02:53 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
SQL> show parameter db_name;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string oramtxm
SQL> select name from v$database;

NAME
---------
ORAMTXM


As you see its pointing only to oramtxm database
,thats ur old database . but not to the test database which i have created now...

bye
mano
Re: Problem In Starting Oracle..... [message #203744 is a reply to message #203736] Thu, 16 November 2006 03:25 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
R U there ..... plz help me . iam waiting for your reply
Embarassed
Re: Problem In Starting Oracle..... [message #203794 is a reply to message #203744] Thu, 16 November 2006 06:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
Are you sure you create test database successfully ?

and also try this way to connect/

cmd>sqlplus "sys@test/pwd as sysdba"

regards
Taj
Re: Problem In Starting Oracle..... [message #203909 is a reply to message #203794] Thu, 16 November 2006 23:00 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi gud morning
Ya that too worked .... I think it created successfully

SQL> show parameter db_name;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string test
SQL>


I think here after ill b able to manage..
But iam new oracle , i saw ur profile , i think u r oracle certified prof . so kindly help wat are all the concepts i need to go through and be strong enough to answer any question....

May i know were r u from , wat ru dng...

bye
mano
icon11.gif  Re: Problem In Starting Oracle..... [message #204154 is a reply to message #203909] Sat, 18 November 2006 04:16 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi raj
y r u not replying to my message, plz help me to learn oracle and its concepts.....
waiting for ur reply.......
bye
mano
Re: Problem In Starting Oracle..... [message #204161 is a reply to message #204154] Sat, 18 November 2006 05:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Mano,

i think u r oracle certified prof .?
Yes i am OCP.

so kindly help wat are all the concepts i need to go through ?

Continue Visit Oracle forms ( orafaq.com, forms.oracle.com etc)
http://tahiti.oracle.com


and be strong enough to answer any question....?

It depand on ur Skills.

If you have any problem concern with us.

regards
Taj.


[Updated on: Sat, 18 November 2006 06:23]

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204277 is a reply to message #204161] Sun, 19 November 2006 23:23 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi raj
thanks for ur reply and suggestion .....and ill follow ur words
Re: Problem In Starting Oracle..... [message #204384 is a reply to message #204277] Mon, 20 November 2006 07:14 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
Hi
Tell me difference between oca & ocp .. Y Oca and Y do v go for Ocp


bye
Re: Problem In Starting Oracle..... [message #204385 is a reply to message #204384] Mon, 20 November 2006 07:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Y Oca and Y do v go for Ocp
cannot resist anymore.
Could you please decipher your own language?
http://www.orafaq.com/forum/t/59966/42800/
Re: Problem In Starting Oracle..... [message #204387 is a reply to message #204384] Mon, 20 November 2006 07:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

Oracle 9i
OCA ------ Oracle Certified Associate
You have to clear two papers for OCA

OCP ------ Oracle Certified Professional
You have to clear two papers for OCP with OCA exams.

Oracle 10g.
For OCA - You have to two papers.
For OCP - One more paper with OCA exams.

hope this helps.
Mohammad Taj
OCP 9i


http://education.oracle.com/pls/web_prod-plq-dad/ou_homepage_utils.search_info?p_org_id=1001&p_lang=US&p_top_frame=Y


Mano, Y Oca and Y do v go for Ocp
plz.

[Updated on: Mon, 20 November 2006 07:25]

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204477 is a reply to message #204387] Mon, 20 November 2006 23:07 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi raj
Sorry yaar. Why do we go for OCA and Why do we go OCP. Which is the best of these two. Difference between these two exams....


bye
mano

Re: Problem In Starting Oracle..... [message #204480 is a reply to message #204477] Mon, 20 November 2006 23:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi mano,

My name is TAJ not is RAJ.

i already explain what is difference between OCA and OCP.
now turn is your you can decide what is best for you. and what are you want to do.

nobady can assist you for you own decision.

hope this clear.
Taj.
Re: Problem In Starting Oracle..... [message #204483 is a reply to message #204480] Mon, 20 November 2006 23:24 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi taj
Thanks for your reply . Plz let me know this one . What is Oracle
Administration (what concepts comes under this topics)..Actually i know the basic queries like select,insert... . but i need to improve the query knowledge by knowing how to write complex queries
.So can you help me out in this to improve in queries

bye
mano
Re: Problem In Starting Oracle..... [message #204489 is a reply to message #204483] Mon, 20 November 2006 23:59 Go to previous messageGo to previous message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
CREATE TRIGGER trig1
2 AFTER INSERT ON T4
3 REFERENCING NEW AS newRow
4 FOR EACH ROW
5 WHEN (newRow.a <= 10)
6 BEGIN
7 INSERT INTO T5 VALUES(:newRow.b, :newRow.a);
8* END trig1;
CREATE TRIGGER trig1
*
ERROR at line 1:
ORA-04089: cannot create triggers on objects owned by SYS



hi this the error iam getting when i try to create triggers can u help me plzzz.

bye
mano
Previous Topic: RAC
Next Topic: Installing Oracle database server in Windows XP home
Goto Forum:
  


Current Time: Sun Dec 04 08:39:51 CST 2016

Total time taken to generate the page: 0.11775 seconds