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