OraFAQ Forum: Server Administration » Problem In Starting Oracle.....

Home » RDBMS Server » Server Administration » Problem In Starting Oracle.....

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

Problem In Starting Oracle..... [message #203451]

Wed, 15 November 2006 03:07

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203455 is a reply to message #203451]

Wed, 15 November 2006 03:20

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203477 is a reply to message #203451]

Wed, 15 November 2006 04:23

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203489 is a reply to message #203477]

Wed, 15 November 2006 04:56

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203494 is a reply to message #203489]

Wed, 15 November 2006 05:15

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203498 is a reply to message #203494]

Wed, 15 November 2006 05:33

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203541 is a reply to message #203489]

Wed, 15 November 2006 08:12

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203542 is a reply to message #203541]

Wed, 15 November 2006 08:15

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

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203561 is a reply to message #203557]

Wed, 15 November 2006 09:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi JRowbottom

exactly right...

regards
taj

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203643 is a reply to message #203541]

Wed, 15 November 2006 23:01

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203645 is a reply to message #203643]

Wed, 15 November 2006 23:04

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203648 is a reply to message #203645]

Wed, 15 November 2006 23:29

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203652 is a reply to message #203648]

Wed, 15 November 2006 23:46

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203656 is a reply to message #203652]

Thu, 16 November 2006 00:03

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203661 is a reply to message #203656]

Thu, 16 November 2006 00:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
go through posted link in my previous post.

regards
taj

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203670 is a reply to message #203661]

Thu, 16 November 2006 00:24

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203672 is a reply to message #203670]

Thu, 16 November 2006 00:28

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203675 is a reply to message #203672]

Thu, 16 November 2006 00:31

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203678 is a reply to message #203675]

Thu, 16 November 2006 00:34

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203682 is a reply to message #203678]

Thu, 16 November 2006 00:41

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203693 is a reply to message #203682]

Thu, 16 November 2006 01:13

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

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203721 is a reply to message #203720]

Thu, 16 November 2006 02:24

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

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

Attachment: testdatabase.html
(Size: 26.37KB, Downloaded 1440 times)

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203730 is a reply to message #203727]

Thu, 16 November 2006 02:42

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;

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203736 is a reply to message #203730]

Thu, 16 November 2006 02:53

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203744 is a reply to message #203736]

Thu, 16 November 2006 03:25

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi
R U there ..... plz help me . iam waiting for your reply
Embarassed

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203794 is a reply to message #203744]

Thu, 16 November 2006 06:03

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #203909 is a reply to message #203794]

Thu, 16 November 2006 23:00

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204154 is a reply to message #203909]

Sat, 18 November 2006 04:16

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204161 is a reply to message #204154]

Sat, 18 November 2006 05:54

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

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi raj
thanks for ur reply and suggestion .....and ill follow ur words

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204384 is a reply to message #204277]

Mon, 20 November 2006 07:14

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204385 is a reply to message #204384]

Mon, 20 November 2006 07:18

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204387 is a reply to message #204384]

Mon, 20 November 2006 07:23

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

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204480 is a reply to message #204477]

Mon, 20 November 2006 23:12

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.

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204483 is a reply to message #204480]

Mon, 20 November 2006 23:24

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

Report message to a moderator

Re: Problem In Starting Oracle..... [message #204489 is a reply to message #204483]

Mon, 20 November 2006 23:59

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

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	RAC
Next Topic:	Installing Oracle database server in Windows XP home

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:58:25 CDT 2024