Calling Oracle DBA's - oka doubt

[Balibabu]

nenu middleware but oka Oracle XE ne install chestunna on linux machine.....installation ayyaka

 

Installation antha ayyaka e below step kada tannutundi:

To use the SQL Command Line, follow these steps:

1. Start SQL*Plus and log in as SYSTEM:

   $ sqlplus system
   Enter password: SYSTEM_password
   

Correct password enter chesaka e below error vastundi? edina workaround vunda?

 

Enter user-name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

 

[nothing_nothing]

arey bali middleware e skill ra 

[Balibabu]

13 minutes ago, nothing_nothing said:

arey bali middleware e skill ra 

all except IBM ra

[nothing_nothing]

10 minutes ago, Balibabu said:

all except IBM ra

Ok ra bali

[Bondu_Babu]

Database start chesava . OS level ps -ef|grep pmon type Chey 

[Bondu_Babu]

And one more sqlplus / as sysdba Ani type Chey 

[micxas]

1 hour ago, Balibabu said:

all except IBM ra

adhenti middleware ante main IBM and Oracle ee kada

 

[Balibabu]

1 hour ago, Bondu_Babu said:

Database start chesava . OS level ps -ef|grep pmon type Chey 

 

1 hour ago, Bondu_Babu said:

And one more sqlplus / as sysdba Ani type Chey 

yeah DB running lo vundi and second option kuda try chesanu

e instructions follow ayyanu http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL126

Troubleshooting lo sysdba option kuda try chesanu from this forum http://itbloggertips.com/2013/11/fixed-ora-01033-oracle-initialization-shutdown-progress/

 

[Balibabu]

42 minutes ago, micxas said:

adhenti middleware ante main IBM and Oracle ee kada

 

IBM lo oka tealeaf tappa verey vati meda work cheya ledu...all Oracle and other products meda work chesanu

[Khan_Dada_]

If your database is in mount mode, then you cannot connect as system user or any other database user except SYS.

So below steps follow avvu:

 

export $ORACLE_HOME=give the oracle home path

export $ORACLE_SID=give the db name.

sqlplus / as sysdba

select open_mode from v$database;

If the output of the above is Mounted, then do below:

alter database open;

select open_mode from v$database;

if the output of the above is read/write, then go ahead and try again from  where you left.

[sainadh217]

Make sure you connecting to the running DB . If you are able to connect as sqlplus , check below

 

select name,open_mode from gv$ database;

 

 

[micxas]

11 hours ago, Balibabu said:

IBM lo oka tealeaf tappa verey vati meda work cheya ledu...all Oracle and other products meda work chesanu

Ahh okay..

[Buttertheif]